Showing posts with label hidden. Show all posts
Showing posts with label hidden. Show all posts

Wednesday, March 28, 2012

Is there a property in the report designer to set a report, datasource, etc to be hidden in repo

Is there a property you can set in report designer to make a report or datasource hidden in report manager? I am making a rss script to deploy all datasources and reports, but some I want hidden. If you can't set it in report designer is there a way to set the property in the rss script for the reports and datasources? Thanks.

There is no property that can be set from report designer.

You can hide report or datasource by setting property "Hidden" to true

Dim Properties() As Property = New Property(0) {}
Dim hidden as new Property
hidden.Name="Hidden"
hidden.Value = "true"
Properties (0) = hidden
RS.CreateReport(Report, Parent, Overwrite, Definition, Properties)

Friday, March 23, 2012

Is there Password filed in SQL 2000 ?

I don't know there is Password filed in SQL 2000 or not ?
If there is not , then How to hidden password in database.
pls help me !Do you mean is there a password datatype, as in MS Access?

No. There is not.

You need to encrypt the passwords yourself using either a custom one-way encryption algorythm or the built in SQL Server encryption functions.

Wednesday, March 7, 2012

is problems with hidden parameters solved in sp1?

I have installed the sp1
But the problem with hidden parameters is still there. I could not set the
value of hidden parameter from the querysting.
Let me know how to check whether the sp1 is properly installed or not.
Thanks in advanceThis is onlt supported on the server. In Report Manager, leave the 'prompt
user' checkbox checked but clear our the prompt string. This should not
prompt the user but still allow you to specify them via URL.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"VV" <vineshk@.omegatech.com> wrote in message
news:OkNdQneWEHA.2520@.TK2MSFTNGP12.phx.gbl...
>I have installed the sp1
> But the problem with hidden parameters is still there. I could not set the
> value of hidden parameter from the querysting.
> Let me know how to check whether the sp1 is properly installed or not.
> Thanks in advance
>|||Just a suggestion -
Wouldn't it be better if you provide with a checkbox in Report Manager
that just says "hide parameter" and which in turn will clear the
prompt string an keep the prompt user checked... ' It took me 20 min.
to figure out that. Your readme on sp1 is not clear on this...
Thanks|||Yes, but this required a string change that we didn't want to add in SP1. We
will make it more understandable in the future.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Harsh" <creative@.mailcity.com> wrote in message
news:fa671a26.0406281005.1cf5f133@.posting.google.com...
> Just a suggestion -
> Wouldn't it be better if you provide with a checkbox in Report Manager
> that just says "hide parameter" and which in turn will clear the
> prompt string an keep the prompt user checked... ' It took me 20 min.
> to figure out that. Your readme on sp1 is not clear on this...
> Thanks