Hiding Rows....

I have the following in a cell...
=iif(Fields!TRANSDATE.Value >= Parameters!Report_Parameter_Mon.Value,
Fields!TRANSDATE.Value,Nothing)
What I want it to do is if the TRANSDATE is greater than or equal to the
Parameter display the TRANSDATE... otherwise don't display it... The above
code works to a point... but it leaves huge spaces as if it is displaying
the Nothing Rows... e.g.
Parameter = 01/06/04
02/06/04
05/06/04
How do I remove that massive blank area?Place your expression on the "rows visibility" instead of the fields'
contents.
=iif(Fields!TRANSDATE.Value >= Parameters!Report_Parameter_Mon.Value,"True"
, "False")
Click on the left table margin button, examine the properties of that row
and place your expression under the rows visibility property
HTH,
Greg|||Thanks that worked great. Now to figure out a way to get the subtotal of
the group to understand what needs to be totalled.
"Greg Rowland" <greg@.waveltd.com> wrote in message
news:euBy4oKdEHA.3916@.TK2MSFTNGP11.phx.gbl...
> Place your expression on the "rows visibility" instead of the fields'
> contents.
> =iif(Fields!TRANSDATE.Value >=Parameters!Report_Parameter_Mon.Value,"True"
> , "False")
> Click on the left table margin button, examine the properties of that row
> and place your expression under the rows visibility property
> HTH,
> Greg
>|||Click on the left table margin button, of the row in question.
Right click, then click insert row below.
Examine the properties of the newly created row.
Select "Data, grouping/sorting" click the (Ellipsis) button at the right.
Under name enter the group name.
In Group on, Expression, enter the field or fields you wish to discriminate
by.
Example;
Group name
Employees
Expression
=Fields!EmployeeNumber_.Value|||Finally
Add Field Expressions to the newly created rows cells.
Example:
=Sum(Fields!GrossPay.Value)
or
=Iif(Sum(Fields! GrossPay.Value, "Employees")<>0, Sum(Fields!
GrossPay.Value, "Employees"), "")
Other variations;
Font
Font expression =Iif(Sum(Fields!GrossPay.Value, "Employees")<>0, "Bold",
"Normal")
TextDecoration
=Iif(Fields! Sum(Fields!GrossPay.Value, "Employees")<>0, "Underline",
"Normal")|||Fantastic. thanks.
"Greg Rowland" <greg@.waveltd.com> wrote in message
news:uQSQ9RZdEHA.3380@.TK2MSFTNGP12.phx.gbl...
> Finally
> Add Field Expressions to the newly created rows cells.
> Example:
> =Sum(Fields!GrossPay.Value)
> or
> =Iif(Sum(Fields! GrossPay.Value, "Employees")<>0, Sum(Fields!
> GrossPay.Value, "Employees"), "")
> Other variations;
> Font
> Font expression =Iif(Sum(Fields!GrossPay.Value, "Employees")<>0, "Bold",
> "Normal")
> TextDecoration
> =Iif(Fields! Sum(Fields!GrossPay.Value, "Employees")<>0, "Underline",
> "Normal")
>
>
>