CR with SAP..How to do union.. Linking two difference data sources?
I am new to crystal reports and using it now with SAP ECC and SAP BW. I have few questions with respect to crystal report with SAP.
1. Is union of two queries from SAP possible in CR?
2. Can we add subqueries while selecting data.
select * from Table_a
where book_date = (select max(date) from table_b
where date < sysdate)
This is a oracle SQL query. But can we write similar subqueries while selecting data with SAP ECC or BW.
3. Can we link two queries. Like how we do it in Web-Intelligence or Desktop Intelligence.
Query 1 results customer, revenue
Query 2 results customer, profit
Can we link the 2 data provider in Crystal report with the field customer
So the output can be a single list
customer, revenue, profit
abc 1000 50
xyz 1000 40
Lot of questions
Thanks in Advance