Click to See Complete Forum and Search --> : Vertical Count Reporting


Manjunair
September 7th, 2006, 04:07 PM
Hi all:
I use Crystal Reports 8 (I know I am living in the dinosaur era- eventually we may move to a recent version). My dilemma is , my boss wants a report of the number of cases that were logged in for the past two years for each place. Broken down by month and with the month broken down by name. I can easily do this by inserting groups in the report. But the count will be displayed horizontally. I would be nice if the counts are displayed vertically like this below:

1/2004 2/2004 3/2004
name1 Name2 name1 name2
place1 1 3 1 4
place2 4 1 2 5


Is it possible to do this in Crystal Reports without writing queries for each month and dropping into a stored procedure and all that.
Any help will make my day.
Thanks,
Manju.