SSRS Secondary reports per data in dataset
Have a Bill of Lading (BOL) report that is in SSRS from my ERP system. In
that dataset are rows for each item.
Need to generate a secondary report, Certificate of Analysis COA, for each
row that is an item and not "pallet or packaging material" that will print
with the BOL.
After BOL Prints I need to: Iterate through all rows determine if finished
good
if finished good pass param(s) to COA report.
Currently I have a sub report in my BOL and I only get the first row
evaluated in it. That reports shows where placed in my BOL as the last row
of the report. How do I print the BOL and then re-itearate all rows of the
dataset?
I cannot join multiple datasets in this report per the ERP system doesn't
do/allow this.
TIA
No comments:
Post a Comment