1 report with 100 groupings and 1000 formulas???

[cmpgeek]

I am writing a report that needs to list whether or not there was a case going on in a particular room at a particular time. My boss wants it to be formatted like a cross tab report with the time intervals going down and the rooms going across the page. I was hoping that i could write it as a cross tab report, but the more i tried the more frustrated i got. MY biggest issues are that the time intervals my boss wants on this report is every 15 minutes. which means 96 separate groupings... there are also 12 rooms that will be looked at... when you take the number of groupings and the number of formulas i would need for each grouping, i end up with a total over 1100!

if that is the only way to do the report, then i will get started right away, but i have a feeling i am overlooking something rather obvious because i can not imagine having a report with that many groupings and / or formulas...

i am using Crystal 8.5 on an Oracle database...

any suggestions would be greatly appreciated...
thanks...

[malleyo]

Are you using VB to generate the report? If so, you could do all your queries in VB and use CDO to pass the info into Crystal. I'm not sure about you're needs, but I've found it easier to get the data I need with one or more queries executed in VB and then passing the data to Crystal.

CDO (Crystal Data Objects) works by populating an array with your data. You would basically be creating your own "recordset" (called rowset in CDO).

If you want info on CDO, look at my post here:

http://www.codeguru.com/forum/showthread.php?s=&threadid=281658&highlight=cdo

[cmpgeek]

unfortunately, the things you have mentioned are completed foreign to me... :(

i started a new cross tab from scratch, and it is working, but i have a couple problems with it still...

while i do not have the options checked to suppress empty rows and columns, it is doing it anyway...

also, i have it setup to count the number of cases that start within each 15 min interval, but what i truly want is a count of cases that are happening within that 15 minute interval... (ie... if 2 cases start between 0800 and 0815, but there are also 2 cases that started earlier that are still being done, i want crystal to tell me there are a total of 4 cases going on at that time.)

right now, i have the groupings based on {case.room_start} and sorting in a specified order that i set up at 15 min intervals... but because i set it up in the group's sorting option, i can not use other fields to help set up the sort... i see that "and" option, but not an "or" option... if that makes sense... i am just trying to figure out how to give "credit" to a room that may have started in a previous 15 min interval so that it shows as being used during that interval...

i feel like i am talking in circles, and i apologize if that is how it is coming off as well...

thanks for taking the time to read this...
cmpgeek