Skip to main content

Notifications

Microsoft Dynamics GP forum
Suggested answer

Table Contents not printing on screen and/or printer from Resource Reports

Posted on by 185

Am attempting to print to the screen reports displaying the raw contents of various tables...e.g., customer_mstr_raw report.  No data shows when these reports are executed with the print icon on the menu bar.  I know the data is there because I can run my system and display the customers, etc.  I cannot print any "raw" reports that I have defined (and I have defined many).  This is a good way to debug data.  I can do this in other systems I've built, but not this one.  It has happened before and for the life of me I can't remember what I did to fix this problem.  Any help, please!!!

thank you....herb

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,831 Moderator on at
    RE: Table Contents not printing on screen and/or printer from Resource Reports

    If you are actually in Report Writer, make sure you have security access to the tables you are trying to use data from.

    Why not just use SQL? Especially if this is only for Development or Debugging.

    David

  • HerbL Profile Picture
    HerbL 185 on at
    RE: Table Contents not printing on screen and/or printer from Resource Reports

    Sometimes it is nice during development and/or debugging code to be able to display some of the raw data.  This is an easy way to display it because  you don't have to include a "run report": statement in your code, and then go to execution (test mode) to display results.  I don't use SQL, and am confused as to why this works for my other systems I have written and not here in this one.  (It used to, but something is keeping it from printing to the screen and/or the printer).  

    Thank you....herb

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Moderator on at
    RE: Table Contents not printing on screen and/or printer from Resource Reports

    Hi HerbL,

    I'm a little confused... why would you go the hard way to show raw data in GP custom reports when it is so easy to get them thru Excel or SSRS directly from the SQL tables ?  GP reports aren't really meant to be used to extract 'raw' data from the system...

  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,831 Moderator on at
    RE: Table Contents not printing on screen and/or printer from Resource Reports

    Assuming you have created custom reports in report writer, have you granted security access to the reports. You then need to use the reports >> custom reports window to print them.

    Why not just go to the SQL tables or use SSRS?

    David

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans