Design Main report, Cross Tab or Sub report

[muthyapu]

I am new to crystal report and I want design below report . I will appericate you if you let me know what type(Main or Sub) of report I need to use and How. Thanks for your time…….


Table Data

Record_Type CustName BussinessName Amount Commission
S C1 B1 100.00 20.00
S C1 B1 200.00 40.00
S C2 B1 150.00 30.00
S C1 B2 100.00 20.00
S C2 B2 100.00 20.00
W C1 B1 100.00 20.00
W C3 B1 200.00 40.00
W C4 B1 150.00 30.00
W C5 B2 100.00 20.00
SA C1 B1 100.00 20.00
SA C2 B1 200.00 40.00
SA C3 B1 150.00 30.00
SA C4 B2 100.00 20.00
SA C5 B2 100.00 20.00


I want to Achive the below Report, Under B1, B2 ,, is the sum of Amount .
I want group by Record type and CustName for First two record types( “S, “W”).
For Recordtype “SA” I need sum of amount by BussinessName. I will

S

B1 B2 Total Amount Commission
C1 300.00 100.00 400.00 80.00
C2 150.00 100.00 250.00 70.00
_________________________________________________________
Total 450.00 200.00 650.00 150.00

W

C1 100.00 0.00 100.00 20.00
C3 200.00 0.00 200.00 40.00
C4 150.00 0.00 150.00 30.00
C5 0.00 100.00 100.00 20.00
__________________________________________________________
Total 450.00 100.00 550.00 110.00

STotal 900.00 300.00 1200.00 260.00

SA 300.00 200.00 500.00 130.00
______________________________________________________
GTotal 1200.00 500.00 1700.00 390.00
________________________________________________________

 

[muthyapu]

Hi Gurus any help please............

 

[Madawc]

You need to group by the 'C1' field - is that CustName? Get it doing that and showing totals - Crystal reports are best built up step by step. Do summary totals - see FAQ767-6524 if you're not already familiar with them.

Once you have that, save it and re-import and a subreport in the report header. Do a higher-level grouping, all of the Cs as distinct from SA.

If that fails, you might need a mock-crosstab - do a SEARCH to find out what that is. But it ought to work

PS. It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.

It's also normal to wait at least 24 hours before complaining about a lack of replies. It's not like it is something you've paid for.

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