As an example I still use this report.
Right click on column labeled "No. Siswa" then choose Insert Column to the Left.
Set label column name with No. Urut (means sequence number) and adjust column width.
Right click on detail cell of "No. Urut" then choose menu Expression...
Choose function RowNumber from Common Function -> Miscellaneous. Type dataset name "DBSAMPLE" as scope parameter to get sequence that applied to report content globally.
= RowNumber("DBSAMPLE")
The result is number sequenced from the beginning of report to last row.
Otherwise if we want to sequence only per group change scope parameter to group name "grpYear"
= RowNumber("grpYear")
The result is number sequenced per group.
Click here if you like this article.
Related Article:
- Installing Business Intelligence SQL Server 2005
- Creating Report with SQL Server Reporting (Wizard)
- Creating Report with SQL Server Reporting (without wizard) | Part 1
- Creating Report with SQL Server Reporting (without wizard) | Part 2
- Design Layout Report
- Creating Parameter for Filtering
- Stored Procedure as Report Data Source
- Parameter Data List from Database Query
- Creating Report Group
- Create Sequence Number Using RowNumber Function
- Uploading Report FIle (.rdl) to Report Server
- Remove Report Page Break/Page Break
- Query to Generate Subscription List
- Direct Printing to Printer
0 Comments