Download
reports n.
Skip this Video
Loading SlideShow in 5 Seconds..
Reports PowerPoint Presentation

Reports

6 Views Download Presentation
Download Presentation

Reports

- - - - - - - - - - - - - - - - - - - - - - - - - - - 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