0

I have table with 3 columns . 

S.NO  NAME  AGE

I need the serial number to be running as 1.1 1.2 1.3 ... etc (Till the rows end)

Is this possible .?

user1699025
  • 61
  • 2
  • 7
  • 13
  • Try `=1 + (RowNumber("DataSetName")/10)` – kelsier Dec 05 '13 at 05:45
  • Correct me if I am wrong. This expression has to be added as a calculated field right? – user1699025 Dec 05 '13 at 05:54
  • Not sure what you mean by calculated field. You should just put that in the `Expression` box that appears after you click the `fx` button in the `Text Box Properties` window. – kelsier Dec 05 '13 at 06:01
  • Thanks for the solution. It worked . I now have a another query. If say I group the above table based on AGE . What i need now is that based on each group the row number should generate . say for AGE group 24 - the row numbers should be 1.1,1.2,1.3 etc. n for AGE group XX the row numbers should be 2.1,2.2,2.3 etc and so on. – user1699025 Dec 05 '13 at 06:04
  • Serial numbers under groups are a bit tough. We write some `Custom code` under `Report Properties` to achieve that. If you could wait for a few hours, I can look into it and post as an answer here. – kelsier Dec 05 '13 at 06:11
  • Thanks for the response. Is there any such example available online?? – user1699025 Dec 05 '13 at 06:14
  • Yw. I don't know any examples online. If you could wait for a few hours, I can look into it and post as an answer here. – kelsier Dec 05 '13 at 06:15
  • That would be great .. thank u so much. I will wait. – user1699025 Dec 05 '13 at 06:21

1 Answers1

0

I hope this is what you are looking for.

And this is the sample project I created for you. It has the query to create the table called Person, a report project that has an rdl file.

In the rdl file, I've written some code in Code tab in Report Properties window and in the Group Properties window of Age, check out the Variables tab.

Hope that helps!

kelsier
  • 4,050
  • 5
  • 34
  • 49