?
Solved

Grouping Crystal Reports

Posted on 2011-02-17
3
Medium Priority
?
314 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:Nathan Webb
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 34919283
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
 

Author Comment

by:Nathan Webb
ID: 34919995
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
 
LVL 101

Expert Comment

by:mlmcc
ID: 34921214
What don't you want to see?

You can suppress fields and sections.

mlmcc
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question