I am good at SSRS, now I want to learn to use .net application to get reports on a website and then print them

Question

I am good at SSRS, now I want to learn to use .net application to get reports on a website and then print them

AR-777

Ten Centuries

Points: 1288
More actions
April 8, 2009 at 3:33 pm

#208055

Hi, i am a backend developer and i work extensively with SSRS 2005, in my project i have various .rdl files
now i want to learn how to use visual studio (2005/2008) to create and web application to generate the reports on a website and then print all the .rdl files together.
I need some kind of beginners guide to using asp.net with SSRS can you please provide links and information...
Thanks a lot
Please do reply

Viewing 9 posts - 1 through 8 (of 8 total)

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

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

You have many options to run SSRS reports on the Web through web service so you deploy your reports to a web service in SSRS. You can also run your reports through web Reportviewer control in VS2005/8 in VS2005 you can run it in local mode and run without SSRS license but VS2008 does not come with local mode so you need SSRS license.

The other option to run Windows SharePoint Services free and upload your reports to it.

Check below for code samples for Web and Winform Reportviewer you can use.

http://www.gotreportviewer.com/

Kind regards,
Gift Peddie

AR-777 Ten Centuries Points: 1288 More actions · Answer 2

so does it mean that i can do the following...

i have created 10 rdl files in my SSRS. can i build a web application which will taken in a parameter (id) and print all the 10 rdl files together for this id.

if i can build such an application can you please tell me how...

thanks

Gift Peddie SSC Guru Points: 73570 More actions · Answer 3

If you had downloaded and open those code samples you will not ask me this question because you would know it is possible. However I think it is crude implmentation because if you load one report per control then you know how to track and resolve isues. Download tutorial number 11 and you will see how to load your Report into Asp.net ReportViewer control.

http://www.asp.net/learn/sql-videos/

Kind regards,
Gift Peddie

Jayaram Krishnaswamy SSC Eights! Points: 970 More actions · Answer 4

I have the right kind of book for you which I highly recommend.

"Learning SQL Server Reporting Services 2008" by Packt Publishing, UK.

This book has over 50 hands-on exercises that will drill you through becoming proficient at turning out reports and all there is to know about reporting services.

Check out the details at my site:

http://hodentek.blogspot.com

You can also enjoy a free chapter on Report Builder 2.0 while you are there.

george.lewycky Mr or Mrs. 500 Points: 570 More actions · Answer 5

I looked for this video but couldn't find it

Do you still have it or remember where you found or its exact name ?

Thanks alot

We are migrating from SSRS to ReportViewer, how does this work with the reports parameters ?

Can it dynamically code for the parms or do we have to code for each report individually as indicated on this website ?

http://forums.asp.net/t/1472608.aspx

Thanks in advance

George

Sean Lange SSC Guru Points: 286590 More actions · Answer 6

george.lewycky (11/4/2015)
I looked for this video but couldn't find it
Do you still have it or remember where you found or its exact name ?
Thanks alot
We are migrating from SSRS to ReportViewer, how does this work with the reports parameters ?
Can it dynamically code for the parms or do we have to code for each report individually as indicated on this website ?
http://forums.asp.net/t/1472608.aspx
Thanks in advance
George

This thread is 6 years old and the person who posted that link hasn't logged in to this site in over 3 years. I suspect you are chasing ghosts trying to find that video.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

george.lewycky Mr or Mrs. 500 Points: 570 More actions · Answer 7

Thanks Sean

ReportViewer postings of people using it have been minute so when I find a good reference, posting, etc

I need to pursue contacting them or others in the thread

George

dimensionseo Newbie Points: 1 More actions · Answer 8

After browsing online i got one useful link http://www.c-sharpcorner.com/uploadfile/jayendra/how-to-create-a-ssrs-report-in-Asp-Net/. I hope this will also help you.