how do add a hyperlink to the parameter section of a SQL Server 2005 Reporting Services report

Expert: I have a SSRS report with 2 textboxes in the upper parameter section of my report which allows user to enter input parameters followed by clicking a View Report button. In addition to the 2 parameter input textboxes I want to add a hyperlink which will allow user to return to the application's main home page (dot net asp webpage).
I am new toSSRS and don't know if this can be done and want to know the steps how to add  the hyperlink to parameter section of the report?
tcmmaxtAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

TSmoothCommented:
I don't believe you can do much to modify what the top parameter section looks like in SSRS report viewer but what you can do is hide the default parameter section and make your own html interface that contains the textboxes for the parameters as well as the hyperlink back to the home page. Your interface would also have a button similar to "View Report" that when you click it, assigns all of the parameters of the report viewer control based on your textbox inputs and then refreshes the report.
0
tcmmaxtAuthor Commented:
thanks sounds great. I am new to srss and not sure how to hide default paramter section and then create the html interface? could you show me or help get started?
0
M3mph15Commented:
Hi,

I would just put almost lihe a header. Maybe with some sort of title and the hyperlink and then have the report viewer control below.


0
TSmoothCommented:
For hiding the things near the top... look at all of the properties/attributes on the control starting with "Show" such as "ShowToolbar". If you set the right ones to false, that will begin hiding the parameter and other areas from the control itself. Then you would create your own input boxes by using asp.net/html controls. When you click on a button to process the report, it depends on if you are using a local or sever report but assuming it's a server report, you'll set the parameters something like so (replacing values as necessary):

Dim rp As New List(Of Microsoft.Reporting.WebForms.ReportParameter)
                Dim param1 As New Microsoft.Reporting.WebForms.ReportParameter("@ParamenterName", "MyValueFromTextBox")
                rp.Add(param1)
                rptvACPReports.ServerReport.SetParameters(rp)

Check out this link for more info and samples on using the report viewer control.
http://www.gotreportviewer.com/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.