Friday, June 28, 2013

Customer name and address too spaced apart

Hi Ipanter,


It seems that you create multiple datasets in your report, in this case, you should specify scope for the field. The textbox can only display the first record in the dataset, if you want to dispaly the first record, you can chang the expression like:

=First(Fields!Customer_Name.Value,"DataSet") & First(Fields!Address_1.Value,"DataSet") & First(Fields!City.Value,"DataSet") & First(Fields!State.Value,"DataSet") & First(Fields!Zip.Value,"DataSet")


If you want to dispaly all the records, you can use a tablix to dispaly it.


If you have any questions, please feel free to ask.


Regards,




Charlie Liao

TechNet Community Support



No comments:

Post a Comment