Visual Studio 2005 Beta 2 and Reporting Services
page 2 of 2
by Terry Voss
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 14102/ 23

Creating a Local Report

Below is what the ReportViewer looks like in the ASP.NET designer when the control is not fully expanded.

Figure 1 – The ASP.NET version of the ReportViewer control, in context.


On the upper right-hand side of the control, notice the small smart tag arrowhead pointing to the right. Clicking on this tag is a fast way to access the settings of the crucial properties needed to get the report running. Also note the Data Sources tab under the Toolbox tab on the left edge of the image.

The steps for creating and running a report in Local mode are as follows.

  1. Create a new form and drag a ReportViewer control onto it.
  2. Create a new Report (via the smart tag or by pressing Ctrl-Shift-A and selecting Report as the type of item to add).
  3. Create a DataSource via the Data Sources tab's visual designer. This DataSource will be used by the report created in step 2.
  4. Drag fields from the DataSource into the Header and Table cells of the new report.
  5. Open the form created in step 1, and use the smart tag of the ReportViewer control to select the report which was created in step 2.
  6. Now, since the default is Local versus Remote mode, we simply need to set our form as the startup form and run it.

If you want to run in Remote mode using reports published to SQL Server, set ProcessingMode to Remote via the dropdown list, and set the location of the report with a URL. See the pertinent properties in Figure 2 below.

Figure 2 – Properties Relating to Local versus Remote Reporting


These reports have many advantages as discussed in an earlier article, Comparing HTML Reporting and MS SQL Server Reporting Services.

The six steps above can be completed in 60 seconds for a simple one-to-many table-based report that requires no code to be supplied by the developer. The new Reporting Services has become even more valuable to me as a reporting option.


View Entire Article

User Comments

Title: webmonkey   
Name: T Dog
Date: 2007-02-06 1:57:26 PM
Great article. To the point and easy to follow.

There seems to be a gap in sql reporting services and visual studio 2005. This is the answer of how to bridge the gap.
Title: Help   
Name: Brian McMasters
Date: 2006-06-29 3:53:15 PM
I enjoyed the article. However, I am interested in deploying ASP.NET reports I generated in VS 2005. I hope that this information is currently available online.
Title: mr   
Name: steven connor
Date: 2006-04-11 12:07:11 PM
Hi i am learning visual web stuides and i unsure how to create a form like this where you enter your comments and then they appear below like yours i was wondering if you could provide me with any help.
Title: Microsoft MVP - ASP/   
Name: Samer Chidiac
Date: 2005-08-10 3:36:11 AM
Nice Article, i always enjoy reading Small / Effective -Straight to the Point - Articles.. Good Job. SC

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2024  |  Page Processed at 2024-04-13 9:51:41 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search