Hide Dropdown parameter values based on User

I need to hide dropdown parameter values based on UserId. Any help with
User!UserId and custom code will be helpful. This is a Non-queried dropdown
and not based on query/dataset.
Thanks!To show either with drop down or without drop down, is not present in RS.
you didnt mention if it is not there, then do what ? means whether you want
emtpy or with one value or it should not show the drop down instead it should
run the report directly with some default values.
A round about way is to have a plain menu sort of report where you have two
options, I mean here is that when ever user clicks the reports, a screen will
be there with menu options like two hyperlinks (can be done using action)
before that you need to create a copy of the report, so you have now two
same reports one with drop down and the other without drop down.
Now depending on the user you can select or hide the textbox itself so the
user will be left with selecting one option.
If you dont understand I will put it in other words.
Before your two reports (one with dropdown and the other without dropdown)
one plain just hyperlink report will be there, where in user will select
the link to go to the respective reports.
Let me know if you have doubts.
Amarnath, MCTS
"RAGHAVAN JAYARAMAN" wrote:
> I need to hide dropdown parameter values based on UserId. Any help with
> User!UserId and custom code will be helpful. This is a Non-queried dropdown
> and not based on query/dataset.
> Thanks!|||On Mar 14, 3:01 am, Amarnath <Amarn...@.discussions.microsoft.com>
wrote:
> To show either with drop down or without drop down, is not present in RS.
> you didnt mention if it is not there, then do what ? means whether you want
> emtpy or with one value or it should not show the drop down instead it should
> run the report directly with some default values.
> A round about way is to have a plain menu sort of report where you have two
> options, I mean here is that when ever user clicks the reports, a screen will
> be there with menu options like two hyperlinks (can be done using action)
> before that you need to create a copy of the report, so you have now two
> same reports one with drop down and the other without drop down.
> Now depending on the user you can select or hide the textbox itself so the
> user will be left with selecting one option.
> If you dont understand I will put it in other words.
> Before your two reports (one with dropdown and the other without dropdown)
> one plain just hyperlink report will be there, where in user will select
> the link to go to the respective reports.
> Let me know if you have doubts.
> Amarnath, MCTS
> "RAGHAVAN JAYARAMAN" wrote:
> > I need to hide dropdown parameter values based on UserId. Any help with
> > User!UserId and custom code will be helpful. This is a Non-queried dropdown
> > and not based on query/dataset.
> > Thanks!
Another way of doing it is to use '=User!UserID.ToString' as the input
parameter to the dataset (stored procedure/query) and in the stored
procedure/query, give a default value when UserID matches certain
criteria. Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||I guess i didn't mention properly, In this case say for instance User 1 , i
would want to display 2 values and for user 2 i would want to display 5 value
on the dropdown.
However if use a query dataset , then i could pass UserId as per Enrique
suggestion.
Thanks!
"EMartinez" wrote:
> On Mar 14, 3:01 am, Amarnath <Amarn...@.discussions.microsoft.com>
> wrote:
> > To show either with drop down or without drop down, is not present in RS.
> > you didnt mention if it is not there, then do what ? means whether you want
> > emtpy or with one value or it should not show the drop down instead it should
> > run the report directly with some default values.
> > A round about way is to have a plain menu sort of report where you have two
> > options, I mean here is that when ever user clicks the reports, a screen will
> > be there with menu options like two hyperlinks (can be done using action)
> > before that you need to create a copy of the report, so you have now two
> > same reports one with drop down and the other without drop down.
> > Now depending on the user you can select or hide the textbox itself so the
> > user will be left with selecting one option.
> > If you dont understand I will put it in other words.
> >
> > Before your two reports (one with dropdown and the other without dropdown)
> > one plain just hyperlink report will be there, where in user will select
> > the link to go to the respective reports.
> > Let me know if you have doubts.
> >
> > Amarnath, MCTS
> >
> > "RAGHAVAN JAYARAMAN" wrote:
> > > I need to hide dropdown parameter values based on UserId. Any help with
> > > User!UserId and custom code will be helpful. This is a Non-queried dropdown
> > > and not based on query/dataset.
> >
> > > Thanks!
> Another way of doing it is to use '=User!UserID.ToString' as the input
> parameter to the dataset (stored procedure/query) and in the stored
> procedure/query, give a default value when UserID matches certain
> criteria. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>|||Ok, So in that case the query which you have for displaying the drop down,
you can pass user id and get the filtered records depending on the user. But
you need to have queried drop down only. Otherwise it is not possible on a
non queried.
Amarnath, MCTS
"RAGHAVAN JAYARAMAN" wrote:
> I guess i didn't mention properly, In this case say for instance User 1 , i
> would want to display 2 values and for user 2 i would want to display 5 value
> on the dropdown.
> However if use a query dataset , then i could pass UserId as per Enrique
> suggestion.
> Thanks!
> "EMartinez" wrote:
> > On Mar 14, 3:01 am, Amarnath <Amarn...@.discussions.microsoft.com>
> > wrote:
> > > To show either with drop down or without drop down, is not present in RS.
> > > you didnt mention if it is not there, then do what ? means whether you want
> > > emtpy or with one value or it should not show the drop down instead it should
> > > run the report directly with some default values.
> > > A round about way is to have a plain menu sort of report where you have two
> > > options, I mean here is that when ever user clicks the reports, a screen will
> > > be there with menu options like two hyperlinks (can be done using action)
> > > before that you need to create a copy of the report, so you have now two
> > > same reports one with drop down and the other without drop down.
> > > Now depending on the user you can select or hide the textbox itself so the
> > > user will be left with selecting one option.
> > > If you dont understand I will put it in other words.
> > >
> > > Before your two reports (one with dropdown and the other without dropdown)
> > > one plain just hyperlink report will be there, where in user will select
> > > the link to go to the respective reports.
> > > Let me know if you have doubts.
> > >
> > > Amarnath, MCTS
> > >
> > > "RAGHAVAN JAYARAMAN" wrote:
> > > > I need to hide dropdown parameter values based on UserId. Any help with
> > > > User!UserId and custom code will be helpful. This is a Non-queried dropdown
> > > > and not based on query/dataset.
> > >
> > > > Thanks!
> >
> > Another way of doing it is to use '=User!UserID.ToString' as the input
> > parameter to the dataset (stored procedure/query) and in the stored
> > procedure/query, give a default value when UserID matches certain
> > criteria. Hope this helps.
> >
> > Regards,
> >
> > Enrique Martinez
> > Sr. SQL Server Developer
> >
> >

Hide Data Region based on Parameters

I have a report with 3 data regions. Based upon one of the Report Parms, I
wish to hide one of the data regions. I used an expression on the
Visibility property of the table like this:
=IIf(Parameters!ReportLevel.Value = "Summary",true,false)
this works, except it still displays the page header and no print details
since the report is hidden. how do i get it to not display the page at all?Hi JrMcG,
Thank you for your posting!
I am not sure why you want to hide the Page Header. Since you only hide the
table, the Page header will not be hidden untill you use the same
expression on the Page Header visibility.
I recommend you post the RDL file here with your requirement. I would like
to help you. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Hide Columns in Matrix Report

Hi,

I have a matrxi report with 6 Columns (Col 1, 2, ...6). Based on the parameters I select I wanted to hide 3 of the columns (Col 2, 4 and 6. But the problem is when I hide the columns, it leaves a gap. That means, the matrix report shows Col 1, 3 and 5 with gap in between the Columns.

There is no Column Visibility property in matrix report.

Please help me as I am looking to solve this issue for a long time now.

Thanks,

S Suresh

I have not been able to solve this issue either. I am not sure if it's a design intent or a bug, but it is frustrating.

On one report i actually had to put multiple matrix side by side, using the same dataset, grouping, etc, and hid the entire matrix. It's messy, but it does the trick.

BobP

|||

Having 6 columns in your matrix, suggest they map on to 6 columns in your source query and you have a static group.

If your columns have no further nesting then I suggest switching to using a table as you can achieve equivalent results. When you highlight a column in a table and change it's visibility you don't get the gap.

If that is not possible then you can get around this by pivoting the data in your query so that rather than having 6 measure columns you get 2 columns with MeasureType and MeasureValue. You should then be able to group the matrix columns by MeasureType, then, based on your parameter selection, filter the 3 unwanted measures in the source query.

And that will definately work.

|||

Thanks Adam. But my 6 columns are populated with values from dimensions. Can you tell me if there is any solution to hide column in matrix?

Thanks,

S Suresh

|||

Thanks Bob. I already messed up with multiple matrix to fill the rows.

Thanks,

S Suresh

|||

No, you cannot hide a column in a matrix and have it reclaim it's space.

BobP

|||

Suresh,

What I suggested is possible as I've already done it. When you say "my columns are populated from dimensions" what do you actually mean?

On the Layout tab do you see 1 column or 6 i.e. is this a dynamic group or a static group?

It doesn't matter if they are coming from different dimesions, you can just manufacture calculated members and measures within your MDX query. This requires you to stop using the query designer and switch to custom MDX view. Then you use syntax such as:

Code Snippet

WITH

MEMBER [Measures].[MyMeasure] AS 'SOME MDX here'

MEMBER [SomeOtherDimension].[MyMember] AS 'Some MDX here'

SELECT {[Measures].[MyMeasure]} ON 0

FROM [YourCube]

WHERE (...)

Post some sample MDX with a brief explanation of the dimensions and the parameters you wish to use to control visibility of the columns and I'll show you what I mean.

Hide Columns

Hi,
I have created a report that contains a table. The table returns data w/
multiple statuses. I have created a group based on the status and have a
page break at the end of the group (so each page will display only one status
type). I would like to dynamically show / hide columns based on the status.
Is this possible? I tried setting the visibility of the individual cells,
however, this leaves a gap where the cells were (which is not desirable)â?¦
Any thoughts?
Thanks!Try setting the visibility property on the column instead of the
individual cells.
On Sep 5, 4:18 pm, David <Da...@.discussions.microsoft.com> wrote:
> Hi,
> I have created a report that contains a table. The table returns data w/
> multiple statuses. I have created a group based on the status and have a
> page break at the end of the group (so each page will display only one status
> type). I would like to dynamically show / hide columns based on the status.
> Is this possible? I tried setting the visibility of the individual cells,
> however, this leaves a gap where the cells were (which is not desirable)...
> Any thoughts?
> Thanks!|||Hi Jen,
Can this be done with a Cross-Tab Report? I dont see the Visibility Property
of the column group :( .
--
With Thanks and Regards,
Raja Krishnamurthy
"Jen" wrote:
> Try setting the visibility property on the column instead of the
> individual cells.
> On Sep 5, 4:18 pm, David <Da...@.discussions.microsoft.com> wrote:
> > Hi,
> >
> > I have created a report that contains a table. The table returns data w/
> > multiple statuses. I have created a group based on the status and have a
> > page break at the end of the group (so each page will display only one status
> > type). I would like to dynamically show / hide columns based on the status.
> > Is this possible? I tried setting the visibility of the individual cells,
> > however, this leaves a gap where the cells were (which is not desirable)...
> >
> > Any thoughts?
> >
> > Thanks!
>
>

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
>
>

Hide and Show Background image dynamically

I am trying to place a background image on a report based on a database
field called watermark. I have not found a way to create an expresion
or code that would allow me to display this background image on some
pages based on the water mark field. Is it possible to do this?I have been working hard to try to figure this out. I would really
appreciate any help. I need to be able to stamp certain pages on a
multiple paged report with a watermark that says "PAST DUE".
Thanks in advance for any help you can give me|||> I have been working hard to try to figure this out. I would really
> appreciate any help. I need to be able to stamp certain pages on a
> multiple paged report with a watermark that says "PAST DUE".
We use an expression in the background image property of the Report Body.
This is how we do it:
=IIF(your condition, "image name", Nothing)
Hope this works for you...
MK

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.
>

Hidden table details row and whitespace issue.

I have a table in a list box with more than one detail row..conditionally hidden based on some criteria..Is there any way to get rid of all the white space generated in the report viewer
From http://www.developmentnow.com/g/115_2004_12_0_29_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comOn Jul 24, 12:56 am, sash<she...@.hotmail.com> wrote:
> I have a table in a list box with more than one detail row..conditionally hidden based on some criteria..Is there any way to get rid of all the white space generated in the report viewer.
> Fromhttp://www.developmentnow.com/g/115_2004_12_0_29_0/sql-server-reporti...
> Posted via DevelopmentNow.com Groupshttp://www.developmentnow.com
There are not very many options available in this scenario. If you
haven't already selected decrease to accommodate contents in the
properties of the table control, I would suggest doing that first. The
most effective way to handle this is to manage it in the stored
procedure/query that sources the report. That way you can pass the
criteria back to the stored procedure and it can decide rather to
return a particular row in the returned dataset. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultantsql

Hidden Sub-Reports Processed?

Question: In RS 2000, do hidden sub-reports get processed? I have a
report with several sub-reports, which get hidden or shown based on a
parameter. The report seems to take a long time to render, and the
pagination is off so it appears that the other hidden sub-reports are
being processed but not shown.
Does anybody know for sure if this is true? If it is true, is there a
work-around other than breaking it up into separate reports?
Thanks in advance,
Garrett VliegerNevermind. I found my answer here:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/bb56708dfc794f55/34cafe2c92602abd?lnk=gst&q=sub-report+pagination&rnum=7#34cafe2c92602abd
garrett.vlieger@.gmail.com wrote:
> Question: In RS 2000, do hidden sub-reports get processed? I have a
> report with several sub-reports, which get hidden or shown based on a
> parameter. The report seems to take a long time to render, and the
> pagination is off so it appears that the other hidden sub-reports are
> being processed but not shown.
> Does anybody know for sure if this is true? If it is true, is there a
> work-around other than breaking it up into separate reports?
> Thanks in advance,
> Garrett Vlieger

hidden rows

Hi
Hope someone can help.
I'm trying to hide a row based on 2 criteria.
If i use one this =iif(Fields!RespTimeEq.Value > Fields!RespTime.Value,
True, False) it works but as soon as i add another criteria e.g.
=iif(Fields!RespTimeEq.Value > Fields!RespTime.Value and
Fields!VisitType.Value="GSC", True, False) it doesn't work.
Is this possible hide a row based on two criteria and if so what is the
correct syntax for it.
Thanks PaulI would thing that there is something wrong with
Fields!VisitType.Value="GSC", either this is never "GSC" (uppercase,
lowercase) or VisitType is not a string
So perhaps Fields!VisitType.Value.ToUpper()="GSC", would work (?)
"pcalv" wrote:
> Hi
> Hope someone can help.
> I'm trying to hide a row based on 2 criteria.
> If i use one this =iif(Fields!RespTimeEq.Value > Fields!RespTime.Value,
> True, False) it works but as soon as i add another criteria e.g.
> =iif(Fields!RespTimeEq.Value > Fields!RespTime.Value and
> Fields!VisitType.Value="GSC", True, False) it doesn't work.
> Is this possible hide a row based on two criteria and if so what is the
> correct syntax for it.
> Thanks Paul

Hidden Expression for Group Header

I am trying to hide a group header (table row) based on the value of that group, but have not been able to get it working.

Let's say I have 2 groups in my table:

Group 1: State

Group 2: City

I want to hide the group header (tablerow2) where State = "Unknown" but I want the Group 2 cities to still display - just w/o a header.

I tried putting the following expressions on the hidden property of tablerow2 with no luck:

First I tried referencing the field that it's grouped on:

=Iif((Fields!state.Value = "Unknown", true, false)

I also tried refereing the name of the group:

=Iif(("State_GRP" = "Unknown"), true, false)

In both cases, nothing gets hidden - all rows, including the group header that says "Unknown", are visible.

Any help would be greatly appreciated!

Kathleen

You are doing this correctly, and I was not able to reporduce the behavior--it works as you are thinking. I would make sure that the case of "Unknown" is consistent with the field value. I would do this in the expression (or change the query to do the trimming), so that case and extranious white space is not a factor.

=IIF(Fields!state.Value.Trim().ToLower()="unknown", true, false)

Ian

|||Thanks Ian - the trim/tolower seemed to resolve whatever issue I was having.