>>>>>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.
>
>Two problems with this approach. 1) I think that after I get the final address break the detail lines will print all of the TaxId's under one blank address, correct? I need to print each TaxId as if it has a seperate address.

You can just print some word like "missed" or "unknown" for each empty address.

2) for brevity sake (well, I did try anyway) I didn't detail the other parts of the report. It also has to print provider specialty codes and state licenses in a seperate section/format. Using your approach would associate specialties and licenes with a particular address, not with at the provider level. In other words the specialties and licenses would print each time an address prints.

Again, if you break it by all three fields, it should work Ok.