Question Re: Crystal Reports - Issue With Shared Variables in Technology Q&A

Crystal Reports - Issue With Shared Variables

Former Member — Tue, 26 Nov 2019 21:15:49 GMT

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.

Re: Crystal Reports - Issue With Shared Variables

DellSC — Tue, 26 Nov 2019 21:56:20 GMT

1. Are you initializing CountCFS to 0 in the main report before the first time the subreport is called? The best way to do this would be in the report header section with a formula that looks like this:

Shared NumberVar CountCFS := 0;
""

The empty string at the end ensures that it doesn't display anything.

2. What type of section are you displaying it in? Is it AFTER all of the subreports have run? The variable won't have a complete value until after they've all run.

3. Try constraining which pass the variable is calculated in by making "WhilePrintingRecords;" the first line in all of the formulas.

-Dell

Re: Crystal Reports - Issue With Shared Variables

abhilash_kumar — Tue, 26 Nov 2019 22:02:25 GMT

Hi Seth,

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

-Abhilash

Re: Crystal Reports - Issue With Shared Variables

Former Member — Tue, 26 Nov 2019 22:16:35 GMT

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

Re: Crystal Reports - Issue With Shared Variables

Former Member — Tue, 26 Nov 2019 22:22:54 GMT

1. I have added this into the report header.

2. I do have the shared value after the subreport has ran. Again, it's passing a value, it's just 554 short of what it should be passing. I know the formula on the subreport end are good because all of the math is correct there. It just gets wonky on the main report.

3. Added WhilePrintingRecords;

Tried all of these suggestions and it is still displaying the incorrect value on the main report.

Re: Crystal Reports - Issue With Shared Variables

DellSC — Tue, 26 Nov 2019 22:28:14 GMT

How many times does the subreport run and what type of section is the formula in on the subreport?

-Dell

Re: Crystal Reports - Issue With Shared Variables

Former Member — Tue, 26 Nov 2019 22:40:44 GMT

The subreport only runs once. It is located in Group Header #1 in the main report. The formula is on the Report Footer in the subreport.

Re: Crystal Reports - Issue With Shared Variables

abhilash_kumar — Tue, 26 Nov 2019 22:50:24 GMT

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

Re: Crystal Reports - Issue With Shared Variables

Former Member — Tue, 26 Nov 2019 23:32:42 GMT

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.

Re: Crystal Reports - Issue With Shared Variables

Former Member — Tue, 26 Nov 2019 23:33:03 GMT