InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 01:31:55 GMT20http://www.sqlservercentral.com/Forums/Topic766727-1063-1.aspxwell 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() functionAs 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 ALLthnx to allregardsHammadWed, 12 Aug 2009 09:02:46 GMTSpiritshttp://www.sqlservercentral.com/Forums/Topic766727-1063-1.aspxyou can use it in the below fashion.RowNumber("Group1") =1RowNumber("Group1").RowNumber("Group2")= 1.1RowNumber("Group1").RowNumber("Group2").RowNumber("Group3")=1.1.1This will Iterate through all rows and provide you the hierarchical numbers.Tue, 11 Aug 2009 01:04:15 GMTChirag Prajapatihttp://www.sqlservercentral.com/Forums/Topic766727-1063-1.aspxYou need to Group by the categorynames and need to order by the categoryidFri, 07 Aug 2009 03:19:16 GMTMohan Kumar-589930http://www.sqlservercentral.com/Forums/Topic766727-1063-1.aspxYou need to Group by the categorynames and need to order by the categoryidFri, 07 Aug 2009 03:19:11 GMTMohan Kumar-589930http://www.sqlservercentral.com/Forums/Topic766727-1063-1.aspxHi,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?ThanksFri, 07 Aug 2009 03:03:08 GMTthetodaisieshttp://www.sqlservercentral.com/Forums/Topic766727-1063-1.aspxwell i ve hierarchical data of some categories. and i wanted to render it in the following format in SSRS 2005 reporting1 Cat-A 1.1 cat-A1 1.2 cat-A2 1.2.1 cat-A121 1.2.2 cat-A122 1.3 cat-A32 Cat-B..... And so oni 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 plzFri, 07 Aug 2009 01:32:08 GMTSpirits