I have a BW query defined on a cube. There are 2 more queries defined on 2 DSOs. The CUbe contains summary level data and DSOs contain detailed level data.

When the query is run on cube, I can drill through from this query to either of queries based on DSOs. ( this is achieved through Report to report interface in SAP BW).

How do I acheive the same in Crystal reports?

I have defined a universe on Cube, and 2 universes on both of DSOs.

I have to create a crystal document on BW query of cube, where i can drill to any of two crystal reports which are created on DSOs.

In RRI functionality when I right-click on the characteristic cell, i have the option of selecting any other query from submenu through Goto.

The need here in Crystal is to have same functionality with an option to select any on two detailed level crystal reports.

For ex.

I have a query on cube with object Sales Document.

Now i have two more queries having detailed data in both queries, 1. for sales documents and orders for each document and 2. for sales documents and revenue.

From the main query i have to drill through to any of the two detailed level queries.

I am using Crystal 2008 version.