Notifications
Announcements
No record found.
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
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
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...
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
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.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 592 Most Valuable Professional
André Arnaud de Cal... 478 Super User 2025 Season 2
BillurSamdancioglu 305 Most Valuable Professional