Learn how to modify QRP Reports

I have also started the same process of modifying QRP. I am in process of trying to put together a description of the Tables and Fields available. My plan is to use awk to extract all table names and fields from existing QRP reports on our system. I think there must be a better way like writing a report that uses the SQL DESC command.

If anyone has a better way to extract the Table Views I would appreciate hearing about it before I embark on my AWKward journey. Brian Kernighan would be proud (Kernighan = "K" in awk for the new breed).

Run this query to get a list of tables and view in your db sp_tables

Run this query to get a list of fields (metadata) in a table sp_columns item -- this will show you the item table

I think the best way to learn how to edit rms reports is to copy the canned reports and save them as custom reports, then play with the custom reports. Save the reports as "Custom - My Test Report.qrp" or something like that. You will then run them from the custom reports area in SO Mgr. If you know basic SQL pretty soon you'll figure out how to add columns, set filters, etc. Post your specific questions or setbacks here, you'll get some good help from plenty of folks.

"KravDave" wrote: