How to get a MTD and YTD amount on one report?

[bv0719]

I have a report that uses a subreport with a formula to capture a month to date summary of a general ledger amount field. The value from the subreport is a shared variable and displays in the details B section of the main report. The subreport is in the detail A section. I need to capture the year to date figures as well. Could I somehow use the same subreport used to gather the MTD amount for the YTD amount since this is where the data resides? Or, would I need to create a new subreport to cature the YTD info. Since I'm gathering data from the same field how does this affect the order in what gets processed first, etc?

Also, when the report returns the vales from the subreport the amount that is returned duplicates for each general ledger number until a new amount is generated. My guess is the ledger numbers that have no history return a null value so the amount from the previous field duplicates over the null? Not really sure, but how can I prevent this other than using suppress if ducplicated.

thanks,
Bill

 

[bv0719]

I got the report to work the way I need it to but still have to prevent the duplicates.

thanks,
BV