May be I didn't explain the task well. We allow our customers to create their layouts using MODIFY REPORT command in run-time from our application. All needed cursors with relationship are setup and there are also some limited number of functions that they can call. Normally our client support people help customers to develop their layouts.
So, all the work needs to be done using that MODIFY REPORT command available in run-time (no changes to report using outside programs). We're using ReportBehavior 8.0.
So, I was looking for some relatively easy trick here but there seems to be none.
>Naomi,
>
>>You can open the frx with USE, and alter the fields. I do not know the fieldnames without searching, but you can REPLACE the code as well as the binary fields. Possibly from a template hidden into your program.
>
>FWIW, this is exactly how we prepared ad hoc customer reports for years. Customers could select any combination of fields and the proc set up the report from scratch including set relation for lookups and addition of branding detail under our control. Even if the customer has or needs to use MODI REPO there's no reason why you can't go in and massage the report. Common uses include removing some fields in a demo version, ensuring that your company brand info stays intact, adding disclaimers if confidential fields are included, adding report variables, ensuring set relation for certain fields... Certainly worth considering, especially if you allow users to potentially screw things up completely via MODI REPO. ;-)
>
>I know this doesn't answer your specific question- but you can cause a report to call a routine before it starts processing. That would be a good place to pre-populate calculated fields that don't exist early enough.
If it's not broken, fix it until it is.
My Blog