SSRS auto incrementing row number

• rmdb

  Old Hand

  Points: 386

  More actions

  March 2, 2011 at 12:36 pm

  #235406

  Is there a way to add an incrementing row number for the rows that are returned in an SSRS report?

  For example, if I have a table that has 50 records, can I add a column that will be the running count of the row numbers for the rows in the table? This row count should not be dependent on the udnerlying data, just an independent running row count for visual purposes.

• ChazMan

  SSCrazy

  Points: 2259

  More actions

  March 2, 2011 at 12:42 pm

  #1293691

  same answer as your other post. Look at Rank() or row_number().

  --------------------------------------------------------------------------
  When you realize you've dug yourself into a hole....Step 1...stop digging.