how can i perform ordered numbering of hierarchical data in SSRS 2005 Reporting ????

Question

Post reply

how can i perform ordered numbering of hierarchical data in SSRS 2005 Reporting ????

Spirits

SSChasing Mays

Points: 619
More actions
August 7, 2009 at 1:32 am

#209062

well i ve hierarchical data of some categories. and i wanted to render it in the following format in SSRS 2005 reporting
1 Cat-A
1.1 cat-A1
1.2 cat-A2
1.2.1 cat-A121
1.2.2 cat-A122
1.3 cat-A3
2 Cat-B
.
.
.
.
.
And so on
i m able to pad the items as per desire but unable to give them numbering like 1,1.1,1.1.1,.....
one way to do this is to make this numbering in my dataset query. but for this i got to use cursor and so on which is bit resource intensive. is SSRS 2005 have some power to get the job done of this numbering.
anticipatory thnx and little urgent plz

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

thetodaisies Ten Centuries Points: 1387 More actions · Answer 1

Hi,

if Cat-A,Cat-A1,Cat-A121 are 3 levels of grouping then rownumber can be used with the scope as the groupname .

not sure how to do it without grouping if it is supposed to do so. if the category name has the order no with it(A1,A2 etc.). then can't that itself be extracted and shown?

Thanks

Mohan Kumar-589930 Old Hand Points: 399 More actions · Answer 2

You need to Group by the categorynames and need to order by the categoryid

Mohan Kumar-589930 Old Hand Points: 399 More actions · Answer 3

You need to Group by the categorynames and need to order by the categoryid

Chirag Prajapati SSC Eights! Points: 904 More actions · Answer 4

you can use it in the below fashion.

RowNumber("Group1") =1

RowNumber("Group1").RowNumber("Group2")= 1.1

RowNumber("Group1").RowNumber("Group2").RowNumber("Group3")=1.1.1

This will Iterate through all rows and provide you the hierarchical numbers.

Spirits SSChasing Mays Points: 619 More actions · Answer 5

well guys thnx for ur concern but either i cud nt explain the problem or u guys thinking in wrong direction. first of all its a recursive tree dataset with unlimited nodes or undefined nodes at design time ofcourse. so i got to create a single group with catid as expression and ParentCat as its parent group expression so that this dataset can be presented in tree view mode with the help of padding on basis of Level() function

As far as numbering is concerned i ve deviced a way finally. though i ve not tested it yet i ll check it out tomorrow in my office. but psudo code is that i ve to use a function in report coding area which ll do all the working by reviewing the previous() built in function. after completing the task successfully by the grace of ALLAH i ll post the code.

but simply the idea is to device a function in report code area which ll take previous numbering value as parameter do the work and return the value for the current row. THATS ALL

thnx to all

regards

Hammad