Add two formulas of different queries and get result in reports
I have two formulas in different queries in a Report Builder. For e.g.
In query 'Q_1' there is a summary formula called CS_GSECINT which takes the sum of a column (belonging to Q_1 query) and is reset whenever a date changes. That means if the user runs the report from say 02/11/2009 to 05/11/2009, CS_GSECINT would contain a sub total of three days i.e. 02,03,04,05/11/2009.
In query 'Q_2' there is another summary formula called CS_GSRINT which again takes the sum of a column (belonging to Q_2 query) and is reset whenever a date changes.
The requirement is to add the values of both CS_GSECINT and CS_GSRINT for each day and display the output. That means for 02/11/2009 if CS_GSECINT contains Rs.2,000 and CS_GSECINT contains Rs.1,000, the output should be Rs. 3,000 and so on for all the period input by the user.