Dear Ronit,
I'll tell you the concept of RRI ok?
you have a report1(summary) and a detailed report2. Example In Report1 , you have custid, total purchase amount.(summary report)
In report2, you have detailed transactions(at line item level) for a given cust id. i.e; input to this detailed report will be the custid and the report will display all the transactionf for that cust id.
Now, the scenario is , from the summary report, all custids with total purchase amount will be displayed? When you right click one of the custid and jump to the detailed report, you should be able to see the detailed transactions for that custid.
Now lets see how it works.
Here sender is report1, receiver is report2. One of the conditions to link 2 reports using RSBBS is that both the sumary and the detailed level reports should have a comon characteristics to link. Here we custid in both reports.
So, In RSBBS, you mention sender as report1, receiver as report2 and in the other tab, you just mention what kind of report( i remember you may need to mention as BW report). I dont remember(plz. check).
Once this is done, run the summary report Report1, right click any of the custids you will see in the context menu-> drill down-> jump to report2.select that. now u will see detailed transactions for that selected custid.
Technically, how this works is: When you right click a custid and select to jump to the detailed report, that selected custid is passed as a parameter to teh SQL to the detailed report, hence the detailed report knows for which custid , it is supposed to display the data. This is a typical example of a dynamic query, where in the values of the parameter to the query is passed during runtime.
Got it??
Get back to me if you have any questions.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.