Passed variable from Subreport to Main skips one row

[BradCustom]

Hi Everyone and thanks for your help in advance!

I'm using Crystal reports 2016 and I'm having a problem with passing a shared variable. Oh the subreport "Sub-PartActInv" I have the following formula which passes the Unit Price to the Main Report.

Here is the formula for the shared variable which is in the Report Footer of the Subreport.

whileprintingrecords;
shared currencyvar unitprice := 
if isnull ({Invoice_Detail.Unit_Price})
then 0
else
{Invoice_Detail.Unit_Price}

In the Main report I have placed the Subreport in Group Footer 1B and the shared variable formula in Group Footer 1C. Below is the formula for the variable on the Main report.

whileprintingrecords;
shared currencyvar unitprice;
unitprice

The value that is reported by the shared variable is off by one row. So, the value for row 1 is shown on row 2.

Any help would be very much appreciated.
Thanks You

 

[kray4660]

Everything appears to be correct, have you verified that the unitprice is indeed getting the correct value in sub-report (i.e., display the value in GF 1B)? Second, make sure that unitprice is not any other formula where the value could be modified.

 

[BradCustom]

Thanks for responding!

I think it's correct too, that's why it's driving me crazy. Below is a screen shot of the main formula.

Here is a screen shot of the Main Report. The Unit Price field that is suppressed is from the Job table. The Unit Price I'm using in the Subreport is from the Invoice_Detail table.

Here is a screen shot of the Subreport.

In the picture I've uploaded the "Total Gross Revenue" is a field in the Subreport called "Sum Amout". It's a grand total summary of the "Amount" field in the Subreport. The field "Unit Price" is also a field from the Subreport called "unit_price". The field I am clicked on is the Passed variable for Unit Price. As you can see the first record is $0.00 and the second record is $59.14. Obviously, the first row should be $59.14 but I can't figure out why it's skipping one row. Typically it's a placement issue, passed field is before the subreport. However, I don't have that situation so I'm not sure why it's happening.

Thanks for your help and if I left anything out please let me know.
Brad

 

[fisheromacs]

Where is your subreport placed?
I think it will work best in your Group Header.

 

[BradCustom]

Thanks fisheromacs,
Your suggestion worked! I had to change the structure of the report but it works so that's the important thing!
Brad