Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tech2
Yak Posting Veteran
51 Posts |
 Posted - 2013-04-24 : 14:17:51
|
| Report Builder 3.0 - SSRS 2008 R2How can I create a calculated field that i can include on my report that shows the row 'NUMBERS', like in MS EXCEL?A running series.thx, |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-04-24 : 17:03:04
|
| Do you mean something like what the rownumber function does? http://msdn.microsoft.com/en-us/library/ms159225(v=sql.90).aspx |
 |
|
|
tech2
Yak Posting Veteran
51 Posts |
Posted - 2013-04-26 : 11:23:13
|
thanks for the responsethe 'RowNumber(scope)' does not work. I received an error message; 'Has a scope parameter that is not valid for an aggregate function'I tried using the '=CountRows()' function but all I get is number a number (1), on every record.thx,quote:
Originally posted by James K
Do you mean something like what the rownumber function does? http://msdn.microsoft.com/en-us/library/ms159225(v=sql.90).aspx
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-29 : 01:04:00
|
| you need to give your actual scope which is your datasetname or containername or groupname not the text "scope" inside------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
tech2
Yak Posting Veteran
51 Posts |
Posted - 2013-04-29 : 08:47:59
|
this is the expression I used '=RowNumber("DataSet1")'from the Link you provided.It works as a total in a text box.I get the error message when I try to add the NEW calcualted field 'RecordNumber', to my table. Each record should be numbered on my Report.thx,quote:
Originally posted by visakh16
you need to give your actual scope which is your datasetname or containername or groupname not the text "scope" inside------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-30 : 04:48:25
|
| nope. provided you use it in detail section it will number the records returned by dataset------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
Calculated Field