Print Page | Close Window

Beginner Grouping Question

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12958
Printed Date: 04 May 2024 at 1:03pm


Topic: Beginner Grouping Question
Posted By: abernut
Subject: Beginner Grouping Question
Date Posted: 19 Apr 2011 at 5:07am
Hello everyone.
I am pretty green at using Crystal but it's something that I must learn for work. 

I  need to generate a sales report.  No problem right, well.

They want it to show the total sales for the entire "Parent" which includes all of its children. 

In the  database there is a table that list the cmp_parent. 

I can join the  two tables I need but it's creating a drill down report and all they want is one line for each parent.


Replies:
Posted By: hilfy
Date Posted: 19 Apr 2011 at 5:22am
To drill down from Parent to Child:
 
1.  Group on Parent. 
2.  Create another group on Child.
3.  Place your fields and summaries as you want them to appear on the report, including the drill-downs.
4.  Hide the Child group sections - in the gray area to the left of the sections, right-click and select "Hide".  (There IS a difference between Suppress and Hide!)
5.  Suppress the details section unless users will drill down from child to transactions in which case you'll Hide the section.
 
You'll probably have to play with formatting in order to get the column headers set up correctly for each level of drill-down, but this should get you started.
 
-Dell 


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: abernut
Date Posted: 19 Apr 2011 at 5:25am
Awesome.
I will try this and post my results.

Is there a way to attach screen shots.


Print Page | Close Window