How to drill down in Report Studio?

[ChrisF79]

I have a crosstab report with the sales rep name in the rows.  I want to make it so that if someone clicks on the salesrep's name, it shows the customers in the same crosstab.  How do I go about doing that?

Here's a screenshot of what I'm doing:



Notice I have SalesRepCombo(ShipTo) in the crosstab now.  I want someone to be able to click on a rep anme and have the column be replaced by ShiptoCustCombo - Long Name instead.

I've done it before by making a second report and passing a parameter.  Any way of doing it right in this same report?

Thanks

[charon]

Hi Chris,

one way might be to create a data item with a "if (?pt_choice? = 1) then ([SalesRepCombo(ShiptTo)]) else ([ShipCustCombo]) and use this for rows.
You then have to create a prompt/ button to choose which one you want to see. Of course it should be possible to use javascript for passing this parameter as well. For great javascripts in cognos check out : http://cognospaul.com/category/javascript/ , maybe you will find there the solution.

regards
charon

[Raghuvir]

Hi Chris,

As per the screenshot shared, you are using a dimensionally modelled package.

What you need to do is enable the drill behaviour of the report. you can do this by going to

Data>>Drill Behaviour>>Allow Drill up and Drill down

You need to check Allow Drill up and Drill down to enable the functionality.

Regards,

Do applaud if the information was helpful  :)