I have placed a subreport in the Details "A" section. This subreport is passing a shared numbervar to the main report. (It calculates the # of days between 2 dates).

I placed the shared variable in Details "B" section and it displays correctly.

HOWEVER...
I want to use that value in a formula in Details "B" section. The minute I add the shared variable into a formula to add to another date in the main report, the shared variable gets set to 0...just on the first record. And then all of the other records are 1 off. What am I missing here?

Subreport in Details Section A:
WhilePrintingRecords;
Shared numbervar payPeriodDiff := datediff("d",{CCalendar.periodBegin},{CCalendar.periodEnd});
payPeriodDiff

Formula I am trying to use this in, in Details Section "B":

WhilePrintingRecords;
datevar newHireAdd;
shared numbervar payPeriodDiff;
datevar newHireStartRT;

    if {@YYYPayFrequency} = 'Weekly'
    then
    newHireAdd := cdate(dateadd("ww",1,{@NewHireRT}))-1
    else if {@YYYPayFrequency} = 'Bi-Weekly'
    then
    newHireAdd := cdate(dateadd("ww",2,{@NewHireRT}))-1
    else if {@YYYPayFrequency} = 'Monthly'
    then
    newHireAdd := cdate(dateadd("m",1,{@NewHireRT}))-1
    else if {@YYYPayFrequency} = 'Semi-Monthly'
    then
    newHireAdd := cdate(dateadd("d",payPeriodDiff,newHireStartRT));



If I display the shared variable separately in a formula in Details B, it shows the correct number. However when it is used in the formula to add to the date in the same section, it is 0. The parameter it is using is the "Semi-Monthly" one.



Edited by jensohl94 - 02 Nov 2015 at 10:31am

Yes, I am using that field to display newHireAdd. Adding the variable to the end of the formula did not make a difference.

Is the subreport above the section where you're using the date or below it? It must be above it.

-Dell