Drill down Report

[balanandam]

Hi,

Can any one help me to meet my requirement ?

I have data like this

Transaction:

Date, transactionid

11/05/2017, 1234

11/05/2017, 1235

11/05/2017, 1236

12/05/2017, 1237

12/05/2017, 1238

12/05/2017, 1239

12/05/2017, 1240

Activity:

ActivityID, transactionID

1,1234

2,1234

3,1235

4,1236

5,1237

6,1237

7,1239

8,1239

9,1240

Initially, Report has transaction data in tabular format and when I click on transactionid, that should open the detail report of particular transactionid, i.e, all Activity report(switches to detail report), in the kind of way Master and Child style, finally, Activity report should have Close button, that drives me back to the Master Report. Hope, you got what I'm trying to say...

Appreciates, if provides the sample qvw.

Thanks in advacne,

Balanandam

[neha_shirsath]

Then mark it to helpful/correct.

[balanandam]

Hi Neha,

I have one problem with your solution, I have another sheet with same TransactionId even I clicked over there it will redirects to the Activity sheet. But it is not expectation, Activity sheet should be opened when I click on transaction Id on Transaction sheet only. Attaching the scenario.

Hope you understand this!

Br, Balanandam