Solved

Grouping Crystal Reports

Posted on 2011-02-17
3
312 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 100

Accepted Solution

by:
mlmcc earned 500 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 100

Expert Comment

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

You can suppress fields and sections.

mlmcc
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
Suggested Courses

734 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