web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)
Answered

Control printing of multiple SSRS reports

(0) ShareShare
ReportReport
Posted on by 455

Hello community

I want to control printing of multiple (Three) SSRS reports from a single parameter screen I am able to generate the reports with one click but they print according to their respective default print settings one after another for example when the first report is executed I get its parameter screen/dialog and I select print destination as Printer hit OK and it goes to the printer next the second report pops up on the screen next third report's parameter screen/dialog pops up and I need to hit OK to get it printed.

I am trying to control all three report with one parameter dialog where a user can choose a print destination and all three reports remember that setting and print to the chosen destination.

Can someone guide me how to achieve this?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Sohaib Cheema Profile Picture
    49,668 Super User 2026 Season 1 on at

    that is possible

    Create a customized Dialog where user will select parameters of reports and user will also select printers on this dialog.

    send the information to your respective controller classes

    Have a look at next two links

    technet.microsoft.com/.../ee873254.aspx

    dev.goshoom.net/.../printing-reports-from-code-in-ax2012

  • Verified answer
    Martin Dráb Profile Picture
    239,932 Most Valuable Professional on at

    You'll have to override print settings in code. Here I have an example of changing them to hard-coded values; you'll want to use values from your dialog.

  • Samy123 Profile Picture
    455 on at

    Thanks Sohaib and Martin for your guidance. I got this working BUT run into strange issue.

    The reports that I override the print settings and bypass their parameter dialog are behaving the same way when printing from their original menuitems. for example when I go to print a work order from its original location different menuitem it goes straight to printer without showing its parameter screen, I know I override it in my separate controller class that is triggered by a different menuitem but why the controller settings are mixing up? should be separate right?

    I don't know what I am doing wrong here.

  • Martin Dráb Profile Picture
    239,932 Most Valuable Professional on at

    You would have to give us concrete information about how you changed the controller and how you call it. We can't tell you where the bug is if we don't know anything about your code.

  • Verified answer
    Samy123 Profile Picture
    455 on at

    Martin I got a workaround this problem, looks like the ssrs is saving some "last used values" in a SysLastValue Kernel-level table. When I run the report it fetches the settings from this table and execute it according to the last used values. I added following a line in my respective controller classes

     controller.parmLoadFromSysLastValue(false);

    Now it works as expected!

    Do you know of a better solution do let me know.

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.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Sanhthosh.Kumar.K Profile Picture

Sanhthosh.Kumar.K 2

#2
Raed Salah Bzour Profile Picture

Raed Salah Bzour 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans