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
NathanAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
NathanAuthor 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
mlmccCommented:
What don't you want to see?

You can suppress fields and sections.

mlmcc
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.