Starting in 2019, the Reporting control is no longer included in Essential Studio®. If you're experiencing issues with the Syncfusion� Reporting Platform, Report Viewer, Report Designer, or Report Writer, we recommend migrating to Bold Reports, our dedicated reporting platform.

Bold Reports offers a comprehensive suite of tools and features for all your reporting needs, and we will help you make a smooth transition from the discontinued control. Our support team at https://support.boldreports.com/ is here to assist you with any questions or difficulties you may encounter during the migration process.

We thank you for choosing Syncfusion� and appreciate your understanding.

more than one dataset for a tablix control

How to map more than one dataset for a tablix control?

Thanks,
Viji


3 Replies

RG Ragavan G Syncfusion Team May 28, 2013 11:58 AM UTC

Hi Viji,

 

Thanks for your interest in syncfusion products .

 

RDL reports not allowed to use more than one dataset in tablix control . You can use join queries to map more than one table to use single dataset .

 

Please let me know if you have any queries .

 

Thanks ,

Ragavan G



VI viji May 29, 2013 06:30 AM UTC

Hi Raghavan,

Thank you so much for your quick response. 

In RDL file, we can bind a dataset to a tablix control commonly like below
<DataSetName>DataSet1</DataSetName>

and we can access DataSet2 also for some cells in that tablix control in RDL file as 
<Value>=First(Fields!count.Value, "DataSet2")</Value>

But in Syncfusion ReportViewer, Accessing Dataset2 as 
<Value>=First(Fields!count.Value, "DataSet2")</Value> is giving error. 

We couldn't retrieve the results for the tablix control in a single dataset as the query involves more tables and we need to retrieve the calculated aggregate results also for some of the tablix rows.

Please tell me how to use "<Value>=First(Fields!count.Value, "DataSet2")</Value>" in Syncfusion ReportViewer. 


Thanks,
Viji



RG Ragavan G Syncfusion Team May 29, 2013 11:29 AM UTC

Hi Viji ,

 

Thanks for your patience .

 

We have fixed this issue . Please follow this incident (108878) for further updates .

 

Please let me know if you have any queries .

 

Thanks ,

Ragavan G


Loader.
Up arrow icon