Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Table Contents not pri...
Finance | Project Operations, Human Resources, ...
Suggested answer

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

(0) ShareShare
ReportReport
Posted on by HerbL 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

Categories:
Microsoft Dynamics GP
  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,928 Most Valuable Professional 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 Super User 2024 Season 1 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,928 Most Valuable Professional 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans