Increase or Decrease Texbox to accomadate text

How would I go about seting my text box so that it will increase or decrease
in size to fit my text. Here's what expression I got in my textbox:
= First(Fields!NAME.Value, "FIN") & vbcrlf &
First(Fields!ADDR_1.Value, "FIN") & vbcrlf &
First(Fields!ADDR_2.Value, "FIN") & vbcrlf &
First(Fields!ADDR_3.Value, "FIN") & vbcrlf &
First(Fields!CITY.Value, "FIN") & "," & First(Fields!STATE.Value, "FIN") & "
" & First(Fields!ZIPCODE.Value, "FIN") & vbcrlf &
First(Fields!COUNTRY.Value, "FIN")
The thing is that some contacts will not have address 2 and 3. This will
leave the result like this:
ABC Company
123 South Drive
AppleTown, MN 65343
This is the result that I want if there are no address 2 and 3:
ABC Company
123 South Drive
AppleTown, MN 65343Hi,
There is no property to achieve this
Instead you can use an if condition and display the value only if it exists.
Hope this helps.
Ponnurangam.
"chang" <chang@.discussions.microsoft.com> wrote in message
news:7E565BDD-B1C2-48B2-8A6A-81BEE00BA16D@.microsoft.com...
> How would I go about seting my text box so that it will increase or
> decrease
> in size to fit my text. Here's what expression I got in my textbox:
> = First(Fields!NAME.Value, "FIN") & vbcrlf &
> First(Fields!ADDR_1.Value, "FIN") & vbcrlf &
> First(Fields!ADDR_2.Value, "FIN") & vbcrlf &
> First(Fields!ADDR_3.Value, "FIN") & vbcrlf &
> First(Fields!CITY.Value, "FIN") & "," & First(Fields!STATE.Value, "FIN") &
> "
> " & First(Fields!ZIPCODE.Value, "FIN") & vbcrlf &
> First(Fields!COUNTRY.Value, "FIN")
> The thing is that some contacts will not have address 2 and 3. This will
> leave the result like this:
> ABC Company
> 123 South Drive
>
> AppleTown, MN 65343
> This is the result that I want if there are no address 2 and 3:
> ABC Company
> 123 South Drive
> AppleTown, MN 65343|||Remember, the Height property can also be an expression.
Maybe you can come up with some smart logic.sql

Incorrect Positioning?

Hi,

I have created a couple of reports with a header that contains an embedded image and a textbox just to the right of the image, vertically aligned. So far so good but when i deploy the report it doesn't show exactly as in the preview...
Instead the textbox seems to goto another column? Yes it seems that some how a new column is created and the textbox is the only thing to be in it...

Anyone experiencing this? What can be causing this?

Best Regards,

Luis Simoes

It sounds like the image and the textbox overlap. This is only supported in image-based rendering (e.g. Preview, PDF). We currently don't support overlapping items in HTML (when viewed e.g. through report viewer in report manager). This is why one of the overlapping items will get pushed to the right/bottom in the generated output.

-- Robert

|||

No, they are not overlapped. They are side by side!

What can it be? That's really weird behavior.. only the text box on the right side of the embedded image get's to a new blank column...

This is the layout of the report:

Image here	Textbox here
Rest of the report

|||I have the same problem. The funniest thing is it depends of the image if textbox is moved or not. When I show the bigger image (property set to fit) textbox is ok side by side but when the image is smaller then the textbox is moved to the next page. Any sollution in this case?|||Got it! I inserted both image and textbox to the header-section and now it works. Strange...sql

Incorrect Positioning?

Hi,

I have created a couple of reports with a header that contains an embedded image and a textbox just to the right of the image, vertically aligned. So far so good but when i deploy the report it doesn't show exactly as in the preview...
Instead the textbox seems to goto another column? Yes it seems that some how a new column is created and the textbox is the only thing to be in it...

Anyone experiencing this? What can be causing this?

Best Regards,

Luis Simoes

It sounds like the image and the textbox overlap. This is only supported in image-based rendering (e.g. Preview, PDF). We currently don't support overlapping items in HTML (when viewed e.g. through report viewer in report manager). This is why one of the overlapping items will get pushed to the right/bottom in the generated output.

-- Robert

|||

No, they are not overlapped. They are side by side!

What can it be? That's really weird behavior.. only the text box on the right side of the embedded image get's to a new blank column...

This is the layout of the report:

Image here	Textbox here
Rest of the report

|||I have the same problem. The funniest thing is it depends of the image if textbox is moved or not. When I show the bigger image (property set to fit) textbox is ok side by side but when the image is smaller then the textbox is moved to the next page. Any sollution in this case?|||Got it! I inserted both image and textbox to the header-section and now it works. Strange...

Include User's Parameters in Report Header?

Hi, I'm getting stuck on what is probably a very simple/common task: Adding a textbox that displays the parameters that a user has selected for the current report.

For example, if the user chooses a @.startdate and @.enddate using date-pickers, a textbox in the header will display/print those parameters:

="Report by Department from " + @.startdate+ " to " + @.enddate

Seems simple, but I keep getting errors:

"Return statement in a Function, Get or Operator must return a value".

Can anyone help out with the proper syntax for repeating a user's parameters in the header or body of a report?

Thanks!

try

="Report by Department from " & Parameters!startdate.value " to " & Parameters!enddate.value

you can also right click at your textbox in the header and choose Expression to edit expression..

in there , choose Parameters in the left pane and double click the needed parameters in the right pane...

the expression will show at the top pane...

HTH

|||Ah, of course - Thankl you!|||What about something more general like looping through the parameters and writing them out by name and value? Any ideas?|||

do you mean multivalue parameters ?

if it is, u can try =Join(Parameters!status.label, ",")

.label for name; .value for value