General information
Category:
Reports & Report designer
Title:
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only