Home > Ax 2012, Dynamics Ax, Dynamics Ax Books > SSRS Tip: Speed up RDP based SSRS reports testing in Dynamics Ax 2012

SSRS Tip: Speed up RDP based SSRS reports testing in Dynamics Ax 2012

September 11, 2013 Leave a comment Go to comments

When working on precision designs a lot of time is spent on waiting for the preview to run. If your precision design uses an RDP dataset here is a simple and fantastic tip to speed up.

1. Convert your temporary table to persistent by modifying the TableType property to Regular

2. Now run the report once. Either from Visual studio or inside Ax. This fills the data in the temporary table.

3. Comment the code inside processreport method or simply write a “return” statement on the first line of the method.

That’s it. you are now geared for a faster execution of the reports. Remember to revert back once you are done or wait for the testers to find it 🙂 but don’t let it go to the production.

For more tips and learning about SSRS – AX 2012 order the book Dynamics AX 2012 Reporting Cookbook authored by me.

7720EN_MockupCover_Cookbook

Related articles
  1. No comments yet.
  1. October 6, 2013 at 7:07 am
    Productivity tip: Do you need the under score when naming – Dynamics Ax | My Blog
  2. October 5, 2013 at 10:28 am
    SSRS Tip: Printing Row headers in every page - Dynamics Ax 2012 | Dynamics Ax LoungeDynamics Ax Lounge
  3. October 4, 2013 at 9:11 am
    Productivity tip: Do you need the under score when naming - Dynamics Ax | Dynamics Ax LoungeDynamics Ax Lounge
  4. October 4, 2013 at 8:45 am
    Productivity tip: Do you need the under score when naming – Dynamics Ax - Casperkamal’s Dynamics AX Blog - Microsoft Dynamics AX - Microsoft Dynamics Community
  5. October 4, 2013 at 7:49 am
    Productivity tip: Do you need the under score when naming – Dynamics Ax | Casperkamal's Dynamics Ax blog
  6. September 30, 2013 at 3:02 pm
    SSRS Tip: Printing Row headers in every page – Dynamics Ax 2012 - Casperkamal’s Dynamics AX Blog - Microsoft Dynamics AX - Microsoft Dynamics Community
  7. September 25, 2013 at 8:30 am
    SSRS Tip: Prevent report execution through controller – Dynamics Ax 2012 - Casperkamal’s Dynamics AX Blog - Microsoft Dynamics AX - Microsoft Dynamics Community
  8. September 25, 2013 at 8:09 am
    SSRS Tip: Prevent report execution through controller - Dynamics Ax 2012 | Dynamics Ax LoungeDynamics Ax Lounge
  9. September 25, 2013 at 7:50 am
    SSRS Tip: Prevent report execution through controller – Dynamics Ax 2012 | Casperkamal's Dynamics Ax blog
  10. September 23, 2013 at 7:45 am
    SSRS Tip: Printing Row headers in every page – Dynamics Ax 2012 | Casperkamal's Dynamics Ax blog
  11. September 21, 2013 at 6:20 pm
    SSRS Tip: Using invisible parameters in contracts - Dynamics AX 2012 | Dynamics Ax LoungeDynamics Ax Lounge
  12. September 18, 2013 at 9:46 am
    SSRS Tip: Using invisible parameters in contracts – Dynamics AX 2012 - Casperkamal’s Dynamics AX Blog - Microsoft Dynamics AX - Microsoft Dynamics Community
  13. September 18, 2013 at 7:46 am
    SSRS Tip: Using invisible parameters in contracts – Dynamics AX 2012 | Casperkamal's Dynamics Ax blog
  14. September 16, 2013 at 8:16 am
    SSRS Tip: Using labels for dynamic texts in SSRS reports – Dynamics Ax 2012 - Casperkamal’s Dynamics AX Blog - Microsoft Dynamics AX - Microsoft Dynamics Community
  15. September 16, 2013 at 7:45 am
    SSRS Tip: Using labels for dynamic texts in SSRS reports – Dynamics Ax 2012 | Casperkamal's Dynamics Ax blog

Leave a comment