SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
Spirits
Spirits
SSC Rookie
SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)

Group: General Forum Members
Points: 45 Visits: 52
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
thetodaisies
thetodaisies
Valued Member
Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)

Group: General Forum Members
Points: 63 Visits: 166
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
Mohan Kumar-589930
SSC Veteran
SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)

Group: General Forum Members
Points: 289 Visits: 28
You need to Group by the categorynames and need to order by the categoryid
Mohan Kumar-589930
Mohan Kumar-589930
SSC Veteran
SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)SSC Veteran (289 reputation)

Group: General Forum Members
Points: 289 Visits: 28
You need to Group by the categorynames and need to order by the categoryid
Chirag Prajapati
Chirag Prajapati
SSChasing Mays
SSChasing Mays (632 reputation)SSChasing Mays (632 reputation)SSChasing Mays (632 reputation)SSChasing Mays (632 reputation)SSChasing Mays (632 reputation)SSChasing Mays (632 reputation)SSChasing Mays (632 reputation)SSChasing Mays (632 reputation)

Group: General Forum Members
Points: 632 Visits: 77
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
Spirits
SSC Rookie
SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)

Group: General Forum Members
Points: 45 Visits: 52
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search