Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Reporting Services Development  Crystal Report - Crosstab

Author  Topic  egghi Starting Member 17 Posts Posted - 2006-10-17 : 13:56:55 Hi, I created a crosstab in Crystal Report pulling data from SQL database. The data is grouped by department and then by user (ROW). There are three columns: # of order, # of error, and accuracay rate. I have formulas to calculate stats for the first two columns. However, it's tricky to get the accuracy rate because it's in percentage and it's calculated by (1-(# of error / # of order) . For example, user, egghi, has processed 20 orders, and accumulated a total of 1 error. The accuracy rate for egghi is 95%. How do you get the crosstab to calculate the accuracy rate though since Crystal Report's crosstab is not very "percentage friendly"? Thanks a bunch!