Arithmetic operations on fields coming from two data sets.

[sadakar]

Hi Forum,

In one of my requirements, I need to calculate sales where sales = sold-credited.

I've individual queries for sold and credited (I can not combine them to get in one sql query) & making them available in two data sets. 

Now, I would like to perform minus as per the formula quoted above. 

Is there any way to achive this at report level ( or using java code) ? 

Thank you in Advance :-)

 

- Sadakar Pochampalli

 

[djohnson53]

Just thinking off the top of my head....

Is all of the data in just one DB? If so, you should be able to do a union of the two queries.

We do have something called a Virtual Datasource that could combine two DBs into one Data Source (Virtual Data Sources)

Or possibly one query works in the main report, the other in a sub-report?