I have requirement, if the PO Line has only one release, hide the POForm_PORelPart subreport and to show the release number and the Due Date fields on the PO Line next to the part number. I added the PORel table to the POHeader dataset but that doubles the total costs if the line has two releases. Select DISTINCT does not help since the releases have different due dates.
I added a new row below the PO Line and set the visibility to false and set the first PO Line visibility to true if the number of releases was greater than one.
I am wondering if there is a way to accomplish this without doubling the total costs.
There can be a possibility that the PO release due date can be different than the PO Line due date.
I created POLine_Param and NumOfRel_Param whcih are getting their default values from the PORel dataset. Then I set the row visibility “=(Fields!POLine.Value = Parameters!POLine_Param.Value)”. This works if the PO has only one line. It gets even more complicated when there are multiple lines and some lines have more than one release. I don’t know how to match the POLine_Param to the POLine.
