Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

LineHeight issue Expand / Collapse
Author
Message
Posted Friday, January 10, 2014 4:29 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, September 8, 2014 3:52 AM
Points: 1,183, Visits: 336
Hi,

I've got a report that has a table, with 2 different levels of indent, populated by a dataset that contains 2 fields Description and DescriptionLevel. The Level field is used to determine what level of indent to use. Level 1 would give me a bullet with the text then in column 2, Level 2 would give me a smaller bullet in column 2 with the text in column 3. The table has 3 columns as below

My top row (Level 1) has column 2 and 3 merged.

-----------------------------------------
- > -- Level 1 Description -
- -- > -- Level 2 Description -
- > -- Level 1 Description -
- > -- > -- Level 2 Description -
-----------------------------------------

My data is returned like this :-

Description DescriptionLevel
Level 1 Description 1
Level 2 Description 2
Level 1 Description 1
Level 2 Description 2

I set the LineHeight value on the row to be either
=iif(Fields!DescriptionLevel.Value= 1, "0.6cm", "0cm")
or
=iif(Fields!DescriptionLevel.Value= 2, "0.6cm", "0cm")

depending on the line, and I display the correct data at the right level of indent - The problem is even though I have set the lineHeight to 0cm where the data is at the other level, I still get a blank line in its place, with the effect that everything looks doubles spaced

Any ideas?

Regards
Andy
Post #1529712
Posted Friday, January 10, 2014 5:01 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, September 8, 2014 3:52 AM
Points: 1,183, Visits: 336
Not sure what I was thinking here - I just set the Row Visibility - much easier
Post #1529724
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse