Brenda,

Create your program that creates the cursor or table. In the report, add a title band if the report doesn't already have one. Then double-click on the title band and you will get a dialog box that allows you to run a program on entering the title band, which only happens once for the report. If you have to do any cleanup, add a summary band and choose the "on exit" to place the call to your program to clean up.

I use this all the time to add extra functions to eports where I don't have the source ode to the programs.

Bill

>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