I'm using SQL Server 2012 and have a report with multiple subreports for a hospital. I populate the page header using code and a public function. I have a parameter for Unit so I can send this report to its respective unit. When I run
it in BIDS and select a specific unit I get only that unit and it runs as expected. I then created a data-driven subscription. When I look at the output it is generating the correct data in the body, but the page header is displaying the wrong
patient data. Can anyone please help?
From your description, the patient which is returned by a custom code is incorrect on page header, right? I hard to say the reason without any detail report information. In order to trouble shoot this issue more efficiently, I need to clarify some information.
Please post sample custom used in your report.
Please describe the design steps about your report.
Please post some screenshots about it.
It is benefit for us to do further analysis. Thank you for your understanding.
If you have any feedback on our support, please click