Hi,
I am using SQL report services to generate report. I would like to generate the report in the below format. However I don't know how to use RowNumber in nesting group.
Format I wanted
Group1
1. Group2 item 1
2. Group2 item 2
3. Group2 item 3
If I use RowNumber("Grou p1"), the report becomes
Group1
3. Group2 item 1
7. Group2 item 2
8. Group2 item 3
Can someone help me on my case? Thanks
I am using SQL report services to generate report. I would like to generate the report in the below format. However I don't know how to use RowNumber in nesting group.
Format I wanted
Group1
1. Group2 item 1
2. Group2 item 2
3. Group2 item 3
If I use RowNumber("Grou p1"), the report becomes
Group1
3. Group2 item 1
7. Group2 item 2
8. Group2 item 3
Can someone help me on my case? Thanks