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

Firefox vs IE, make RS always open in IE?

I use Firefox as my default browser on my development machine for
RS2005 with SS2005.
I solved the authentication problem by setting IE to Tools, Security,
Intranet to User Authentication, Logon, all the way down at the bottom
of the list to Automatic logon with current user name and password.
BUT I still get the rendering errors...reports don't look right, etc.,
I have not seen any fixes in this list.
Is it possible for me to make the Reports and ReportServer sites on my
dev box to always open in IE and not in Firefox'
Thank you, TomI also use Firefox, I use the IE View extension to always view in IE.
Unfortunatelly for me our web app will also support Firefox and the reports
go along with that. Microsoft RS does not support Firefox and I haven't
seen any thing that states that they plan to. I think there are two main
issues, the Chart height and table column widths. We don't have the chart
height issue because we use Dundas and they don't appear to have the same
problem...which is kind of interesting since they also write the native
chart in RS. They are forced into using the custom control set of
interfaces which means they have image quality issues due to the limitations
in RS, but for this matter they are better. The other problem we have been
able to fix with the empty wide textbox scattered above tables. This idea
comes from the notes from Jon Galloway in the link below.
Thanks,
Steve MunLeeuw
Here are my notes:
Hi Max,
Thank you for using MSDN Managed Newsgroup Support.
I understand that your report does not show the right format in Firefox
browser.
Unfortunately, Microsoft does not support any browsers other than Internet
Explorer. All the Render Extension in Reporting Services are developed
against IE. So there is no way to guarantee that Reporting Services will
perform well with other browsers.
Please understand that we don't have an environment to reproduce and
troubleshoot your issue, but please feel free to involve me during the
process of contacting third-party support, I am glad to provide any
information.
Sincerely,
Wei Lu
Microsoft Online Community Support
/* Fix report IFRAME height for Firefox */
.DocMapAndReportFrame
{
min-height: 860px;
}
--removed .css fix from dev
machinehttp://weblogs.asp.net/jgalloway/archive/2006/09/01/SQL-Reporting-Services-_2D00_-CSS-fix-for-Firefox.aspx
"tlyczko" <tlyczko@.gmail.com> wrote in message
news:1161702061.967677.79830@.e3g2000cwe.googlegroups.com...
>I use Firefox as my default browser on my development machine for
> RS2005 with SS2005.
> I solved the authentication problem by setting IE to Tools, Security,
> Intranet to User Authentication, Logon, all the way down at the bottom
> of the list to Automatic logon with current user name and password.
> BUT I still get the rendering errors...reports don't look right, etc.,
> I have not seen any fixes in this list.
> Is it possible for me to make the Reports and ReportServer sites on my
> dev box to always open in IE and not in Firefox'
> Thank you, Tom
>