I have a dataset in a report that is returning a field which contains a comma-separated list of values. I want to display the first value in textbox1, the second value oin textbox2 and so on.
In textbox1 I use the expression
In textbox2 I use the expression
However, when the data in the field CSVList only contains one value, then Textbox2 displays #ERROR when the report is run.
How can I avoid displaying this error when there is no corresponding value in the Split array?Thanks in advance.
asked Feb 22 '12 at 01:01 PM in Default
@xnl28 Unfortunately, you are not doing it the right way. This seems to be the typical requirement of the matrix. Send the dynamic data from the SQL Server and handle it in SSRS with a Matrix.
Following are the links to help you out for the matrix implementationhttp://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/dynamic-column-names-and-fields-in-ssrs-
answered Feb 22 '12 at 03:27 PM