Displaying Row Numbers

7 posts, 0 answers
  1. Bekir
    Bekir avatar
    5 posts
    Member since:
    Jun 2010

    Posted 15 Sep 2010 Link to this post

    i am trying to display order numbers for every data row in detail section. There is no "order" column in database.

    Output will be:

    order id name
    1 57 jack
    2 23 denis
    3 67 harry


    ps: i am sorry for my english (:
  2. Patrick
    Patrick avatar
    52 posts
    Member since:
    Jun 2010

    Posted 15 Sep 2010 Link to this post

    If you just need to display the row number of the current record, you need to add a textbox to the detail section and set its .Value property to:
    = RowNumber()
  3. DevCraft banner
  4. Bekir
    Bekir avatar
    5 posts
    Member since:
    Jun 2010

    Posted 21 Sep 2010 Link to this post

    i was trying to do that in the table, but it wants "scope" as parameter.. anyway i solved my problem, thanks for reply..
  5. Grigore Dolghin
    Grigore Dolghin avatar
    19 posts
    Member since:
    Mar 2010

    Posted 10 Feb 2011 Link to this post

    It would be too much to put your solution here?
  6. Cheri
    Cheri avatar
    9 posts
    Member since:
    Feb 2006

    Posted 06 Mar 2012 Link to this post

    Can you tell me how to get a row count for the total number of detail records?  I wish to place this data in a group footer related to those detail records.

    Thank you,
    Cheri
  7. Cheri
    Cheri avatar
    9 posts
    Member since:
    Feb 2006

    Posted 06 Mar 2012 Link to this post

    I got it. 

    =Count(Fields.<yourfieldname>)

    When placed in the group footer this will render the total number of detail records contained in that group.
  8. Mohammed
    Mohammed avatar
    87 posts
    Member since:
    Aug 2011

    Posted 16 Mar 2013 Link to this post

    that can work if the field in the report data source but my problem is i want to count number of rows in the table that located in the group header, and that table has its own data source, so how can i get the count of each table rows in each header section.
Back to Top
DevCraft banner