Putting Multiple Field data in a report table cell

I'm using report designer and Visual Studio .net 2003. I have a table in the report and would like to put multiple field values in a single cell. Something along the lines of this in the cell: =Fields!Phone.Value, Fields!.Fax.Value.

I don't know how to seperate the values to get them to work in the same table cell. I've tried commas, semi colons, spaces, parens.

How would I do this?=Fields!Phone.Value & " " & Fields!Fax.Value should work.
|||Great that works!

One other question, if I put a symbol (comma, semicolon) in the between the ampersands, how do I get it to leave the cell blank if there is nothing stored in the fields?

For example, say I have =Fields!Phone.Value & ", " & Fields!Fax.Value in the cell but when there is no values for those fields the cell is ", ".|||=Fields!Phone.Value & ISNULL(Fields!Fax.Value,"",",") & Fields!Fax.Value should work?
Otherwise you can try using IIF.
|||I couldn't use IsNull because it says it is not decleared. I can use IIF, so the correct code is =Fields!Phone.Value & IIF(Fields!Fax.Value=nothing,"",",") & Fields!Fax.Value

Thanks for your help.

sql

Published Report Not Showing Correctly in Report Manager webpage

have a report that in the designer in Visual Studio it displays correctly on
the preview tab.
The report has 5 subreports and one of the subreports is a matrix.
On the report I have a parameter for the user to choose rather to see the
matrix subreport or not.
When I view the report in the report manager web page and the user select to
yes to view the matrix sub report, the main report is missing fields and
formatted incorrectly, if you select no on the parameter for viewing the
matrix sub report, the fields return on the main report but are still not
alligned correctly. None of the missing fields have any expressions to
control the visible property , only the matrix sub report. The matrix
subreport is several inches away from any of the fields that end up missing.
The fields that are missing are unbound textboxes used as labels.
I tried to delete the report from the report server and re-deploy but still
the same effect.
Why is the report manager different than the Visual Studio preview and
causing this bug?What version are you on? In RS 2000 the report designer had its own
renderer. In RS 2005 it uses the same rendering engine as the server does.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RBS" <RBS@.discussions.microsoft.com> wrote in message
news:831D8D9D-B3C2-485D-8B16-089A6DC76563@.microsoft.com...
> have a report that in the designer in Visual Studio it displays correctly
> on
> the preview tab.
> The report has 5 subreports and one of the subreports is a matrix.
> On the report I have a parameter for the user to choose rather to see the
> matrix subreport or not.
>
> When I view the report in the report manager web page and the user select
> to
> yes to view the matrix sub report, the main report is missing fields and
> formatted incorrectly, if you select no on the parameter for viewing the
> matrix sub report, the fields return on the main report but are still not
> alligned correctly. None of the missing fields have any expressions to
> control the visible property , only the matrix sub report. The matrix
> subreport is several inches away from any of the fields that end up
> missing.
> The fields that are missing are unbound textboxes used as labels.
>
> I tried to delete the report from the report server and re-deploy but
> still
> the same effect.
>
> Why is the report manager different than the Visual Studio preview and
> causing this bug?
>