Hi ,
In one of the reports I need to show both current year revenue and last year revenue month wise in one cross tab.
For this two dataproviders are built. one for current year revenue and other for last year revenue .
Can any one help me how to display both the revenue in the same cross tab with current year month values in the horizantal header.
Please find the cross tab structure to be in the report.
Jan `11 Feb `11 Mar `11 Apr `11
Current Year $100 $200 $300 $400
Last Year $75 $56 $23 $89
Data from Current Year Query
Month Revenue
Jan `10 $75
Feb `10 $56
Mar `10 $23
Apr `10 $89
Data from Last Year Query
Month Revenue
Jan `11 $100
Feb `11 $200
Mar `11 $300
Apr `11 $400