Crystal Reports - Issue With Shared Variables

[Former Member]

I am having an issue with shared variables that are going from my subreport to my main report. In my subreport I want to pass the sum of the formula ActualCFS and the count of field tbnatur.desc to my main report. I will focus on just one of these, as whatever the problem is with one seems to be the same problem with the other. In a nutshell, these formulas give me exactly what they should when they are on the subreport, so I feel they are working properly. The problem is that the value that is passed to the main report for both formulas are both exactly 554 short of what they each should be.

I have this formula in my subreport:

Shared NumberVar CountCFS;
CountCFS := CountCFS + Sum ({@ActualCFS});
CountCFS;

I have this formula in my main report:

Shared NumberVar CountCFS;
CountCFS

Again, when I place the formulas on the subreport they are correct. But the values on the main report are both short of what they should be by 554 and I absolutely cannot figure out why.

[abhilash_kumar]

Hi Seth,

Which section is the Subreport in and which section is the shared formula on the Main Report in?

-Abhilash

[Former Member]

The subreport is in Group Header #1 on the main report. The shared formula is in the Report Footer.

[Former Member]

So, I appreciate the help with this and am sorry to have wasted anyone's time. When I manually add up the subreport column that displays on the main report, it turns out the shared variable is actually correct. I guess maybe due to some of the linked parameters I have perhaps some things are not making it on the main report thus not being added thus the different number than the subreport? I'm not sure, but, the calculation is apparently correct.

[abhilash_kumar]

Hi Seth,

Could you please try these:

1. Create a formula @disp_shr to display the value of the shared variable on the Main Report's group:

shared numbervar CountFS;

Place this on Group Footer#1.

2. Create a reset formula and place this on the Group Header:

shared numbervar CountFS := 0;

3. Does the @disp_shr formula show the correct value for each group the subreport runs for?

4. If yes, modify the @disp_shr formula to:

shared numbervar CountFS;
shared numbervar gtot;
gtot := gtot + CountFS;

5. Create one final formula to display the grand total and place this on the Report Footer:

shared numbervar gtot;

-Abhilash