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??
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?
I tried with unlocking it still it is not working.
You may need to replace the Row Number object in your list with a Query Calculation using a running-count() summary.
MF.
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??
What value(s) are you passing on the drillthrough?
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"
Why not just set the filters as:
[Region] in ?Region?
[Location] in ?Location?
and make the filter Optional.