<OPTIONAL : DRILL DOWN>
a. Right-Click on Body > Insert Group
b. Right-Click in Your Group Row and choose Edit Group (have icon like Number “1”), In General tab added Expression and save.
c. Right-Click in Row (Non-Group) , choose edit group and Choose Visibility tab, setting like picture.
B. PUBLISH .RDL REPORT at IIS
Start Menu > run > inetmgr
If you have SQL Server 2005 Installation, in WebSites folder will have Report Virtual Directory. Right Click at Report Virtual Directory and browser.
Create New Folder if you want grouping your report, and choose upload file to publish your .rdl file.
Don’t forget to set your DataSource host and database name to make connection :
Important to set Datasource like “Data Source=host; Initial Catalog=DBNAME”
PUBLISH REPORTING USING SOLUTION
1. Right-click at solution and properties, set Datasource target Folder,Target Report Folder and Target server URL = http://hostname/ReportServer , if using not default instance http://hostname/InstanceName$ReportServer
2. Right -Click Solution and Deploy
C. OPEN REPORT WITH ASP.NET
Create New Project ASP.NET using VS2005 sp1 with Web Project. File > New > Visual Basic > Web > ASP.NET Web Application.
Drag ReportViewer to design form and setting Report Server URL=http://localhost/reportserver and Report Path=/LatReport/ReportUserList with leading / ( /FOLDER/REPORT_NAME )
Run your website and see the report include in your form.
Example Link : http://localhost/ReportServer/?/FOLDER/REPORT_NAME