Hello all I'm kinda new at Crystal Reports XI. I have a report that I need to make currently it is based off of date in a Microsoft SQL Server 2005 Table. What I want to do with the report is take the value of one column which could have could have 1 of 7 different values in it and count those different values. But I want to list each value in its own column. So that when it counts how many of each different value for that day I can see the statistics for that day and begin to start doing some math calculations with it. I have gotten it to list the different values and do a count on those different values but I can't get them to be there own column sections. Also when it does list the different values it only shows the ones for that day currently I need it to show a 0 for that day if it isn't showing up. Any help with this would be appreciated.

Edited by Pyrotecnix - 25 Jun 2010 at 3:07am

This is how the form will end up if you look at the columns there are 5 different columns with different counts. Take the Transports column it has two different codes in the DB for that column. So I want to see if there was a total of 20 records for that day and 3 of them were one of the 2 codes it counts the two codes and my count for that day would be 3. Same goes for Cancelled there is two codes for this column as well and each of these columns would need to look at the same field in the database lets call it trans_type so there is a few different values in this column that I need to track for that day and separate out into different columns. Thanks again for helping out. Please let me know if you need more clarification.