|
Hello all, 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 =Split(Fields!CSVList.Value, ",")(0) In textbox2 I use the expression =Split(Fields!CSVList.Value, ",")(1) 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.
(comments are locked)
|
|
@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 implementation http://sonalimendis.blogspot.com/2011/07/dynamic-column-rdls.html http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/dynamic-column-names-and-fields-in-ssrs-
(comments are locked)
|

