Hide Parameters toolbar

How to hide specific parameters from the toolbar:

I use the following link, it hides the whole parameters toolbar.

http://ServerName/reportserver?/PPTReports/rptStatSU&rs:Command=Render&rs:Format=HTML4.0&rc:Parameters=false&eStatus=Open&UserName=jSmith

I have two parameters out of that would oike to hide just one of them which is username.

i am using sqlserver 2000 reporting services, i don't see that option hide.

Please does anyone know how to do it.

Thank you very much for the information.

No, in SQL Server 2k you can only hide the report parameters as a whole. In SQL Server you have the possibility to set the parameter to "hidden" or "internal", but if you don′t have the chance of migrating you are stuck to the option to switch of the whole parameter toolbar.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

hide column based on Parameter

Hello All,
I need an expression that hides a column based on the report parameter.
So, I add the following expression to column Visibility property:
=IIF(Parameters!active.Value = "Current", True, False)
Which gives me the following expression error:
"Input string was not in the correct format"
Any help is appreciated, I've already searched through previous newgroups
entries/bol with no luck.
Thanks in advance,
RobMy apologies.
Issue has been resolved.
Thanks, R
"Rob" wrote:
> Hello All,
> I need an expression that hides a column based on the report parameter.
> So, I add the following expression to column Visibility property:
> =IIF(Parameters!active.Value = "Current", True, False)
> Which gives me the following expression error:
> "Input string was not in the correct format"
> Any help is appreciated, I've already searched through previous newgroups
> entries/bol with no luck.
> Thanks in advance,
> Rob
>
>

hidden textbox

Hi,
I want to hide/show some text in a textbox based on a condition.
It works fine , but the problem is when the text is hidden it also hides the
borders (top, left, right, bottom) with it.
Is there a way to hide only text and not the borders.
Thankyou.What you can do is set the value of the textbox to nothing based on the
condition
instead of hiding the text box itself. That way you can have the borders
around the text box and its content set as nothing.
"Ni" wrote:
> Hi,
> I want to hide/show some text in a textbox based on a condition.
> It works fine , but the problem is when the text is hidden it also hides the
> borders (top, left, right, bottom) with it.
> Is there a way to hide only text and not the borders.
> Thankyou.
>|||Put the textbox inside of rectangle. Have border on rectangle. Hide textbox
only.
--
Alex Mineev
Software Design Engineer. Report expressions; Code Access Security; Xml;
SQE.
This posting is provided "AS IS" with no warranties, and confers no rights
"Ni" <Ni@.discussions.microsoft.com> wrote in message
news:00BCADBC-5B16-4916-A265-C7E8288529B6@.microsoft.com...
> Hi,
> I want to hide/show some text in a textbox based on a condition.
> It works fine , but the problem is when the text is hidden it also hides
the
> borders (top, left, right, bottom) with it.
> Is there a way to hide only text and not the borders.
> Thankyou.
>