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