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
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
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
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...
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,524 Super User 2024 Season 2
Martin Dráb 228,493 Most Valuable Professional
nmaenpaa 101,148