Monday, March 12, 2012
Parameters Pane
Pane outside of taking away the prompts for a parameter? I tried doing
that and it won't allow me to pass parameters in a URL.
I also tried '&rc:parameters = false' but the allows a user to pull the
parameters pane back. I'd like to keep it from ever being expandable.
thanks
adamIf you have SP1 or greater then you can hide the parameters. A hidden
parameter will not show up in the parameter pane but can be passed in via
the url. Of course there are no security restrictions on this so a user can
still modify the url to pass in any parameter.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
<adam.rhodes@.gmail.com> wrote in message
news:1126123266.374180.41760@.z14g2000cwz.googlegroups.com...
> Is there a way to absolutely bar a user from calling up the Parameters
> Pane outside of taking away the prompts for a parameter? I tried doing
> that and it won't allow me to pass parameters in a URL.
> I also tried '&rc:parameters = false' but the allows a user to pull the
> parameters pane back. I'd like to keep it from ever being expandable.
> thanks
> adam
>
Friday, March 9, 2012
Parameters in Report Server
There is a brown bar in Report Server that holds the report parameters. This bar seems to be CLOSED by default. Is there a way to set the default so that the parameter bar is OPEN and the users can see the parameters?
Thanks.
I don't think you can set this as a default, and I don't suspect your users will be browsing the reportserver virtual directory. So assuming you are providing a link of some sorts (throu email or an application) you can control the parameters area using the rc: Prameters URL query string parameter.
The following is an excerpt from http://msdn2.microsoft.com/en-us/library/ms152835.aspx
Toolbar
Show or hide the toolbar. If the value of this parameter is false, all remaining options are ignored. If you omit this parameter, the toolbar is automatically displayed for rendering formats that support it. The default of this parameter is true.
Parameters
Show or hide the parameters area of the toolbar. If you set this parameter to true, the parameters area of the toolbar is displayed. If you set this parameter to false, the parameters area is not displayed and cannot be displayed by the user. If you set this parameter to a value of Collapsed, the parameters area will not be displayed, but can be toggled by the end user. The default value of this parameter is true.
Zoom
Set the report zoom value as an integer percentage or a string constant. Standard string values include Page Width and Whole Page. This parameter is ignored by versions of Microsoft Internet Explorer earlier than Internet Explorer 5.0 and all non-Microsoft browsers. The default value of this parameter is 100.
Section
Set which page in the report to display. Any value that is greater than the number of pages in the report displays the last page. Any value that is less than 0 displays page 1 of the report. The default value of this parameter is 1.
StartFind
Specify the first section to search. The default value of this parameter is the first page of the report.
EndFind
Set the number of the last page to use in the search. For example, a value of 5 indicates that the last page to be searched is page 5 of the report. The default value is the number of the current page. Use this parameter in conjunction with the StartFind parameter.
FallbackPage
Set the number of the page to display if a search or a document map selection fails. The default value is the number of the current page.
GetImage
Get a particular icon for the HTML Viewer user interface.
Icon
Get the icon of a particular rendering extension.
Stylesheet
Specify a style sheet to be applied to the HTML Viewer.
Wednesday, March 7, 2012
Parameters Bar
I would like to expand the size of parameters bar, is it possible with SP1?
I have too many parameters to deal with and I don't want users to scroll
through.
Thanks.
Regards,
CemBecause of an IE issue the splitter bar between the parameter area and the
report body does not remember it location when Report Manager (http:
//<someservername>/reports/...). The splitter bar behavior works correctly
when you are view the report via the server (http://
<someservername>/reportserver/...)
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cem Demircioglu" <cem@.NoSpamPlease.com> wrote in message
news:%23r6kkCveEHA.3376@.TK2MSFTNGP10.phx.gbl...
>
> Hello,
> I would like to expand the size of parameters bar, is it possible with
SP1?
> I have too many parameters to deal with and I don't want users to scroll
> through.
> Thanks.
> Regards,
> Cem
>
Saturday, February 25, 2012
Parameters and Horizontal Scroll Bar
dynamically populated. In the case there is only one value, the horizontal
scroll bar is covering up that value and the user cannot see it to select it.
Are there other workaround other than coding for a "dummy" value in the list?On Jan 15, 11:18 am, Chriss G <Chri...@.discussions.microsoft.com>
wrote:
> I am experiencing a problem whereas I have a parameter dropdown that is
> dynamically populated. In the case there is only one value, the horizontal
> scroll bar is covering up that value and the user cannot see it to select it.
> Are there other workaround other than coding for a "dummy" value in the list?
As far as I know, there is not. A work around would be to create a
custom ASP.NET application that gives some flexibility in the sizing
of the web controls and then call SSRS via the RS web service or URL
access. Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant