Hello,

I have 3 drillable groups and can’t figure out why Groups 2 and 3 are not returning all of the data in their tables.

I have 3 db queries linked together but the results being returned are only the top record from each of the queries.  Group 1 works fine because there is only one field per State;

But Group 2 only grabs the top County from each State; Group 3 only grabs the first City from each County, etc., etc.,etc.. I need to sum all of the data in these Groups  to show a total by County, City and not just the first record for each County.

The linked queries return all of the data fine and (I believe) are linked together correctly.

Am I missing something really easy here?  

Thanks for your help

Thanks again - real close but I am not explaining myself well enough.    I might be able to just take away the SUMS in the SQL but because the data is transaction data, I can't group them the way the user wants.  I was told (by the Lead Engineer) that the only way to get this data to roll-up at all is to do the 3 separate queries by STATE as a link.  My issue is that I am not getting the proper SUM in the GH sections.  Group 1 shows FLORIDA with sales of 50,000, from one line of data; but at a County level it might actually be  50 lines that roll-up into the State with an amount of 100,000.  The SUMS make no sense to me, but I know for a fact that Crystal is not summing up the GH sections in Group 2 and 3; it is only pulling the first line of data from the result set.....and I need it to SUM, no matter how goofy the data looks..

I hope this explains it well enough, if not, I can post a reply on Monday with a full example if necessary.

Thanks again for all of your help.

Hey DBlank thanks again,

Nope that doesn't work in my case.  When I insert a SUM in the RF and move it into the GH section, it is then summing up all of the data for the group, not just the Counties per GH1 (STATE)  STATE selection in my Group 2 field.  Basically, if I select Group 1 (STATE), it sums up perfectly; if I drill into Group2 (COUNTY), it then only grabs the first record for the COUNTY data set and the SUM function SUMS up all of the COUNTIES for that STATE, not the individual COUNTY...

EXAMPLE:

GROUP 1 (query 1)  STATE (the SUM per STATE is fine)

If I drill into a STATE, it then becomes GROUP 2 (query 2) COUNTY - here is where only the first record from my query 2 gets pulled in the field (I am expecting to see 3 fields); if I do a SUM, it adds up all COUNTIES from Florida (approx 50 records)....

I am flummoxed..  I hope I have explained this well enough.

Thanks again,