My reports are usually executed like this: user selects one or many records in a grid, then selects Print. I roll up the RecordIDs and pass that into the report.
What's the best way to run reports given a list of Record IDs that have a detail table associated, ensuring each new Record and it's detail info starts on a new page?
I'm able to do this now (e.g. Activity/WO and its associated JobItems) but the only way I can make it work is to put a hard page break after my JobItems grid footer. If I don't put the page break in there, the JobItems grid displays twice...one for one WO record ID passed to the report, and then the "next" record ID.
Basically, I probably don't understand all the reporting concepts and features available to me and I've likely had "accidental" success to this point.
Sorry if that's confusing...hope it makes sense.
Thanks for any pointers on this.