Post reply

SSRS in windows application

  • March 6, 2008 at 9:19 pm

    #203928

    Hi friends

    I have seen sql server reporting services developed using Business intelligence ,which can be access through a web browser .

    but now requirement is how to use those reports in my windows applications ,first is it possible or not in windows application.

    what changes to be made so that i can access those reports in my windopws application decveloped using C#2005.

    Any help please .........

    Thanks

    Nmsreddy

  • March 11, 2008 at 11:51 am

    #788197

    You have to look into somehting along the line of web control/browser control that will be hosted in win form and render the SSRS contents for you.

    On the other hand, if all the requirements asked for are same contents, you could use embeded Crystal Report to show the same reporting data in win app.

    Again it all depends on how complex are your SSRS reports. For instance, parameterized or not, drill down/drill through or not, and receiving data entry or not.

    Also, printing/faxing/emailing/saving reports are all handled differently in win app vs. web app.

  • March 12, 2008 at 12:00 am

    #788397

    Yes. This is really simple to do.

    You have to use the Microsoft SQL Server 2005 Report Viewer Redistributable component.

    This .Net control is installed on your PC when you install SQL Server Business Intelligence Development Studio. You can freely redistribute the control along with your .Net Windows application as long as the client has the necessary SQL Server CALS.

    It is simple to use. Just drop it into a Windows Form. Set the url to the report, and hey presto a SSRS report inside a windows application. No changes are required to the report. It just works.:w00t:

  • March 12, 2008 at 3:07 am

    #788427

    Thanks to all your replies , i will look for all the suggestions,

  • March 13, 2008 at 2:17 pm

    #789322

    Hi,

    As someone who has used both Crystal and Reporting Services from within .Net projects let me assure you that Reports Services is a much, much better and productive product. Try copying and pasting more then one object from one report to another in Crystal and all you get is one object pasted into the target. Try creating a drop down list in Crystal for users to select from that comes from a DB after the data source is created. In RS its easy to add parameters, additional datasets - Crystal was written 10-20 years ago and it shows.

    Of course you can do almost anything in Crystal (just like you can crawl from New York to Florida) but if you have a choice learn how to use Reporting Services. I dont want to get into a flame war over Crystal (its a fine product and I have done quite a few reporting systems using it) but just check out Reporting Services.

  • May 11, 2009 at 10:45 am

    #992314

    Kerry,

    Can you elaborate on this process? I am a BDA in training and can create SSRS reports with parameters(which is really fun) but am lost as a deveploper (boss loves ASP.net w/C#) Or can you point me to info that would give a step by step.

    It sounds that this would solve some issues and save my bacon.... 😀

    Karen

    aka GeistJager

  • February 25, 2010 at 4:13 am

    #1124832

    Thanks, it is really so easy and works.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply