<div>
What does your binary field contain? &nbsp;If it's a string, you'll need to convert it to string before it can be displayed in an SSRS textbox. &nbsp;I did a little test with the EmployeePhoto field (from DimEmployee in the AdventureWorksDW2012 sample db). &nbsp;This field is a varbinary(max) and if I just drag it into a table I get this error:<br />
<br />
<i>[rsInvalidExpressionDataTy<wbr />pe] The Value expression used in textrun ‘EmployeePhoto.Paragraphs[<wbr />0].TextRun<wbr />s[0]’ returned a data type that is not valid.</i><br />
<br />
BTW: whenever you get #ERROR in your report, take a closer look at the Output window for details.<br />
<br />
In case your binary content is an image, you need to put the Image control on the report. &nbsp;See this article for details: <a href="https://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/A_9233-Put-Some-Images-On-Those-SSRS-Reports.html" rel="ugc">Put Some Images On Those SSRS Reports</a>
</div>


What does your binary field contain?  If it's a string, you'll need to convert it to string before it can be displayed in an SSRS textbox.  I did a little test with the EmployeePhoto field (from DimEmployee in the AdventureWorksDW2012 sample db).  This field is a varbinary(max) and if I just drag it into a table I get this error:

[rsInvalidExpressionDataType] The Value expression used in textrun ‘EmployeePhoto.Paragraphs[0].TextRuns[0]’ returned a data type that is not valid.

BTW: whenever you get #ERROR in your report, take a closer look at the Output window for details.

In case your binary content is an image, you need to put the Image control on the report.  See this article for details: Put Some Images On Those SSRS Reports [https://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/A_9233-Put-Some-Images-On-Those-SSRS-Reports.html]

<div>
<div class="content wysiwyg-content">
2 fields in my dataset both configured as binary data type. &nbsp;When I pull them into my SSRS report table and then run the report both of the columns where I have used the 2 fields show ERROR#. &nbsp;When I replace them with other non binary data type the ERROR# stops.<br />
<br />
Is there some format I need to configure for the binary data type for them to work in an SSRS table.
</div>
</div>


2 fields in my dataset both configured as binary data type.  When I pull them into my SSRS report table and then run the report both of the columns where I have used the 2 fields show ERROR#.  When I replace them with other non binary data type the ERROR# stops.

Is there some format I need to configure for the binary data type for them to work in an SSRS table.

Why won't my table report recognize my field?

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.