SQL statements and select statements

[didi818]

OK, I am using some subreports and adding some values from those to a main report to get the information I need but I was wondering is there an easier way? What I need to do is make a report that shows # of IR's for multiple groups, the catch is that for one group the total number of Ir's is a sum of the total IR's for two groups. If I wrote two SQL queries for the data it would work but I can't seem to figure out how to use more than one query with Crystal......do I have some other options?

Thanks,
Diann

 

[synapsevampire]

Not much to go on here, but you might write this in a Stored Procedure or a View, and use that as the data source.

This was a nice catch: "The catch is that for one group the total number of IR's is a sum of the total IR's for two groups."

I think I understand the intent, that being that the data is wrong in the database for your reporting purposes, you need to roll up some groups further.

If you provide example data and expected output, it might make it easier to help.

Keyword *might* in this case.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com