SSRS: adding custom page instead of default page

Question

Post reply

SSRS: adding custom page instead of default page

ramoha

SSCommitted

Points: 1909
More actions
October 30, 2007 at 4:05 pm

#180717

Hi,
I can create an .rdl file and upload it to the report manager page i.e. the default page used by reporting services.
http://[servername]/Reports/Pages/Folder.aspx?ViewMode=List
Is there a way that we can create a custom page and upload the .rdl file to that page.
Appreciate your help!
Razi, M.
http://questivity.com/it-training.html

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

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

Scott Thornburg Hall of Fame Points: 3347 More actions · Answer 1

I'm not quite sure what your objectives are.

Are you trying to create a web page that displays a report? If so, the ASP.NET ReportViewer control is an option.

Could you explain further what you are trying to accomplish?

Thanks,

Scott

ramoha SSCommitted Points: 1909 More actions · Answer 2

Thanks for the response:

Im a newbie to SSRS. My manager wants to me to build a report but he doesnt want me to use the default "Report Manager Page" where we upload the .rdl file start viewing the reports. He wants me to create a different page(asp or c# using SSRS) which has a couple of buttons for each report?

Razi, M.
http://questivity.com/it-training.html

mdaniel SSCarpal Tunnel Points: 4616 More actions · Answer 3

You can't modify the Report Manager page, but you can write a page with links to reports and publish it to IIS.

ramoha SSCommitted Points: 1909 More actions · Answer 4

Reply to:mdaniel

---------------

Do we need to create that custom page using c# and then link the reports to it. Any help in creating a sample page would help a lot since I'm a core db guy and not a lot of expertise in front end programming.

Razi, M.
http://questivity.com/it-training.html

Scott Thornburg Hall of Fame Points: 3347 More actions · Answer 5

One possibility is to use SSRS as a Report Server, and then use your own custom ASP.NET page hosting the ASP.NET 2.0 Report Viewer control as the UI. This has worked well for us.

Report Viewer: ReportViewer Controls (Visual Studio)

Report Viewer allow you to

1. manage parameters (or use the default Parameter bar similar to Report Manager);

2. manage security credentials

3. manage look and feel

and so on. The combination of SSRS and ReportViewer control is quite powerful.

Another useful set of links I found are at:

Building Report-enabled Applications with the New ReportViewer Controls (Part 1 of 2)

Building Report-enabled Applications with the New ReportViewer Controls (Part 2 of 2)

Hope this helps,

Scott Thornburg

Scott Thornburg Hall of Fame Points: 3347 More actions · Answer 6

I should have mentioned another possibility besides the ReportViewer control.

SSRS is also nicely addressable via URLs, so you could also simply build a page that collects parameters and passes these via a URL string to your SSRS server

http:// /reportserver/

See SQL Books Online SSRS URL Access: http://msdn2.microsoft.com/en-us/library/ms153586.aspx

Good luck,

Scott

SSRS: adding custom page instead of default page

Cookies on SQLServerCentral