Menu
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:
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.
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.
869
Using IIF Function in SSRS We are going to add a new field to the report data set to determine if the Order Year is the Max or Current Year. As shown below, the dataset properties window is opened, and the Fields tab is selected. After clicking Add, at the bottom of the list a new field is added.
In Design view, click the text box on the design surface to which you want to add an expression. For a simple expression, type the display text for the expression in the text box. For example, for the dataset field Sales, type [Sales] . For a complex expression, right-click the text box, and select Expression.
Try ="*" & CSTR(Fields!barcodenum.Value) & "*" Your barcodenum field is probably an INT and needs to be converted to a string for this to work.
124
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
