Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

3 questions about SQL 2005 Reporting Services Expand / Collapse
Author
Message
Posted Tuesday, April 08, 2008 10:29 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 4:42 AM
Points: 193, Visits: 541
Hello,

I have 3 questions about SQL 2005 Reporting Services, can you help me ?
(1)I can't hide the HTML Viewer toolbar. I have tried both the &rc:Toolbar=false and &rs:Toolbar=false, they could display the report but the Toolbar still existed.
(2)I want the Report hide the Toolbar but still displays user entered input parameter values, is it possible ?
(3)Can I only hide the Toolbar through URL access ? Eventually, I will use a ReportViewer control and use ASP to display a Report, but I found I couldn't enter any URL parameter in Visual Studio Report Designer. How can I, for example, on my ASP, display a SQL 2005 Report with input parameter values but no Toolbar ?
Post #482035
Posted Thursday, April 10, 2008 2:46 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 26, 2012 1:35 PM
Points: 170, Visits: 183
For your question 3, here is my suggestion.
Add ReportViewer control to your asp.net page, set the ProcessingMode to Remote, then add your reporting server information under "ServerReport" section.

There are a group of Property "ToolBar", the Html toolbar will disappear if you set all to "False"

With "ShowParameterPrompt" = True, the report will ask user to input parameters.
Post #483310
Posted Friday, April 11, 2008 8:50 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 4:42 AM
Points: 193, Visits: 541
Thanks.

I fixed the problem by myself.

Thanks a lot.
Post #484025
Posted Thursday, May 08, 2008 5:58 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 09, 2008 8:03 PM
Points: 1, Visits: 8
Could you please share how did you solve that issue?

Thanks in advance,
Pab
Post #497521
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse