We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

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.
Live Chat Icon For mobile
Up arrow icon