In CR 8.5, I am passing a subreport value to the main report, then using the subreport field value in the main report. (I have the calculation in the step [em]below[/em] the step that is returing the sub-report value.) My issue is that once the subreport value gets populated with a non-zero value, it populates the shared field in the step [em]below[/em] the step that returns the value from the subreport but does not reset/initialize back to 0 or null once that record has been processed. It maintains that value in the shared main report field and calculation until the next non-zero value in the subreport. I have placed an initialization formula into multiple steps in the main report and in the first step of the subreport, testing for a location that will reset the shared field.
[strong]Record1[/strong]: Main report: Score1 = 755, Subreport Score2 = 822, Shared field Score2 in Main Report = 822, Calculation: If Score1 > Score 2,then Score1, else Score2.
[strong]Record2[/strong]: Main Report: Score1 692, Subreport Score2 = 0/Null, Shared field Score2 in Main Report = [strong]822[/strong]. Did [em]NOT[/em] pull back 0/Null for Score2.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!