Hi all,
I am wanting to have a look at the local procesure of an out of the box report but can't seem to locate it. I'm new to SQL and the 'backend' of things. The window type is "System Window".
Thanks in advance for you help,
Natasha
Another option is to launch the Report Setup System (GSRsetup). When you want open a report you are given a window that looks just like the normal Report pop up window which makes it really easy to find the report you are looking for because it has the same name and it is in the same folder category.
When you open a report in Setup the first item at the top of the page is the Report ID. This is the name of the InfoMaker object inside the .pbl. If you then jump over to InfoMaker you can open the presentation object. You can then right click in the Column Specification area and select Stored Procedure to find out which SQL procedure is being run to process the data for the report.
Just an option. Good luck.
Jared
As a more general option, there is a tool called PBDoc, which you can run against your PBL files, which will produce a set of linked and indexed html pages that document the objects inside the pbls, and what they refer to - pointers to subreports, stored procs or other SQL sources, columns referred to, data definitions etc.
You can download it and run it unregistered (ie like shareware), although it's a commercial product. It's really intended for Powerbuilder developer documentation, and it was a bit of a struggle to understand how to get it to produce the output, but the result is very useful. Ill try and post a sample output page here, but if that doesn't work, there are samples on the website
Ken
Thanks so much for all you responses!! This is really helpful as a beginner.