Displaying single-instance business object data on SSRS
- by Lachlan
I have a SQL Server Reporting Services local (i.e. RDLC) report displayed in a ReportViewer, with two subreports. I am using business objects to populate the datasets. What is the best way to populate single-instance data on my report, e.g. a dynamic title, or a text box that lists a calculated value, not based on the report data?
I am currently displaying data using the following style:
public class MyRecordList
{
string Name { get; set; }
List<MyRecord> Records { get; set;}
}
public MyRecord
{
string Description { get; set;}
string Value { get; set;}
}
I set the datasource to the Records in an instance of MyRecordsList, and they print out find in a table. But adding a textbox and and referring to Name displays nothing. I also tried turning Name into a List, and referring to the first in the list, using:
=First(Fields!Name.Value, "Report1_MyRecordList")
but still nothing is printed on the report.
