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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Control printing of mu...
Microsoft Dynamics AX (Archived)

Control printing of multiple SSRS reports

(0) ShareShare
ReportReport
Posted on by Samy123 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
    Sohaib Cheema 49,438 User Group Leader 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
    Martin Dráb 237,967 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
    Samy123 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
    Martin Dráb 237,967 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
    Samy123 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans