1 / 10

Reports

Reports. Creating a Report Project in Visual Studio 2005 Adding a Report Data Source Creating a Report Adding a Stored Procedure Data Set to a Report Designing a Report Demonstration only—no slide support. These slides are for reference only. They are not "lecture notes".

roryd
Télécharger la présentation

Reports

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Reports • Creating a Report Project in Visual Studio 2005 • Adding a Report Data Source • Creating a Report • Adding a Stored Procedure Data Set to a Report • Designing a Report • Demonstration only—no slide support These slides are for reference only. They are not "lecture notes"

  2. Create New Report Server Project • Start Visual Studio 2005 • Subset of VS ships withSQL Server • Create a New Project • Create | Project… from theStart Page • File | New | Project… from the menu Start Here

  3. Create New Report Server Project (cont.) Choose BusinessIntelligence Projects Choose Report Server Project Name Project Specify folder location Press OK

  4. Do not choose Add New Data Source Add Data Source Right Click

  5. Create Data Source Give data source a meaningful name Confirm SQL Server Press Edit…

  6. Creating a Data Source Connection Enter "(local)" in the Server name space * Select the database name from the available list Press Test Connection(optional but recommended) Press OK * Or named server including network path if not on the local machine

  7. Creating a Data Source Connection string is now filled in for you Press OK Data Source is added to the solution

  8. Creating a Report Right-click Reports Select Add | New Item… Select Report Do not choose "AddNew Report" Name report (something meaningful) Click Add

  9. Binding Data to a Report Top of the Report Design window Select Data tab (if not already selected) In Dataset combo select <New Dataset…> Name the dataset Select Data source Set Command type to "Stored Procedure" Click OK

  10. Binding Data to a Report (cont.) 2 1 4 3 DatasetDefinition Select stored procedure name from list (list only appears after creating dataset as Stored Procedure type) Exclamation mark will run the SP and preview the data in the grid Refresh Fields icon will read structure of the data returned by the SP and add it to the dataset definition Now ready to switch to Layout view to begin designing the report

More Related