Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

CR with SAP..How to do union.. Linking two difference data sources?

Hi All,

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

Best Regards,


Not what you were looking for? View more on this topic or Ask a question