Using Local Microsoft SQL Server Reporting Services in ASP.NET
page 2 of 4
by Shaun Eutsey
Average Rating: 
Views (Total / Last 10 Days): 29789/ 71

The Scenario

Before we get started on actually writing our local report, we should delve into the database that we will be using. As with most example applications we will be working with the Northwind database.  We will write a report based on the Customers and Orders Tables. I will be demonstrating this using parameters and without using parameters. The basic query that I will be using in both instances is below.

Listing 1

Select OrderID,
from   Customers cst
inner join Orders od on
      od.CustomerID = cst.CustomerID 

First, I will create a new website called SSRSExample.  I will be using Visual Basic 2005 as my development language. Also, since this is an example, I am going to go light on the design and focus more on the process of creating the report.

Figure 1

View Entire Article

User Comments

Name: franklin marshall outlet
Date: 2012-07-25 11:55:58 AM
[url=]franklin marshall outlet[/url] [url=]frankin & marshall[/url] [url=]franklin and marshall online[/url] [url=]franklin & marshall outlet[/url] [url=]franklin and marshall outlet[/url] [url=]Mens Franklin & Marshall[/url] [url=]Womens Franklin and Marshall[/url]
[url=]Franklin and Marshall Hoodie Sweatshirts[/url] [url=]Franklin & Marshall Jackets[/url] [url=]Franklin and Marshall Long Sleeved T-Shirts[/url] [url=]Franklin and Marshall Knitwear[/url] [url=]Franklin Marshall Fleece Pants[/url] [url=]Franklin & Marshall Polo T-shirts[/url] [url=]Franklin and Marshall Short Tees[/url] [url=]Franklin Marshall Shirts[/url] [url=]Franklin & Marshall Short Pants[/url] [url=http
Title: NIKE NFL jerseys   
Name: NIKE NFL jerseys
Date: 2012-07-02 10:11:12 AM
We are professional jerseys manufacturer from china, nike nfl jerseys, mlb jerseys, nhl jerseys,nba jerseys and shoes
,heap jerseys,2012 nike nfl Jerseys,nba jersey and shorts,oklahoma city thunder jersey,official jeremy lin new york knicks jersey,NFL Jerseys Wholesale,blake griffin jersey blue,NFL jerseys For Sale online.All Our Jerseys Are Sewn On and Directly From Chinese Jerseys Factory
,Wholesale cheap jerseys,Cheap mlb jerseys,]Nike NFL Jerseys,Cheap China Wholesae,Wholesale jerseys From China,2012 nike nfl Jerseys,Jerseys From China,,2012 nike nfl Jerseys,Revolution 30 nba jerseys,jersey of nba chicago bulls direk rose ,nfl jerseys,green bay packers jerseys wholesale,Buffalo Bills nike nfl jerseys sale,good supplier soccer jerseys,cool base mlb jerseys,Revolution 30 nba jerseys,2012 stanley cup nhl jersey,
We are professional jerseys manufacturer from china, nike nfl jerseys, mlb jerseys, nhl jerseys,nba jerseys and shoes.
Title: image is not showing   
Name: Muhammad Aurangzeb
Date: 2012-02-20 7:37:35 AM
Image on this article is not showing. any other URL where i read this article with picture.
Title: Nice article   
Name: ashwini
Date: 2011-02-23 1:55:55 PM
Hi, this is very good stuff . Its very easy to understand.Thanks for explaining step by step
Title: Excellent article   
Name: Tahir
Date: 2010-12-31 1:40:11 AM
excellent, to the point and informative.

Title: Good Article   
Name: Usman Saeed
Date: 2010-04-01 3:04:17 AM
this was quite good
Title: you are fool   
Name: abc
Date: 2010-03-27 2:48:33 AM
you r wating our time means your fool and dont submit any doc like this ok .fool fool fool
Title: Useful Article   
Name: Suresh
Date: 2010-01-30 1:09:14 AM
Hi Mr Shaun Eutsey
it's very nice and simple
Title: It's Nice   
Name: Ramana
Date: 2010-01-22 4:50:44 AM
It' nice and very useful.Thax alot.
Title: It's very useful   
Name: Mohammad
Date: 2009-10-21 3:02:46 AM
Hi Mr Shaun Eutsey
Your article is very useful for me but images is not clear.
Title: Mr   
Name: Sathish
Date: 2009-09-01 7:57:45 AM
Awesome!!! This worked like a champion. Very informative and helpful. Thanks
Title: perfect!!!!   
Name: Vaastu
Date: 2009-08-04 12:45:17 AM
first of all thank u very much :)
this article really help me to understand ,how to code & design a SQL report Step by Step .
very informatics and very ease to understand with the help of attached snapshots.
This Alliance doing gr8 job Carry on !!!!
Title: Thanks!!   
Name: Pooja
Date: 2009-06-21 9:01:56 PM
Very Nicely Explained. Thanks!!!

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

©Copyright 1998-2023  |  Page Processed at 2023-09-25 7:17:21 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search