I am trying to copy the sum of a field from a subreport to the details section of the main report and then I am trying to hide all the details based on that value being <0.
In the subreport I added formula: @TotalWIP
Then in the main report, I added a detail section below the existing detail section with formula: @TotalWIP
The problem is, it is entering the cumulative sum from the previous sections instead of the total for each section.
How do I reset the value for each detail line?
Then, how do I hide all the entire detail section based on that value say being less than 0?
In the subreport I added formula: @TotalWIP
Code:
WhilePrintingRecords;
shared numbervar x := x + ({Jobs.jmpProductionQuantity});
Then in the main report, I added a detail section below the existing detail section with formula: @TotalWIP
Code:
WhilePrintingRecords;
shared numbervar x;
x
The problem is, it is entering the cumulative sum from the previous sections instead of the total for each section.
How do I reset the value for each detail line?
Then, how do I hide all the entire detail section based on that value say being less than 0?