Hide in list view

Within Report Manager you can check the 'Hide in list view' box for any
report within a folder, but then that report can still be viewed within that
folder if you select the 'Show Details' button on the folder header. I
expected the Show Details button not to be available for report users, but it
is. Is there another way of hiding a report within a folder?DKN,
You can modify the role assignments to prevent a user from navigating
the folder hierarchy.
Andy Potter

Hide folder in Report Manager

Hi All,

How to hide a folder in Report Manager? For Example, I don't want to show the DataSource Folder in the Report Manager.

TIA

Hi TIA,

You can hide the datasource folder by going to properties(general tab) of the folder and check "Hide in list view".

- Kranthi

|||

Thank you Kranthi,

But I still can see that folder, is that because I am an Administrator?

hide duplicates.. another pdf bug?

I'm getting different views where I run the report from the Report Manager
and then after its exported to pdf. The results are the same when the report
is viewed from the Preview Mode in the Report Deisigner.
The Report has 3 groupings on data and I'm hiding some column values using
"Hide Duplicates". As menioned above, the "hide duplicates" functionality
works well in the Report Designer & Report Manager before exporting to pdf.
Is this a bug in the export functionality? How do I take care of this
discrepancy?
ThanksWhat is more exactlly the discrepancy? Are the textboxes still visible in
pdf? Could you send us the report and data to repro, please?
--
Nico Cristache [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"newmem" <""> wrote in message news:u9OR7jTXEHA.3640@.TK2MSFTNGP11.phx.gbl...
> I'm getting different views where I run the report from the Report Manager
> and then after its exported to pdf. The results are the same when the
report
> is viewed from the Preview Mode in the Report Deisigner.
> The Report has 3 groupings on data and I'm hiding some column values using
> "Hide Duplicates". As menioned above, the "hide duplicates" functionality
> works well in the Report Designer & Report Manager before exporting to
pdf.
> Is this a bug in the export functionality? How do I take care of this
> discrepancy?
> Thanks
>

Hide Databases

Hi Folks,
I=B4m sharing a SQL Server 2000 SP3a with some users.
These users are using Enterprise Manager and Query=20
Analyzer at client side. It=B4s working well.
My problem is: In Enterprise Manager view, users can see
all databases, but only can manipulate your database.
My Question: In SQL Properties, How can I hide Databases=20
to non-owners ?
Thanks
Alex Decarli.This is not possible in SQL2000 Enterprise Manager. Metadata security is
pretty lax.You can choose to hide System databases if you wish , by going
into Edit SQL Server Registration Properties and uncheck Show system
databases and system objects
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Alex Decarli" <anonymous@.discussions.microsoft.com> wrote in message
news:079401c3dc1a$9849ce20$a501280a@.phx.gbl...
Hi Folks,
Im sharing a SQL Server 2000 SP3a with some users.
These users are using Enterprise Manager and Query
Analyzer at client side. Its working well.
My problem is: In Enterprise Manager view, users can see
all databases, but only can manipulate your database.
My Question: In SQL Properties, How can I hide Databases
to non-owners ?
Thanks
Alex Decarli.

Hide Databases

Hi Folks,
I=B4m sharing a SQL Server 2000 SP3a with some users.
These users are using Enterprise Manager and Query=20
Analyzer at client side. It=B4s working well.
My problem is: In Enterprise Manager view, users can see
all databases, but only can manipulate your database.
My Question: In SQL Properties, How can I hide Databases=20
to non-owners ?
Thanks
Alex Decarli.This is not possible in SQL2000 Enterprise Manager. Metadata security is
pretty lax.You can choose to hide System databases if you wish , by going
into Edit SQL Server Registration Properties and uncheck Show system
databases and system objects
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Alex Decarli" <anonymous@.discussions.microsoft.com> wrote in message
news:079401c3dc1a$9849ce20$a501280a@.phx.gbl...
Hi Folks,
Im sharing a SQL Server 2000 SP3a with some users.
These users are using Enterprise Manager and Query
Analyzer at client side. Its working well.
My problem is: In Enterprise Manager view, users can see
all databases, but only can manipulate your database.
My Question: In SQL Properties, How can I hide Databases
to non-owners ?
Thanks
Alex Decarli.

Hide a parameter

Using Report Manager (default viewer for Reporting Services) is possible to
choose one parameter to be hide. This hide parameter has a default value and
the user inform the others.
thanksHi Julio,
On the parameter property dialog you can uncheck the "Prompt user"
checkbox.
--
Scott
http://www.OdeToCode.com
On Tue, 3 Aug 2004 08:29:56 -0300, "Julio"
<julio.caldas@.brfree.com.br> wrote:
>Using Report Manager (default viewer for Reporting Services) is possible to
>choose one parameter to be hide. This hide parameter has a default value and
>the user inform the others.
>thanks
>

Hidden Parameters and Default Values

I am using RS SP1, and to use a hidden parameter that is NOT read
only, after uploading the report into report manager.. at this stage
the report works FINE, with all the other parameters (not hidden)
working, they are combinations of query based lookups with query based
defaults, and ones with defaults by an expression in the report.
However after i go into the properties of the report in report
manager, to the parameters tab, and set the check box of my hidden
parameter ON, and set the prompt to an empty string (so its a hidden
but not readonly parameter).. then save that
THEN
my other parameters whose DEFAULT values were written by an expression
in the report - NO LONGER WORK
arrgh,
anybody got a solution?
the only work around i can think of is have a DUMMY SQL call that
basically just selects the value of my expression. (since the
parameters whose default values are based on a query rather than
expression still work)
Karli'm sure this is a bug..
whenever i have a default value for a parameter (that isn't pulldown)
that is calculated with an expression , weather it is based on a query,
or just a pure expression, all works fine, until you go to report
manager, and change anything in the parameters (i'm changing an
unrelated parmeter to be hidden (readable but not visible), when you
apply, all the default value calculations cease to work :(
Karl Prosser wrote:
> I am using RS SP1, and to use a hidden parameter that is NOT read
> only, after uploading the report into report manager.. at this stage
> the report works FINE, with all the other parameters (not hidden)
> working, they are combinations of query based lookups with query
based
> defaults, and ones with defaults by an expression in the report.
> However after i go into the properties of the report in report
> manager, to the parameters tab, and set the check box of my hidden
> parameter ON, and set the prompt to an empty string (so its a hidden
> but not readonly parameter).. then save that
> THEN
> my other parameters whose DEFAULT values were written by an
expression
> in the report - NO LONGER WORK
> arrgh,
> anybody got a solution?
> the only work around i can think of is have a DUMMY SQL call that
> basically just selects the value of my expression. (since the
> parameters whose default values are based on a query rather than
> expression still work)
> Karlsql

Hidden Master, Model, MSDB, and Tempdb Databases.

Thanks in advance.
I have an instance of Enterprise Manager for SQL Server 2000 on my
desktop that does not list the above databases. When I attempt to add
any of them, I receive: "Error 5123: CREATE FILE encountered operating
system error 32.". I see all the databases in the server's copy of EM.
My questions are twofold. What is the likely reason my workstation
copy of EM got this way? How do I best fix this? I suspect I may have
to wait for no users to be on the system, but I hope someone knows a
way to fix this without doing so. Also the TempDB does not appear as
an mdf file, which I guess is because it is a temporary construct that
exists in memory only. So I do not even being to know how to make that
appear in my list.
Mark Simmerman
SQL Learner
Napa, CaliforniaRight-click on the Server, select 'Edit SQL Server Registration properties
and make sure 'show system databases and system objects' is checked.
Hope this helps.
Dan Guzman
SQL Server MVP
"Mark" <xxxdbaxxx@.gmail.com> wrote in message
news:1148081170.238568.164540@.38g2000cwa.googlegroups.com...
> Thanks in advance.
> I have an instance of Enterprise Manager for SQL Server 2000 on my
> desktop that does not list the above databases. When I attempt to add
> any of them, I receive: "Error 5123: CREATE FILE encountered operating
> system error 32.". I see all the databases in the server's copy of EM.
>
> My questions are twofold. What is the likely reason my workstation
> copy of EM got this way? How do I best fix this? I suspect I may have
> to wait for no users to be on the system, but I hope someone knows a
> way to fix this without doing so. Also the TempDB does not appear as
> an mdf file, which I guess is because it is a temporary construct that
> exists in memory only. So I do not even being to know how to make that
> appear in my list.
>
> Mark Simmerman
> SQL Learner
> Napa, California
>|||Except for MSDB, those system databases MUST exist on your server, so trying
to 'add' them is pointless. They're already there which is why you're
getting the message you reported.
I presume you also have Query Analyzer, so you could run a query:
exec sp_helpdb
and you should see the system databases listed with all the others.
Right click on the name of your server (or LOCAL) in Enterprise Manager.
Choose 'Edit SQL Server Registration Properties'
Check the box near the button of the dialog box that says 'Show system
databases and system objects'
Click OK
Now when you expand your Databases node in Enterprise Manager, you should
see the system databases.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Mark" <xxxdbaxxx@.gmail.com> wrote in message
news:1148081170.238568.164540@.38g2000cwa.googlegroups.com...
> Thanks in advance.
> I have an instance of Enterprise Manager for SQL Server 2000 on my
> desktop that does not list the above databases. When I attempt to add
> any of them, I receive: "Error 5123: CREATE FILE encountered operating
> system error 32.". I see all the databases in the server's copy of EM.
>
> My questions are twofold. What is the likely reason my workstation
> copy of EM got this way? How do I best fix this? I suspect I may have
> to wait for no users to be on the system, but I hope someone knows a
> way to fix this without doing so. Also the TempDB does not appear as
> an mdf file, which I guess is because it is a temporary construct that
> exists in memory only. So I do not even being to know how to make that
> appear in my list.
>
> Mark Simmerman
> SQL Learner
> Napa, California
>|||That was sooooo simple. Thanks, Kalen and Dan.

Hi enterprise manager prob.

Hi. I got Enterprise Manager to work finally.
However, the Columns are backwards when I retrieve all rows, and when i go
to design a table.
Meaning to say that the ID starts on right side of screen, and scrollbar is
on left side (everything is backwards)
in options of enterprise manager, it says english is default language.
thanksThis sounds more like a Windows setting to me...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Michael" <Michael@.nospamplease.com> wrote in message
news:OEpXDJqCEHA.2592@.TK2MSFTNGP12.phx.gbl...
> Hi. I got Enterprise Manager to work finally.
> However, the Columns are backwards when I retrieve all rows, and when i go
> to design a table.
> Meaning to say that the ID starts on right side of screen, and scrollbar
is
> on left side (everything is backwards)
> in options of enterprise manager, it says english is default language.
> thanks
>
>|||Hi Tibor:
I had it working with enterprise manager 7.0. When I upgraded to 8.0 it's
like that. every other application on my machine is left to right -> only
that is right to left. Everything is English on my machine. Very weird.
Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ertxVMqCEHA.1588@.tk2msftngp13.phx.gbl...
> This sounds more like a Windows setting to me...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Michael" <Michael@.nospamplease.com> wrote in message
> news:OEpXDJqCEHA.2592@.TK2MSFTNGP12.phx.gbl...
go
> is
>|||Got it to work - It was Windows Settings, thanks Tibor!!!
"Michael" <Michael@.nospamplease.com> wrote in message
news:OEpXDJqCEHA.2592@.TK2MSFTNGP12.phx.gbl...
> Hi. I got Enterprise Manager to work finally.
> However, the Columns are backwards when I retrieve all rows, and when i go
> to design a table.
> Meaning to say that the ID starts on right side of screen, and scrollbar
is
> on left side (everything is backwards)
> in options of enterprise manager, it says english is default language.
> thanks
>
>

Help: Table name displaying twice in SQL Statement inside SQL Server Enterprise Manager

For some reason whenever I look at the SQL statement of a particular table, the table name displays twice.
For example,
SELECT * FROM State State
Even when I execute this statement, it still returns the correct results. It does this for all tables in this particular database. I also check another database and thoses display the table names in the SQL statements correctly.
Does anyone know why the table name would display twice in a table inside of a particular database?

How (where) are these statements being generated? All this is doing is creating an alias for the table with its own name, so this won't hurt anything. It's much like doing:
SELECT A.Field1 FROM State A
Marcie|||

datagridgirl wrote:

How (where) are these statements being generated? All this is doing is creating an alias for the table with its own name, so this won't hurt anything. It's much like doing:
SELECT A.Field1 FROM State A
Marcie

It just came up whenever I look at the SQL statement (SQL Pane) after "Returning All Rows" of a particular table. I guess it is not a big deal. I just don't know why it would do that.|||

voodoo9055 wrote:

It just came up whenever I look at the SQL statement (SQL Pane) after "Returning All Rows" of a particular table. I guess it is not a big deal. I just don't know why it would do that.

I'm curious now...in what tool? I'm not seeing this behavior in either VS.NET (via Server Explorer) or Enterprise Manager...
Marcie|||

datagridgirl wrote:

voodoo9055 wrote:

It just came up whenever I look at the SQL statement (SQL Pane) after "Returning All Rows" of a particular table. I guess it is not a big deal. I just don't know why it would do that.

I'm curious now...in what tool? I'm not seeing this behavior in either VS.NET (via Server Explorer) or Enterprise Manager...
Marcie

Enterprise Manager.
It displays that way for one of my databases. The rest display normally.