Grouping Crystal Reports

Hello

I have 4 different rows of information that I am trying to group and just show the summaries for the different groups

I have

report type,  account level,  loan type, weight

I need to group them by report type and with in that report type by account level. Right now it looks like

report     acct lvl     ltype     weight
13            99            L34       -947.41

But there are thousands of entries and hundreds of pages, what I want it to look like is

report     acct lvl     ltype    total    weight
13            99            L34      114     -197442.32
13             99           L76       10       -1582.87
13              99          L9           4       -3862.61
6                99          L34        22      -34932.66
6                99          L76        18       -27966.11
6               99           L9           7        -4820.08

and so on

so it is combining the report numbers and seperating them by ltype and giving the sumary

I am new to crystal reports so any help is greatly appreciated.

I am running Crystal Reports 2008

Thanks
Nathan WebbAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
mlmccConnect With a Mentor Commented:
Open the report
Click INSERT --> GROUP
Choose the ReportType field

Repeat for the Level field

Right click the TOTAL field
Click INSERT --> SUMMARY
Put it in the groups you wnt it in

mlmcc
0
 
Nathan WebbAuthor Commented:
Thanks for the quick response, how do I make it hide all of the other information generated but the totals that i want?

Thanks
0
 
mlmccCommented:
What don't you want to see?

You can suppress fields and sections.

mlmcc
0
All Courses

From novice to tech pro — start learning today.