Reporting Service Simple Tutorial
Author: Wang Kai
Write a date: 2004-08-02
http://blog.9cbs.neet/muse2008/
table of Contents
Produced a general report
STEP1. Start Visual Studio, New / Project / Business Intelligence Project / Reporting Project.
Step2. Right-click Reports to add / add new items / reports in the Solution Manager.
Step3. Right-click the shared data source to add a new data source (this data source points to a database, all reporters can share this data source)
STEP4. Select [Data] page, select [New Data Set ...] in the drop-down list, enter the name in [Query], such as MyReport1 (this name is used to call the report in the report server), the data source is a new construction Shared data source, command type, if you write a SQL statement directly, select Text, if you are a stored procedure to select StoredProcedure. Query strings can be selected, press [OK]. After entering the SQL statement, press [!] You can in the window Preview data.
Step5. Go to the [Layout] page, drag into [Table] in the toolbox, you can enter the header information in the header, such as the title of the report, etc. Select the entire table, open the property page, select the data set to build in STEP4 in the [DataSetName] item. Drag and drop the fields in [Field] to the corresponding [Details] cell.
Step6. Press [Preview] to view the design effect of the report.
2. Reports with parameters and charts
Please see the video file production with parameters and charts. AVI
3. Reference report in Visual Studio
Control location: C: / Program Files / Microsoft SQL Server / MSSQL / Reporting Services / Samples / Applications / ReportViewer / CS / BIN / Debug / ReportViewer.dll
Please see the video file in VisualStudio. Reference. AVI
