Drill through on Row number list column body in Report Studio

[jd]

Hi,

any idea how to define a drill throgugh on a Row Number in Report studio (not on the Row number header I want to define the drill through on the Row number list column body)

I have a parent report with Row number and columns. when I run the report I can see report output with Row numbers.

on the output if I click on a Row number for ex 1, I want to see only that row data.

I have created the chiled report and tried to define the drill through to parent report but when I create the drill through I can create it on Row Number column title only but I want this on the Row number list column body.

Any idea??

[cognostechie]

I don't have cognos in front of me right now but can you try unlocking (click on the Lock button to unlock it) and then try it?

[jd]

I tried with unlocking it still it is not working.

[MFGF]

You may need to replace the Row Number object in your list with a Query Calculation using a running-count() summary.

MF.

[jd]

Hi MFGF,

Thanks for your help. running-count function worked fine to get the row number and define the drill through on row number.

Here when I run the report if I click on row number 1 report has to produce that row info and if I click on row number 2 report has to produce row number 2 info only,
but here when I click on any row number report is showing only one row info  that is which I have selected the first row number.

any idea why it is doing like this??

[MFGF]

What value(s) are you passing on the drillthrough?

[jd]

I have Region and Location in my report with some of other dimensions and measures.

I have used Region to get the running-count
running-count ([Region] for report)

parameters are:
(?Region? = '<All>' or [Region] in ?Region?)
(?Location? = '<All>' or [Location] in ?Location?)

above 2 values I am passing on the drill through. Drill through parameters method I have selected as "pass data item value"

[cognostechie]

Why not just set the filters as:

[Region] in ?Region?
[Location] in ?Location?

and make the filter Optional.