>>>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

So far, i don't see problems. You collect one-many tables to one cursor with ProviderID,AddressID,TaxID ... Now you can just order this cursor by this 3 fields providing that empty AddressID will go last.