Hide Folders

Hi All,
I have a list of folders per department
i.e.
HR
Sales
etc
Each of these folders are assigned a group and have been given the default
role of browswer
However when the user logs into the reporting services site, they can see
all the folders - go into them however if they try to browse a report which
they do not have permissions to they get a Page cannot be dsiplayed error?
Surely there is a better way of doing this.
When my user goes into RS, I would either like them to see only the folder
they have been assigned to or at least not even be able to access the
folders at all that they have not been assigned to.
How do I do this.
Please help.
Thanks
KNot sure what you mean. If a user does not have access to an item on the
server, it will not display in Report Manager. Try removing all role
assignments from an item and see if they can see it.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kathy" <joe@.soap.com> wrote in message
news:poydnaDzeqHOL3rcRVn-pQ@.is.co.za...
> Hi All,
> I have a list of folders per department
> i.e.
> HR
> Sales
> etc
> Each of these folders are assigned a group and have been given the default
> role of browswer
> However when the user logs into the reporting services site, they can see
> all the folders - go into them however if they try to browse a report
> which
> they do not have permissions to they get a Page cannot be dsiplayed error?
> Surely there is a better way of doing this.
> When my user goes into RS, I would either like them to see only the folder
> they have been assigned to or at least not even be able to access the
> folders at all that they have not been assigned to.
> How do I do this.
> Please help.
> Thanks
> K
>sql

Hide default values

Is there a way to hide my default values? If so, how?

If you mark the parameter as being an internal parameter it will not show up in the user display.

Simone

|||Thanks, how do I set it to an internal parameter?|||

The above works if you don't want it changed at run time. If you want to change it at run time then you only need to set the Hidden flag.

Simone

|||

Click Report - Report Parameters - select your parameter and check off either the Hidden or Internal check boxex under the Prompt section.

Simone

|||I dont see those boxes. I am running on 7.1. Does this make a difference?|||

If you are using RS 2000, then yes it is different. These are instructions for RS 2005. Try this article to see if it helps.

http://kylefinley.net/archive/2006/02/24/42.aspx

Simone

|||Hey Simone, This seems to be if I dont want to show the field at all. I think I should explain a little more. I needed to create a filter for one of my fields. So I created a report parameter and I was told to set the default to W. Them came back to me saying that they still want the default to be W but they dont want to see the W in the text box. I want to know how do I keep W as the default but not show it. Does this make sense? If so, can it be done?|||

I think I understand and I'm not sure if it is possible. You might be able to skip the default value and change your query so that it is filtered using 'W' if the parameter is null.

ex.

Code Snippet

Where field = CASE WHEN @.param = '' THEN 'W' ELSE @.param end

Simone

|||

First of let me say thank you so much for helping me with this. They keep comming back with different things and it is a bit frsutrating because I just dont know.

Is there a way I can just say bring me back everything with W initally? Like in the default put some type of expression that says go and get anything with W and bring it back.

|||

That is what the above expression will get you and it also allows the parameter to be set if the user decides they want something other than 'W'. On the first run it returns all records with the 'W' value. The parameter has no default value so it shows as nothing.

If you always need to bring back 'W', then I would suggest just adding it to you query that pulls the data. If I am misunderstanding what you are trying to get at, please let me know. Maybe you could post a sample of your data and a sample output.

Simone

|||Thank you sooooooooooooooooooooo much! |||

Real quick is this how it should look?

WHERE Field!IUC.Value(this is my field) = CASE When @.param = ' ' THEN 'W' ELSE @.param end

Do I put this in my query string?

Hide Dcoument Map by Default while viewing the Report in SSRS

Hello Experts

I use a Report where i have a document Map getting generated. but by default it is displayed and the user has to close the window to view the report. i wanted to know if its possible to hide the Document map window by default and based on the click of the icon the window will be show to the user when viewing in the default Report page.

/chandresh soni

Did you already try the URL access parameter: rc:DocMap=false ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Hi Jens

Thanks for your suggestion. but i cannot expect my user to type rc:DocMap=false in the URL. as i deploy the report on the Report server and the user view the same through Report Manager.

since the Report has a document map, it covers 25 % of the main screen. so i wanted a way that by default it should be hidden and only on the click of the icon in the Toolbar it should be visible.

i appreciate if you can help me find the solution

/Soni

|||

I have the same problem

Soni-- Did you get the solution?

|||

Another 'poor sool' experiencing this 'feature(?)'.

Any solutions yet ?

|||

I created a report with Document Map on (from Matrix Textbox Properties | Navigation tab) and the same report without Document Map. Saved both and searched for differences in the resulting rdl files. This helped me to find the problem in my original report. Removing the Label element in the Grouping part of the Matrix element removed also the Document Map icon from my reports.This is an extract of the changed rdl file.

Before:

<Grouping Name="PersonGroup">
<Label>=Fields!Person.Value</Label>
<GroupExpressions>
<GroupExpression>=Fields!Person.Value</GroupExpression>
</GroupExpressions>
</Grouping>

After:

<Grouping Name="PersonGroup">
<GroupExpressions>
<GroupExpression>=Fields!Person.Value</GroupExpression>
</GroupExpressions>
</Grouping>

This must be some bug wit the Layout-UI not synchronizing with the rdl file, because the Document Map label was definitily NOT set in the Navigation tab of the report that opened with Document Map default on.

sql

Hide Dcoument Map by Default while viewing the Report in SSRS

Hello Experts

I use a Report where i have a document Map getting generated. but by default it is displayed and the user has to close the window to view the report. i wanted to know if its possible to hide the Document map window by default and based on the click of the icon the window will be show to the user when viewing in the default Report page.

/chandresh soni

Did you already try the URL access parameter: rc:DocMap=false ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Hi Jens

Thanks for your suggestion. but i cannot expect my user to type rc:DocMap=false in the URL. as i deploy the report on the Report server and the user view the same through Report Manager.

since the Report has a document map, it covers 25 % of the main screen. so i wanted a way that by default it should be hidden and only on the click of the icon in the Toolbar it should be visible.

i appreciate if you can help me find the solution

/Soni

|||

I have the same problem

Soni-- Did you get the solution?

|||

Another 'poor sool' experiencing this 'feature(?)'.

Any solutions yet ?

|||

I created a report with Document Map on (from Matrix Textbox Properties | Navigation tab) and the same report without Document Map. Saved both and searched for differences in the resulting rdl files. This helped me to find the problem in my original report. Removing the Label element in the Grouping part of the Matrix element removed also the Document Map icon from my reports.This is an extract of the changed rdl file.

Before:

<Grouping Name="PersonGroup">
<Label>=Fields!Person.Value</Label>
<GroupExpressions>
<GroupExpression>=Fields!Person.Value</GroupExpression>
</GroupExpressions>
</Grouping>

After:

<Grouping Name="PersonGroup">
<GroupExpressions>
<GroupExpression>=Fields!Person.Value</GroupExpression>
</GroupExpressions>
</Grouping>

This must be some bug wit the Layout-UI not synchronizing with the rdl file, because the Document Map label was definitily NOT set in the Navigation tab of the report that opened with Document Map default on.

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 parameter using userid

I have created a hidden parameter with a default value of user!userid so I can pass this to a UDF which returns a table with data dependent on the logged on windows user. This works fine until I view the report using Report Manager when any alteration to any of the other parameters requires me to click twice on the View Report button before the report is displayed. The problem does not occur if I have a hidden parameter which either has a default value obtained from a query or is a constant. Any ideas on how I can overcome this? Thanks.I have since discovered the problem is not as stated but is due to the fact that I have hidden parameters dependent on the input of an earlier parameter. If the input parameter is a drop down then all is OK but if you have to interactively enter a value then you have to click the View Report button twice. Removing the userid parameter meant that the dependent parameter was last in the list and again all was then OK; however, I still have some reports where I have more than one hidden parameter dependent on an earlier value so the problem still occurs.
"JohnH" wrote:
> I have created a hidden parameter with a default value of user!userid so I can pass this to a UDF which returns a table with data dependent on the logged on windows user. This works fine until I view the report using Report Manager when any alteration to any of the other parameters requires me to click twice on the View Report button before the report is displayed. The problem does not occur if I have a hidden parameter which either has a default value obtained from a query or is a constant. Any ideas on how I can overcome this? Thanks.

hi Im facing problem in adding values to the database sqlserver2k

hi everyone,

I have a form in in that 3columns and 8rows default.. I have to store values for 8 rows at a time in to database..

I am working with vs2003, asp.net & C# behind the code.. so pls send me a code for implementing this.. asap

vijai

what problem you are facing mention it here. There are lot of scenarious how u want to add the data. Depends on your code and architecture...

|||

Hi Vijai,

Have you created the datatable yet and what about the table's design? Since you haven't told us the details, I just suggest some reference to you.

About how to implement data access in ASP.NET : http://quickstarts.asp.net/QuickStartv20/aspnet/doc/data/default.aspx
Something about SQL Basic reference: http://www.w3schools.com/sql/sql_insert.asp
About table creating:http://www.w3schools.com/sql/sql_create.asp or just using the wizard in the tool such like Sql Server enterprise manager.

Thanks.

Hi

Can any one let me know why named pipes protocol in disabled by default in SQL 2005 on SQL server management >> protocols?

Thanks

Named pipes connections will allow remote conenctions why is disabled by default. This is one of the new directives of the new Server systems, secure by default. Many features are disabled by default but can be explicitly enabled by using a command or the appropiate GUIs shipped with SQL Server.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||There is no specific reason but the developer edition and the Express users just need to spend time with the surface area configuration tool and configuration manager because most services comes disabled by default.