In Crystal Reports I am looking to have a header footer then header footer with linked info but different Sums -

In Crystal Reports I am looking to have a header footer then header footer with linked info but different Sums -

so know not possible

header 1 detail footer 1 header 2 detail footer 2

but trying create form shows

invoices invoice#, date, status, total, balance due info debits total: credits date, reference, total, balance info credits total: balance due:

balance due beingness debits - credits. able invoices can not figure out how credits show below debits total.

edit------------------------------------------------------------------------

help below requirement aswell:

sum(case when s.[ar sale bill to] '%wilco%' isnull(d.[ar saled qty requested],d.[ar saled qty]) * d.[ar saled unit price] else 0 end) 'total'

i need have value if null grab qty [ar saled qty] ideas?

now having problem getting on same page...detail 1 prints on page 1 , detail 2 prints on page 2. amount of records vary on first record there 3 lines in first subreport , 1 in sec subreport.

your requirement possible....

use 2 sub reports in single main study can desired structure

header 1 //sub study 1 detail //sub study 1 footer 1 //sub study 1 header 2 //sub study 2 detail //sub study 2 footer 2 //sub study 2

let me know incase issue

crystal-reports