>>I am not thinking too clearly but will try and explain.
>>
>>My clients need a report that is quite complicated. It requires a procedure to create the data source. All of my applications reports are built into the exe and I am not allowed to make changes to the exe at this time. But I still want to give them this report. My clients do have Query Maker, some third party software with some similarities to Crystal Reports, which they can use to build their own queries and then build their own custom reports. Query Maker uses the VFP Report Designer. I created a procedure as part of the exe where they can "import" and "export" their custom reports so that they can share the reports between sites. So if I build a report in Query Maker I can then export it and have them import it.
>>
>>Thinking that I can build a report that calls a procedure to create the data source and then all the fields on the report use that data source. So I need to get it all done with a frx, frt, and a fxp (I will sneak the fxp into the folder). I assume this is possible, is it? Any tips on how to get it done or any other ideas?
>>
>>Hope this makes some sense
>>
>>Brenda
>
>Brenda,
>
>This idea was discussed couple of months ago if my memory serves me right by Roi Ledford. The solution would be select into temp report
>
>pseudo-code
>

>select * from YourReport to tempReport
>replace expr with strtranc(expr,"myReportField","myNewField"), ;
>supexpr with strtranc(supexpr,"myReportField","myNewField")

>
>where strtranc - case insensitive strtran (here there were threads as well).
>
>That's just an idea, which you may consider.

Oops, my memory played trick on me. It was Rip Rynes...
Forum: Visual FoxPro Category: Reports & Report designer Title: Macro Substitution(&) Thread #459993 Message #459993