COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: khabaleshri on 28 Nov 2018 03:53:25 AM

Title: Rownumber to note section
Post by: khabaleshri on 28 Nov 2018 03:53:25 AM
Hi All,

Client wants to see 'Note section' below crosstab.
here is my report studio page

Crosstab
1. text item 'A'
2. text item 'B'
3. text item 'C'
4. from this row I need to show notes for report

for that, I took list container and drag rownumber from toolbox and 'note' from note query. note will starts from 1 not 4. is there any way to manually specify starting values for rownumber.

first 3 hardcoded text are the obstacle and those are text item from toolbar.
first note should be start from 4 because of first 3 text items.can anyone help me out to achieve this scenario?
Title: Re: Rownumber to note section
Post by: khabaleshri on 28 Nov 2018 04:55:16 AM
I am able to find solution

Rownum data item =3+running-count([note])

please ignore this request guys btw how to delete this thread.
Title: Re: Rownumber to note section
Post by: CognosPaul on 29 Nov 2018 09:17:38 AM
I prefer not to delete threads, especially when there's a reply with the solution. This way other users that have the same problem can find this. Kudos for finding the solution, especially for giving the answer.