My report runs on CR 9 on a SQL Server data base. Formula P_A prints the value of an array element A[1], being used to do a manual running total, in a level 3 group footer. A[1] is assigned a value in the hidden details section. At the zero level view (no drilldown), it prints correctly in the Group 3 footer.
Upon drilldown, P_A prints at the bottom of the details and now shows zero.
The arrangement and content of my formulae is as follows:
RH section
PH section
GH1
GH2
GH3 contains the formula:
I_A
WhilePrintingRecords;
Shared NumberVar Array A := [0, 0, 0];
1
Details(a) is hidden for drilldown and contains the formule:
P_Detail
{databasefield}
S_A ... is suppressed in format so nothing prints for this formula, but it still evaluates in the section
WhilePrintingRecords;
Shared NumberVar Array A;
If(Test)
Then (
A[1] = A[1]+1;
A[2] = A[2]+10;
A[3] = A[3]+20;
1
)
Else 2
G3F is not hidden or suppressed & contains the formulae:
P_A1
WhilePrintingRecords;
Shared NumberVar Array A;
A[1]
P_A2
WhilePrintingRecords;
Shared NumberVar Array A;
A[2]
As I said P_A1 and P_A2 print correctly when at the zero drilldown level. When drilling down to details, they both appear as zero at the bottom of all the detail records printed.
I dont understand why since their values are set in the details section, they should be evaluated when drilling down, and then the totals should print in the subsequent group 3 footer.
Any thoughts out there? I need to solve this this morning if possible. You all have been so helpful in the past, please come through again. Thanks a million in advance. R
Upon drilldown, P_A prints at the bottom of the details and now shows zero.
The arrangement and content of my formulae is as follows:
RH section
PH section
GH1
GH2
GH3 contains the formula:
I_A
WhilePrintingRecords;
Shared NumberVar Array A := [0, 0, 0];
1
Details(a) is hidden for drilldown and contains the formule:
P_Detail
{databasefield}
S_A ... is suppressed in format so nothing prints for this formula, but it still evaluates in the section
WhilePrintingRecords;
Shared NumberVar Array A;
If(Test)
Then (
A[1] = A[1]+1;
A[2] = A[2]+10;
A[3] = A[3]+20;
1
)
Else 2
G3F is not hidden or suppressed & contains the formulae:
P_A1
WhilePrintingRecords;
Shared NumberVar Array A;
A[1]
P_A2
WhilePrintingRecords;
Shared NumberVar Array A;
A[2]
As I said P_A1 and P_A2 print correctly when at the zero drilldown level. When drilling down to details, they both appear as zero at the bottom of all the detail records printed.
I dont understand why since their values are set in the details section, they should be evaluated when drilling down, and then the totals should print in the subsequent group 3 footer.
Any thoughts out there? I need to solve this this morning if possible. You all have been so helpful in the past, please come through again. Thanks a million in advance. R