Adding Fields to a Text Box Question

ausmoran · October 26th, 2005, 11:24 AM

I have a text box with several paragraphs into which I would like to insert several fields. Is there a way to accomplish this? I can't seem to figure it out for some reason. It seems to me that it should be a fairly easy process in SQL Reporting Services. Any help would be very much appreciated!

Thanks in advance!
- Austin

chriskhan2000 · December 1st, 2005, 06:15 PM

Yes you can but remember that a textbox does not repeat like a detail table.

Here's how you do it. Right click your textbox and choose expression.

Code:

="Good morning, " & First(Fields!Name.Value, "Dataset_Name") & "."
& "  Here is " & First(Fields!Money.Value, "Dataset_name") & " for you."

Output will be in the textbox "Good morning, George. Here is $5.00 for you." Let me know if you have any questions.

Regards,

Chris