- When printing second Report, first record prints too! How do I fix this issue? Below is an image of what the report prints. Please excuse the blacked-out marks.
Thank you
*This post is locked for comments
Hi Lhamo
I'm not able to see any image.
Also, can you clarify better the issue?
Hi,
Report is printing two data sets(record sets) simultaneously. For example, Sales order # 123 is entered and saved. When I enter another brand new Sales order # 345 and hit print menu button on top of form, it renders 1st record and 2nd on the same report!
It seems really odd! Maybe some modification in RDP class code is needed? Or modification on report design? For report design, I used tablix and it has all the fields.
Any suggestions? Thanks!!
To be more clear, I'm trying to have SSRS report print only one record per page. When I print a report, the previous report prints as well on page of its own. So it would be two page report with 1st records set from 1st entry and then it also prints 2nd record set on the 2nd page. Can I accomplish this through writing X++ method on RDP class? or any other suggestions will be greatly appreciated.
Additional information below after some design changes on SSRS report in VS below:
I modified the report design and incorporated all the fields into one big tablix and that resolved this earlier issue. Now it only prints one records set per page. However, the issue now I'm facing is that now it prints earlier record set on the second page. My goal is to print only the report that is needed per that record not the previous entry. This could cause lots of issue in production environment in terms of printing unnecessary large volumes of report. Any thoughts on this issue? Maybe some X++ code modification? Thank you so much for your help!!
Dear Lhamo,
This is related to report design. What you need to do is to create a row group that groups the records by Order ID. Then you will need to create page breaks between each instance.
Regards,
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Tocauer 4
Community Member 2
Nayyar Siddiqi 2
