trdx report with objectdatasource

[Amit]

Hi,

I am trying to show the teleik report with objectdatasource available only at runtime. 

Following is the code which I used. 

                             object jsonobj = getJsonObject();

                            SearchbyCondition oSearch = new SearchbyCondition();
                            List<SearchbyCondition> oListCond = oSearch.getSearchbyConditionReportFields(jsonobj);

                            // Creating and configuring the ObjectDataSource component:
                            Telerik.Reporting.ObjectDataSource objectDataSource = new Telerik.Reporting.ObjectDataSource();
                            objectDataSource.DataSource = oListCond;// GetData returns a DataTable

                            // Creating a new report
                            Telerik.Reporting.Report report = new Telerik.Reporting.Report();
                            
                            // Assigning the ObjectDataSource component to the DataSource property of the report.
                            report.DataSource = objectDataSource;


                            System.Xml.XmlReaderSettings settings = new System.Xml.XmlReaderSettings();
                            settings.IgnoreWhitespace = true;
                            string localPath = Request.ApplicationPath + "Report/" + ReportName;
                            localPath = Server.MapPath(localPath);
                            XmlReader xmlReader = XmlReader.Create(localPath, settings);
                            Telerik.Reporting.XmlSerialization.ReportXmlSerializer xmlSerializer = new Telerik.Reporting.XmlSerialization.ReportXmlSerializer();
                            report = (Telerik.Reporting.Report)xmlSerializer.Deserialize(xmlReader);

                            // Use the InstanceReportSource to pass the report to the viewer for displaying
                            Telerik.Reporting.InstanceReportSource reportSource = new Telerik.Reporting.InstanceReportSource();
                            reportSource.ReportDocument = report;

                            // Assigning the report to the report viewer.
                            ReportViewer1.ReportSource = reportSource;

                            // Calling the RefreshReport method in case this is a WinForms application.
                            ReportViewer1.RefreshReport();

I can see the report but without any data.

I tried using value="[Fields.BOPropertyName]" 

value="Fields.BOPropertyName" as well in trdx file

 In trdx file how can I give Objectdatasource TAG as while design it is not available.

as mentioned at http://www.telerik.com/help/reporting/connecting-to-data-working-with-data-at-design-time.html

"Data source available only at runtime" passage.

 

[Katia]

Hi Amit,

The report's DataSource property can be modified after deserializing the TRDX file's content into a Telerik.Reporting.Report object.

Please see below some sample code you can use to fix this behavior. 

using (System.Xml.XmlReader xmlReader = System.Xml.XmlReader.Create(localPath, settings))

{

    Telerik.Reporting.XmlSerialization.ReportXmlSerializer xmlSerializer =

        new Telerik.Reporting.XmlSerialization.ReportXmlSerializer();

 

    report = (Telerik.Reporting.Report)

        xmlSerializer.Deserialize(xmlReader);

 report.DataSource = GetDataObject();

}

If you prefer to work with custom business objects in the Standalone Report Designer, please see Extending Report Designer. In general, you can build an assembly with your data access layer and then load this assembly on starting the Standalone Report Designer. As a result you will be able to browser the types declared in the external assemblies on configuring an Object/Entity/OpenAccess DataSource component.


We hope you will find this information helpful.

Regards,
Katia
Telerik