Array or list in data set

Question

User639371382 posted

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

Answer 1

User-1969043554 posted

you should use sub-report to fix this issue

Answer 2

User639371382 posted

Thanks for the answer but could you elaborate a little more?

How could sub-reports help me?

Answer 3

User-1969043554 posted

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,