ssrs rdl text box expression concatenation string and field

reporting-services concatenation rdl
mbcharney picture mbcharney · Oct 18, 2017 · Viewed 25.1k times · Source

I have several ssrs rdl reports where I am trying to concatenate text then a data set field then text again and it is displayed as a bar code.

Here is the expression:

="*" & Fields!barcodenum.Value & "*"

Example data for 200145 would look like:

enter image description here

The report was built with BI in VS 2015. The data set returns the correct data as verified by the query designer.

When I run the report from the 'preview' in VS it displays the correct information for the bar code field.

When the report is published to the SSRS server, 2008R2, it only displays the two stars and no field data.

enter image description here

The field is formatted as a varchar(8).

Am I concatenating the field correctly? Is there a different way to concatenate this?

Any help would be very greatly excepted.

Answer

NewGuy picture NewGuy · Oct 18, 2017

Try ="*" & CSTR(Fields!barcodenum.Value) & "*" Your barcodenum field is probably an INT and needs to be converted to a string for this to work.

Related questions

SSRS Expression: The value expression for textbox has scope parameter that is invalid for aggregate

i'm recieving the following error: Error 1 [rsInvalidAggregateScope] The Value expression for the text box ‘Textbox2’ has a scope parameter that is not valid for an aggregate function. The scope parameter must be set to a string constant that is equal …

Read More
The permissions granted to user ' are insufficient for performing this operation. (rsAccessDenied)"}

I created a report model using SSRS (2005) and published to the local server. But when I tried to run the report for the model I published using report builder I get the following error. Report execution error:The permissions granted …

Read More
How do I format date and time on ssrs report?

on SSRS report I need to show todays date and current time i tried this =FormatDateTime(Now,"MM/dd/yyyy hh:mm tt") but this is not working for me giving an error. Anyone please help me for expression ? I …

Read More