Post reply

Rownumber function for the detail of every group

  • October 30, 2008 at 7:33 am

    #195386

    I am working with VS2005, Reporting Services

    I want to know how to use the Rownumber function for the detail of every group I want to restart the counter how can I do that.

    For example:

    1  group 1

    11  Detail1

    12  Detail2

    2  group 2

    21  detail3

    22  detail4

    And so on

    Please advise what to do.

    Thank you!!:)

  • October 30, 2008 at 7:37 am

    #891764

    Did you copy your or someone's post word to word?

    Anyway, a lot of solutions in there already

    Focus on the "scope", or just put ROWNUMBER in the group detail row

    http://www.kodyaz.com/articles/article.aspx?articleid=52

    http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_23440459.html

    SQL2005 Reporting Services and RowNumber

    Asked by RamyBouchra in SQL Server 2005, MS SQL Server, Visual Studio

    Dear Team

    I am working with VS2005, Reporting Services

    I want to know how to use the Rownumber function for the detail of every group I want to restart the counter how can I do that.

    For example:

    1 group 1

    11 Detail1

    12 Detail2

    2 group 2

    21 detail3

    22 detail4

    And so on

    Please advise what to do.

    Thank you

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005

  • October 30, 2008 at 8:52 am

    #891866

    this solution is working fine in my reports too... i am able to keep track of row numbers even in the third level group also.

    But the problem is i want to implement a page break aftr 50 rows in the third level (lowermost level)

    i have written the following expression in the group at the third level

    =Ceiling(RowNumber("SecondGroupsName")/50)

    But its not working.....

  • November 2, 2008 at 10:15 pm

    #892879

    Hello,

    What happened when you give that Expression to display 50 rows per page?

    Try by Reducing the row Height (Group, Detail row sizes)

Viewing 4 posts - 1 through 3 (of 3 total)

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