How to use the data in one report to another?

building reports webintelligence
1

HI,

I have to create two reports. The first report is a detailed report. And the second one is a summarized report. How to create these two reports, without running the query twice.

Thanks and regards
Gowtham Sen.

GowthamSen :india: (BOB member since 2006-08-31)

2

Put the 2 reports in the same document. That’s why you have tabs.

There is no way for multiple documents to share the same data cube.

Steve Krandel :us: (BOB member since 2002-06-25)

3

Thank you Steve.

Ok. Then, is there any way to pass the data from one report to another?

Thanks and regards
Gowtham Sen.

GowthamSen :india: (BOB member since 2006-08-31)

4

You can call the OpenDocument function (see here for some details) to pass values from the source report (as prompt inputs) to a target report, you still will not be able to share data (the way you envision). Steve’s suggestion might be the best one.

Andreas :de: (BOB member since 2002-06-20)

5

Hi Gowtham Sen,

What I believe Drill through option is not available in BO. The best way to deal with this problem is to create tabs in the same report as suggected by Steave.

Thanks

Vikky :india: (BOB member since 2006-09-06)

6

Thank you Andreas and vikky.

I follow as Steave said. Thank you for clear definition to my problem.

Thanks and regards
Gowtham Sen.

GowthamSen :india: (BOB member since 2006-08-31)