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 Mike Lewis 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

Status
Not open for further replies.

ennisro

Programmer
Apr 21, 2014
1
US
My CR version is CR-2008.

I am trying to create a simple summary report with two associated drill-downs.
The input records being reported represent accounts of two types. Each input
record has three relevant fields: ACCT_ID, ACCT_TYPE and AMOUNT. ACCT_ID is an
alphanumeric string, the value of ACCT_TYPE is either 'T1' or 'T2' and AMOUNT
is a numeric value representing dollars.

Each row of the summary report is to have six columns:
T1_COUNT, T1_AMOUNT, T2_COUNT, T2_AMOUNT, TOTAL_COUNT, TOTAL_AMOUNT.

My original plan was to segregate the input records into separate detail sections
by ACCT_TYPE. This would be done with suppression formulas. For one detail
section the suppress condition would be ACCT_TYPE <> 'T1', for the other it would
be ACCT_TYPE <> 'T2'.

Details are to be hidden at the summary level. But clicking on T1_COUNT or
T1_AMOUNT should reveal T1 input data. Clicking on T2_COUNT or T2_AMOUNT should
reveal T2 input data.

After spending too much time trying to create the report as described above it
appears to me that my approach is not compatible with the way Crystal Reports
functions. This seems pretty clear because the Section Expert panel doesn't
have an "X*2" suppress button next to the "Hide (Drill Down OK)". This means
there is no way to suppress one detail section and allow another to show through
when a dril-down is invoked.

Any suggestion or advice on how to create this report would be greatly appreciated
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top