Information générale
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Maintain Group Header Information - again
>>>Unfortunately the information in the group header on this 2nd page is
>>>incorrect showing the following records information.
>>>
>>>
>>Ok. The Parent table holds Dealer Information such as
>> Dealer Name, Dealer Number and balances.
>>
>>
>> In the group header. I place the Dealer name info.
>>
>> In the Detail band I list all the transactions.
>>
>> In the group footer. I list all the balances.
>>
>> eg.
>>
>> ******
>> * Page 1
>> * Footer
>> Dealer No. - 214 Dealer Name - Deals On Wheels etc.
>>
>> * Detail
>> 35 lines of details
>> * footer information is forced to the next page
>>
>>
>> *Page 2
>> *Group Header
>> *Dealer No. - 215 Dealer Name - Corrubian Auto Sales etc.
>>
>> *Detail band
>> *No Details
>>
>> *Group footer
>> *Actually displays balances of the prior dealer 214.
>>
>> Alright I've tried the outer-join. Unfortunately I am getting
>> the same results. The group header information is still
>> showing the following records information.
>> Dan
>
>Look at outer-joined cursor. Does it really contains #215 record?
Starting a new thread. I hate it when the thread gets too far
to the right of the screen.
Yes here's the code.
SELECT &lcFIELDS FROM GLS!LM10, GLS!LM10TRS WHERE ;
lm10.CDLRNMBR = lm10trs.CDLRNMBR ;
INTO CURSOR LM10VUE ;
UNION ;
SELECT &lcFIELDS FROM GLS!LM10 ;
WHERE lm10.CDLRNMBR NOT IN ;
( SELECT lm10trs.CDLRNMBR FROM lm10trs )
Dan
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