>>Hi all,
>>
>>I have a need to generate a report that the VFP report
>>writer cant seem to handle (surprise, surprise). It
>>involves creating a series of sub-reports at least one
>>of which cannot be easily obtained by creating a single
>>subset and performing control breaks.
>
>Have you looked at GenRepoX... It allows you to extend the VFP report writer >extensivly... but, one of the most usefull features is allowing for multiple >detail lines in the report. This is about as close as you can get to sub >reports.

No I haven't looked at that. Two questions, 1) where would I find it? 2) Does it generate VFP code or does it simply add 'stuff' to the .FRX?

>Another thing you can do, thatI have done succesfully, is create a function, >
>the returns a string with all the data that needs to be in your 'sub' report.. >then put the field on the report as streachable, and set the band as >stretchable.

Yeah, I came up with that one too, but it looks kinda "cheesy" in this particular application. No, what I really need here is the ability to produce separate reports each with it's onw set of control breaks, each with it's own set of detail listes and data sources. Ideally, I would be able to call the sub report with the primary key of the control table and have the subreport just print the assocaited records.

>Also, I think Crystal 5.0 Pro allows you to embed reports within reports.. but >I haven't used it personally.

It does indeed have that feature. The main problem that I have with Crystal is that it doesn't have native support for VFP files. You must go through ODBC drivers to access the data. I'm having all kinds of problems getting ODBC to work properly and I think I'd fare better hacking the code out myself (spoken like a true programmer!)

>Good luck,

I don't need luck I've got YOU GUYS!!! :)

Thanks for the response...

...kt