I recently received a request to write a certified payroll report, and the query turned out to be a tough one. The client needed me to bring in the project from the gpUPRCPR table, which I'd never heard of; and several other custom fields. Like most GP reports, this report does not run from a query but they build the dataset one line at a time behind the form. I had to trace through several hundred SQL calls to get this figured out. More, the stored procedures that they did call were not on the machine. I'm not sure how that works, because they didn't return errors. Maybe they create them on the fly and delete them?
At any rate, the query for the report is below. I don't what to have to do this twice <smiles>
If you can shed any light on how this process works, would you add a comment below the article?