running number

Hot Topic

Accessing Mobile SQL Databases in VB2005 - Windows Apps
Schedule backup SQL Server 2000
Attach database from network drive
format print range when converted to Excel?
How can I detect which version of sqlServer I am connected to using smo?
Drill Down Toggle does not refresh in Report Manager
Unhandled Exception...Please check the version of the database
Restore Database from file
ADO Connection Pooling Error: "The client was unable to reuse a session with ..."
SQL XML Bulk Load working without visible Error/Exception but no data is inserted!?

SQL Server

Error Message 443
Error 0xc0202009 for importing access97 into sql
Cannot create a report - VS 2005/SQL 2005
Using variable of Foreach loop - File Enumerator
June CTP: cannot install: Office 2003 Web Components
Concatinating Select Results
SMO & DMO FAQ
Bind object to RDLC Report
Establish connection to the server
bcp problem

running number

how do i create running number in sql reporting services 1,2,3 and so on. it is beside my record. PLS HELP. thanks. guys pls post ur suggestions..Sad

Answer this question

running number

  • CBWoodSr

    Check out the function RowNumber.

    E.g. Add a row to your report and set the expression to =RowNumber(Nothing)  

    Trond

     

  • nidheesh

    hi i got it. thanks. but i have this problem. i have this reports for gross pay, deduction and payroll report. with the deduction report it works but with the other it doesnt. they are similar to one another [in terms of groupings, etc. im using this code =RunningValue(1, Count, "code")]except for the data it displays. what should be the problem in one report it has number of 3 then 5 then 3 then 5,10,15. the othe one it has 2 then 4 then 2 then 4,8,12.
    thanks a lot! i really appreciate all of ur help..

  • Dhirajgupta27

    hey.. i tried it and it worked.. thanks! my prob now is how to reset the number as the group changes. hope you could help with this. thanks again.. means a lot!Smile

  • ChrisMSG

    In this case, you can often use the RunningValue function.
    E.g. =RunningValue(1, Count, "NameOfGroupYouWantToReset")

    -- Robert

  • running number
Answer this question