Putting Multiple Field data in a report table cell

Hot Topic

Getting replication to work on Windows 2003 Server X64 environment using SQL 2000
Ad hoc updates to system catalogs are not allowed.
[rsAggregateReportItemInBody] The Value expression for the textbox 'textbox6' uses an aggregate function on a report item.
If-structure
Getting Field List to display in Reporting Services 2005
found the key
Notification Services - Chronicle does not get updated
One dataflow for sevral Oracle Instances ?
setup.exe /qb REMOVE=ALL instancename=test
Can't find SSIS ???

SQL Server

Adding vertical space between rows
send email
Stored Proc
upgrading from 2000 to 2005.
Copy Database with Microsoft.SqlServer.Management.Smo.Transfer breaks identity columns
Disable a container at runtime via ScriptTask
How to display Japanese Kanji using DBCS
Convert Integer To Time Only In SELECT
Is the MSSQL2000 report server only support for .NET framework 1.1?
Slow performance calculated members

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


Answer this question

Putting Multiple Field data in a report table cell

  • Wayne Z

    =Fields!Phone.Value & " " & Fields!Fax.Value should work.

  • ManMuffin

    =Fields!Phone.Value & ISNULL(Fields!Fax.Value,"",",") & Fields!Fax.Value should work

    Otherwise you can try using IIF.

  • mattisdada

    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. 


  • Aleksey777

    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 ", ". 


  • Putting Multiple Field data in a report table cell
Answer this question