>>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.
>>
>>I have evaled R&R, and Crystal, and am going round and
>>round with tech support at MicroMega Systems (FoxFire!)
>>without much success, so I think I'm gonna end up writing
>>the code by hand (gack).
>>
>>My question is, does anyone know of a report writer that
>>generates modifiable VFP source that I coudl use for this
>>application?
>>
>>advTHANKSance
>>
>> ...kt
>
>I'm just curious what task cannot be handled by VFP Report Writer. Can you >give some specifics?

Sure!! I can get so detailed that I can make your eyes glaze over :)

Basically I have a list of doctors one whom I have data for which I'm trying to detail in report form. The main difficulty comes in with TaxId's. I have a table of addresses and a table of TaxId's. Each doctor has at least one associated address, and at least one associated TaxId. I need to print a report that shows the provider->any associated addresses->any taxids associated with those addresses. Then in another section within that report I need to show any TaxId's without an associated address (i.e. I know THAT he uses this TaxId, I just don't know WHERE he uses it).

The general flow of the report is like this:
+------------ provider id (break)
|
| +------Address id (break)
| | +---TaxId
| | | (detail)
| | +---
| +------
|
| +-----TaxId WHERE EMPTY( dm_AddrId)
| | (detail)
| +-----
|
| +-----Spec_code
| | (detail)
| +-----
|
| +-----State_lic
| | (detail)
| +-----
|
+------------

I'm just gettin' warmed up. Wanna know more... :)

...kt