Need help with grouping 1

[blm]

I am using Crystal 11 with SQLServer 2005 with a stored procedure as a data source. I am new to Crystal and have no training. I am trying to re-create an existing report with the following Groupings.

Field1
Field2
Field3
Field4
Field3
I am currently using 3 groups with sub reports for each because each hierarchy has totals by date and could not get the grouping by date on the upper level when i had one sub report.

Is it possible to have 2 different fields on the same level of hierarchy so they can drill down at these levels?

 

[Madawc]

You can group using a formula field that looks at several different data fields. But each detail record has to end up in one group. Is that OK?

If not, take a look at crosstabs. Each crosstab can use a different grouping. It is much faster than subreports, because the subreport does a separate access of the database.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[blm]

The detail would need to be in separate groups. I'll look into the crosstab report to see if it will give them something close to what they want.

Thanks for your time.

 

[asknelson19]

Could you be please more specific..
if you could give an example of the fields that u r trying to do..it helps me to answer your questions..

 

[blm]

As a rough example


Region1
Total1
Day 1 5
Day 2 7
Grand total 12

Client1
Day 1 3
Day 2 4
Grand total 7


English
Day 1 2
Day 2 3
Grand total 5
French
Day 1 1
Day 2 1
Grand total 2

Client2
Day 1 2
Day 2 3
Grand total 5


English
Day 1 1
Day 2 3
Grand total 4
French
Day 1 1
Day 2 0
Grand total 1

Service1
Day 1 1
Day 2 3
Grand total 4


English
Day 1 1
Day 2 0
Grand total 1
French
Day 1 2
Day 2 1
Grand total 3

Service2
Day 1 5
Day 2 3
Grand total 8


English
Day 1 3
Day 2 2
Grand total 5
French
Day 1 1
Day 2 2
Grand total 3

So the client has different services and each service can belong to more than one client. They want totals by client and service separately, but rolled up into region. I believe I will have to separate into different reports, but any suggestions are always welcome

 

[Madawc]

Looks like a case for subreports. If you group by region and have your subreports in the group header, you should be able to used Shared Variables to pass back the result and total it for the group.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10