flow layout in rs2005

I have a report that needs to show postal addresses. The address is broken down into several fields. The problem I have is some of the address parts are optional. If they are empty, I'm left with nasty gaps in the address. I'd really like next label to reclaim the space of any empty labels.

a quick example

A full address would look like this..

customer name
address line 1
address line 2
town
county
post code

if address line 2 isnt given, I get:

customer name
address line 1

town
county
post code

but I want:

customer name
address line 1
town
county
post code

Can anyone help?

Many thanks,

Paul

Anyone know? Even if the answer is "sorry, can't do that". Could really do with an answer, I think I've downloaded the entire internet over the last day trying to figure it out!

Cheers|||

Hey Paul,

Can you try this:

=Fields!Customer_Name.Value
& IIf(Len(Fields!Address_Line_1.Value) > 0, chr(10) & Fields!Address_Line_1.Value, "")
& IIf(Len(Fields!Address_Line_2.Value) > 0, chr(10) & Fields!Address_Line_2.Value, "")
& IIf(Len(Fields!Town.Value) > 0, chr(10) & Fields!Town.Value, "")
& IIf(Len(Fields!County.Value) > 0, chr(10) & Fields!County.Value, "")
& IIf(Len(Fields!Postal_Code.Value) > 0, chr(10) & Fields!Postal_Code.Value, "")

This assumes that the Customer_Name field is required, but none of the others are. If the other fields have any length, it will add the line feed, otherwise it will not. It will put the whole thing in one textbox, I'm not sure if that was a requirement.

Hope this helps.

Jarret

|||

Ahh, ok. That works!!! Completely a different answer to how I expected, I thought it would be some layout thing somewhere.

Anyway - exactly the result I was after. Thanks for taking the time to help.

Paul

FixedHeader Columns struggle with layout in IE

Hi,

I use a table wtih drilldown (first tree columns) where i want to freez the first tree columns. The fixedheader itself is working, but it seems to struggle with the layout and functioallity.

The issues are:

Tableheader is less high in fixed columns (contains some merged cells and two rows) the merged cells in the drilldown (mergend one, two or three cells) destroy the fixed layout - freezes more then the first tree columns column widths change while scrolling right (not scrolled, scrolled difference)

This I guess are all HTML issues, but I guess MS is able to handle a currect display at least in their own product MSIE.

Are there fixes on the way ? Or a recomendation which properties to set to get a correct layout ?

Hannes

Screenshots of the two versions:

Correct: http://www.hmayer.net/tiki-browse_image.php?imageId=3431

Wrong: http://www.hmayer.net/tiki-browse_image.php?imageId=3430

Fixed Header issue in SSRS 2005

I am tryign to keep the headers fixed, on a 2005 report.

Hence In the Layout section for table settings properties,I Set the FixedHeader setting to True to keep the headers visible as you scroll down .

However, when I scroll down the report, the headers stay fixed, BUT IT OVERLAPS With the rows of data.

Any idea why this would happen?

To keep it from looking like it is overlapping you can change the background color from transparent to white (or whatever color you choose).

Simone

|||Yes, thats what I did and then it does not appear like it overlaps. However, is there any reason why this happens. AND how can we prevent this from happening, besides changing the Background color?|||I believe it is by design. The background color defaults to transparent. When the header is set to fixed, it doesn't move but the rest of the page does. The transparency results in the "overlap".