Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Drill down report with charts 1

Status
Not open for further replies.

ching0418

MIS
Mar 6, 2002
96
HK
I have a report with 4 groups which are using the drill down function...each group should contain a graph

Delivery per Country graph (Report Header)
Delivery per Office graph (Country grouop header)
Delivery per Year graph (Office group header)
Delivery per Month (Year group header)

When i drill down on a Country, i should see the office graph and the data of all offices. But the Year graph is shown already, it should be shown when i drill down on an office.

please help! thanks!
 
Which version of Crystal Reports are you using ? If it is 9 or above there is a function called DrillDownGroupLevel. This can be used to conditionally suppress sections or items depending on how far down you have drilled.

Eg the suppression formula would be something like:
Code:
if drilldowngrouplevel=1 then false else true

This would only show the section if you have drilled down one level.

ShortyA
 
Create agroup for country and place the country graph in this group header.

HTH

Gary Parker
MIS Data Analyst
Manchester, England
 
To GJParker,

i did that already but i still have that problem.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top