<div>
Thank you ---- Did not work
</div>


<div>
&quot;Did not work&quot; does not give us much to go on.<br />
<br />
&nbsp;What did it do? &nbsp;Did you get the wrong value? &nbsp;Was it the correct value, but formatted incorrectly? &nbsp;Did you get an error?<br />
<br />
&nbsp;James
</div>


"Did not work" does not give us much to go on.

 What did it do?  Did you get the wrong value?  Was it the correct value, but formatted incorrectly?  Did you get an error?

 James

<div>
Well @James0628 as an expert you probally know at a glace that It is not formatted correctly.... brackets are not used in that manner in SSRS and the field format for SSRS is<br />
&nbsp;Fields!QTYORLENGTH.Value..<wbr />.. Figured it out myself... Thank you :)
</div>


Well @James0628 as an expert you probally know at a glace that It is not formatted correctly.... brackets are not used in that manner in SSRS and the field format for SSRS is
 Fields!QTYORLENGTH.Value.... Figured it out myself... Thank you :)

<div>
What was the answer?<br />
<br />
mlmcc
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts!<br />
<br />
What would this statement be in SSRS?<br />
<br />

<pre><code id="code-10-27848500-1">totext(sum({VW_RPT_SERVICEDISCOUNT.QTYORLENGTH},{VW_RPT_SERVICEDISCOUNT.UOMSHORTNAME}),2) + &quot; &quot; + {VW_RPT_SERVICEDISCOUNT.UOMSHORTNAME}</code></pre>
</div>
</div>


Hi Experts!

What would this statement be in SSRS?

(CODE)

Converting Expressions from Crystal to SSRS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

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

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.