Using Local Microsoft SQL Server Reporting Services in ASP.NET
page 1 of 4
Published: 12 Jul 2007
Abstract
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
Feedback
Average Rating: 
Views (Total / Last 10 Days): 45532/ 110

Introduction

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

Title: http://www.ralphlaurenukoutlet.org.uk/   
Name: franklin marshall outlet
Date: 7/25/2012 11:55:58 AM
Comment:
[url=http://www.franklinmarshalloutletonline.es/]franklin marshall outlet[/url] [url=http://www.franklinmarshalloutletonline.es/]frankin & marshall[/url] [url=http://www.franklinmarshalloutletonline.es/]franklin and marshall online[/url] [url=http://www.franklinmarshalloutletonline.es/]franklin & marshall outlet[/url] [url=http://www.franklinmarshalloutletonline.es/]franklin and marshall outlet[/url] [url=http://www.franklinmarshalloutletonline.es/Mens-Franklin---Marshall/]Mens Franklin & Marshall[/url] [url=http://www.franklinmarshalloutletonline.es/Womens-Franklin-and--Marshall/]Womens Franklin and Marshall[/url]
[url=http://www.franklinmarshalloutletonline.es/Mens-Franklin---Marshall/Franklin-and-Marshall-Hoodie-Sweatshirts/]Franklin and Marshall Hoodie Sweatshirts[/url] [url=http://www.franklinmarshalloutletonline.es/Mens-Franklin---Marshall/Franklin---Marshall-Jackets/]Franklin & Marshall Jackets[/url] [url=http://www.franklinmarshalloutletonline.es/Mens-Franklin---Marshall/Franklin-and-Marshall-Long-Sleeved-T-Shirts/]Franklin and Marshall Long Sleeved T-Shirts[/url] [url=http://www.franklinmarshalloutletonline.es/Mens-Franklin---Marshall/Franklin-and-Marshall-Knitwear/]Franklin and Marshall Knitwear[/url] [url=http://www.franklinmarshalloutletonline.es/Mens-Franklin---Marshall/Franklin-Marshall-Fleece-Pants/]Franklin Marshall Fleece Pants[/url] [url=http://www.franklinmarshalloutletonline.es/Mens-Franklin---Marshall/Franklin---Marshall-Polo-T-shirts/]Franklin & Marshall Polo T-shirts[/url] [url=http://www.franklinmarshalloutletonline.es/Mens-Franklin---Marshall/Franklin-and-Marshall-Short-Tees/]Franklin and Marshall Short Tees[/url] [url=http://www.franklinmarshalloutletonline.es/Mens-Franklin---Marshall/Franklin-Marshall-Shirts/]Franklin Marshall Shirts[/url] [url=http://www.franklinmarshalloutletonline.es/Mens-Franklin---Marshall/Franklin---Marshall-Short-Pants/]Franklin & Marshall Short Pants[/url] [url=http
Title: NIKE NFL jerseys   
Name: NIKE NFL jerseys
Date: 7/2/2012 10:11:12 AM
Comment:
http://www.jersey2shop.com
http://www.cheapjersey2store.com
http://www.jerseycaptain.com
http://www.yourjerseyhome.com
We are professional jerseys manufacturer from china,wholesal.cheap nike nfl jerseys, mlb jerseys, nhl jerseys,nba jerseys and shoes
Cheap NFL,NBA,MLB,NHL
,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,wholesal.cheap nike nfl jerseys, mlb jerseys, nhl jerseys,nba jerseys and shoes. www.yourjerseyhome.com
Title: image is not showing   
Name: Muhammad Aurangzeb
Date: 2/20/2012 7:37:35 AM
Comment:
Image on this article is not showing. any other URL where i read this article with picture.
Thanks
Title: Nice article   
Name: ashwini
Date: 2/23/2011 1:55:55 PM
Comment:
Hi, this is very good stuff . Its very easy to understand.Thanks for explaining step by step
Title: Excellent article   
Name: Tahir
Date: 12/31/2010 1:40:11 AM
Comment:
excellent, to the point and informative.

Thanks
Title: Good Article   
Name: Usman Saeed
Date: 4/1/2010 3:04:17 AM
Comment:
this was quite good
Title: you are fool   
Name: abc
Date: 3/27/2010 2:48:33 AM
Comment:
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: 1/30/2010 1:09:14 AM
Comment:
Hi Mr Shaun Eutsey
it's very nice and simple
Title: It's Nice   
Name: Ramana
Date: 1/22/2010 4:50:44 AM
Comment:
It' nice and very useful.Thax alot.
Title: It's very useful   
Name: Mohammad
Date: 10/21/2009 3:02:46 AM
Comment:
Hi Mr Shaun Eutsey
Your article is very useful for me but images is not clear.
thanks
Title: Mr   
Name: Sathish
Date: 9/1/2009 7:57:45 AM
Comment:
Awesome!!! This worked like a champion. Very informative and helpful. Thanks
Title: perfect!!!!   
Name: Vaastu
Date: 8/4/2009 12:45:17 AM
Comment:
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: 6/21/2009 9:01:56 PM
Comment:
Very Nicely Explained. Thanks!!!






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


©Copyright 1998-2014 ASPAlliance.com  |  Page Processed at 10/20/2014 5:43:48 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search