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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Drilldown zeroes shared array printed in group footer

Status
Not open for further replies.

pvirsf

Technical User
Aug 30, 2004
35
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top