I’m using a report viewer (RDLC file) in a web page. In the dataset, one of the properties is a string array (names AdditionalDetails). In the tablix, I can’t find the correct expression to access the strings in the array. For example, in order to access
the first string in the array I tried the following:
=Fields!AdditionalDetails.Value(0)
But it displays as “#Error” in the report.
How can I access the string in the array? How can I access the strings in Fields!AdditionalDetails.Value?
I also tried with a List(Of String) instead of a string array but the problem stays the same.
ccaron
0 Points
5 Posts
Array or list in data set
Apr 04, 2012 06:29 PM|LINK
Hello,
I’m using a report viewer (RDLC file) in a web page. In the dataset, one of the properties is a string array (names AdditionalDetails). In the tablix, I can’t find the correct expression to access the strings in the array. For example, in order to access the first string in the array I tried the following:
=Fields!AdditionalDetails.Value(0)
But it displays as “#Error” in the report.
How can I access the string in the array? How can I access the strings in Fields!AdditionalDetails.Value?
I also tried with a List(Of String) instead of a string array but the problem stays the same.
By the way, The Lookup function is not available.
Thanks,
Charles-Antoine
Hmeilhem
Member
92 Points
22 Posts
Re: Array or list in data set
Apr 09, 2012 09:11 AM|LINK
you should use sub-report to fix this issue
ccaron
0 Points
5 Posts
Re: Array or list in data set
Apr 09, 2012 02:21 PM|LINK
Thanks for the answer but could you elaborate a little more?
How could sub-reports help me?
Hmeilhem
Member
92 Points
22 Posts
Re: Array or list in data set
Apr 09, 2012 02:32 PM|LINK
You can pass AdditionalDetailID for one object to the subreport.
look at this example: http://www.codeproject.com/Articles/195017/SSRS-Series-Part-II-Working-with-Subreports-DrillD
Regards,