Using Local Microsoft SQL Server Reporting Services in ASP.NET
page 1 of 4
Published: 12 Jul 2007
This article examines the steps the author took to make the local reports work using Microsoft SQL Server Reporting Services in ASP.NET.
by Shaun Eutsey
Average Rating: 
Views (Total / Last 10 Days): 27839/ 42


There are times in a developer’s life when you get to use great new tools.  Recently, at a client site, I was asked to create a few web based reports that would fit into the application that I was working on.  I was given my options; create them using a repeater control, Crystal Reports or Microsoft SQL Server Reporting Services (SSRS).

Each of these comes with their own benefits and detractions straight from the top. 

The repeater control is easy to get the data formatted, but getting the pages to break in the correct spot is notoriously painful.

Crystal Reports is standard, a little painful, but easy to develop.  However, in production there would have been some licensing difficulties.  I was “encouraged” to not use Crystal.

SSRS are great when they are installed on a SQL Server.  However, this client did not have them installed and had no intention of installing them on the SQL Server 2000 database that the application would run upon. Plans to add a SQL Server 2005 instance were in the plans, but not until after this application needed released.

SSRS was the preferred option, not only by the client, but by me as well. Then the dilemma struck me, I had never used SSRS locally. Thus began my local SSRS adventure.

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-2024  |  Page Processed at 2024-05-23 7:42:01 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search