Bring number from a Sub Report to the Main Report

[FastEddie]

I am trying to get the 6, which is shown under column B to show where I have the red number circled.



I thought I could go to the Sub Report and do this:

Shared NumberVar colBx = Sum ({@CkColB}, {TicketItems.ServiceCode})

Then on the main form I am trying to get the number like this:

Shared numberVar ColBx

But I am only getting 0's in return. What am I doing wring?

[svobill]

Are the subreport and the data in the same section (e.g. Details). The problem may be that the data in the main report is being obtained before the subreport runs (so you get a zero).

Try splitting the section into two parts and move the subreport into the first section. This will force the subreport to run before your main report data is obtained.