Hiding Rows.... -- sql server reporting services

sql server reporting services : Hiding Rows....

Greg Rowland
7/28/2004 8:58:08 AM

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

ashvsaod
7/28/2004 5:31:12 PM

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?

Greg Rowland
7/28/2004 11:10:51 PM

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

ashvsaod
7/29/2004 9:59:12 AM

Thanks that worked great. Now to figure out a way to get the subtotal of
the group to understand what needs to be totalled.
[quoted text, click to view]

Greg Rowland
7/29/2004 12:55:09 PM

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

ashvsaod
7/30/2004 8:20:39 AM

Fantastic. thanks.
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn