Layout Question Please help! 1

[vlad2]

Ivoice has 1 to x payments.I grouped payments by InvoiceID
I want to display the first payment in the same line with invoice info.now it looks like...

InvNumber InvTotal PaymentType AmoudPaid
123 $200.00
Cash $100.00
Check $100.00

I would like to display in this way:--

InvNumber InvTotal PaymentType AmoudPaid
123 $200.00 Cash $100.00
Check $100.00
How i can do this?
Thanks for any help..

 

[dgillz]

I would use a subreport.

Put the invoices in your main report as you have it laid out. Put the payments in a subreport in details b, and format details b to suppress blank section. If there are 1 or 1,000 payments, they will all show up with the invoice only showing once. Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com

 

[vlad2]

I have to relogin to another server from within VB at run time.Will it cause the problem using subreports??

thanks.

 

[balves]

You can simply put the "group fields" on the detail line, choose Format Field, and click "Suppress When Duplicated."

You don't need a sub-report.

 

[vlad2]

Thanks a lot "Suppress When Duplicated" works!!!
One more Question:

Do you know how to Keep whole group together, I mean keep together All: GroupHeader and Details and groupFooter

Thanks in advance...

 

[balves]

Right-click on the Group Header and choose "Change Group" for those options.

You would have thought that those options would be under "Format Section" but that would have been too logical for Crystal.

 

[vlad2]

Thanks, It works!