Information générale
Catégorie:
Produits tierce partie
>>>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.
Well they haven't really been missed though. It would print
address
taxid
taxid
taxid
address
taxid
blank address (or unknown)
taxid
taxid
taxid
taxid
What I'm trying to achieve is
address
taxid
taxid
taxid
address
taxid
blank address (or unknown)
taxid
blank address (or unknown)
taxid
blank address (or unknown)
taxid
blank address (or unknown)
taxid
>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.
Hmmm...lemme check that, off hand that sounds like it might work for me.
THANKS!
...kt
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement