Easy question - changing Visibility of textbox

I'm trying to affect the visibility of a text box based upon a field value
returned in my dataset. The field is a summed field, and I simply do NOT
want to show the field if it is 0, less than zero, or NULL.
What should my expression for the "Visbility" property look like?
TIA,
--
Brian Grant
Senior Programmer
SI International
www.si-intl.comiif(Parameters!Fieldname.Value <= 0 OR Parameters!Fieldname.Value IS Nothing, True, False)
"G" wrote:
> I'm trying to affect the visibility of a text box based upon a field value
> returned in my dataset. The field is a summed field, and I simply do NOT
> want to show the field if it is 0, less than zero, or NULL.
> What should my expression for the "Visbility" property look like?
> TIA,
> --
> Brian Grant
> Senior Programmer
> SI International
> www.si-intl.com
>
>|||IS Nothing
that is what was tripping me up, thanks comet.
--
Brian Grant
Senior Programmer
SI International
www.si-intl.com
"comet61" <comet61@.discussions.microsoft.com> wrote in message
news:CFF1A78C-9DE1-475E-9BB9-5D4D6F4EAE04@.microsoft.com...
> iif(Parameters!Fieldname.Value <= 0 OR Parameters!Fieldname.Value IS
Nothing, True, False)
> "G" wrote:
> > I'm trying to affect the visibility of a text box based upon a field
value
> > returned in my dataset. The field is a summed field, and I simply do NOT
> > want to show the field if it is 0, less than zero, or NULL.
> >
> > What should my expression for the "Visbility" property look like?
> >
> > TIA,
> >
> > --
> > Brian Grant
> > Senior Programmer
> > SI International
> > www.si-intl.com
> >
> >
> >

Dynamic Visibility Problem

I think, first I better explain the characteristic of the report:
? It?s a report of categories and their items(or products)
? the report has a lot of information
? At first only appears the list of all categories(which fulfill all the requirements)
+ Category Nº1
+ Category Nº2
When I clicked, I?ll appear:
Category Nº1
P1
P2
Category Nº2
P2
P4
The problem is, that at first appears 18 pages instead of 1 page, and I don?t know why, I really hope that you can?t help me.
From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comSo all your drill down are expanded by default ?
"Rita Fonseca" <ritafonsecasa@.hotmail.com> wrote in message
news:f46b26c3-6b9f-4992-a716-b9cb7e34bc5d@.developmentnow.com...
>I think, first I better explain the characteristic of the report:
> . It's a report of categories and their items(or products)
> . the report has a lot of information
> . At first only appears the list of all categories(which fulfill all the
> requirements)
> + Category Nº1
> + Category Nº2
> When I clicked, I'll appear:
> Category Nº1
> P1
> P2
> Category Nº2
> P2
> P4
>
> The problem is, that at first appears 18 pages instead of 1 page, and I
> don't know why, I really hope that you can't help me.
>
> From
> http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com|||Your "hidden" should be true then it will hide all the values and on toggle
it comes up.
Amarnath, MCTS
"Rita Fonseca" wrote:
> I think, first I better explain the characteristic of the report:
> â?¢ Itâ's a report of categories and their items(or products)
> â?¢ the report has a lot of information
> â?¢ At first only appears the list of all categories(which fulfill all the requirements)
> + Category Nº1
> + Category Nº2
> When I clicked, Iâ'll appear:
> Category Nº1
> P1
> P2
> Category Nº2
> P2
> P4
>
> The problem is, that at first appears 18 pages instead of 1 page, and I donâ't know why, I really hope that you canâ't help me.
>
> From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com
>|||I have found a kind of answer,
A put -> =FALSE , In the table visibility field
but now the problem is q goes has to leave everything in a single page
I try to used a function --Ceiling-- but doesn?t work, It doesn?t create a break page
From http://www.developmentnow.com/g/115_2007_3_0_0_949975/Dynamic-Visibility-Problem.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com|||Re: Dynamic Visibility Problem Julien Bonnier
So all your drill down are expanded by default ?
Rpta:
No, not really only is the user wante
From http://www.developmentnow.com/groups/viewthread.aspx?newsgroupid=115&threadid=94997
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Dynamic subreport based on user group

How would you set visibility in a report based on which user group the user
is in?You can easily see the User, but not the groups the user is in ,unless you do
some sort of call outside RS.
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Doris" wrote:
> How would you set visibility in a report based on which user group the user
> is in?