Click Layout tab. Add report item Textbox for title and Table for report body.
Input value of textbox with "LAPORAN NILAI SISWA" (means: student score report), by typing directly on the textbox or on property windows.
Change DataSetName table by choosing existing dataset.
By default table add 3 columns and 3rows that consist of Header, Detail and Footer.
Right click on selection colum to add column to the right or the left, to copy, and to cut (move). Lest try to add a column to the right.
Fill value of cell on header row with the following values in sequence:
- No. Siswa (Student No.)
- Nama Siswa (Student Name)
- Tahun (Year)
- Kota (City)
- Nilai (Score)
We also can activate/deactivate Table Header, Table Detail, or Table Footer.
E.g below for deactivated Table Footer.
Then we'll set value of details with data from dataset. Choose datafield using Value property on Properties Windows.
Rows and columns can be resized horizontally and vertically.
Click on Preview tab to see the result run.
Next lets tidy up our report.
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
0 Comments