more than one dataset for a tablix control

[viji]

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

Thanks,

Viji

[Ragavan G]

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

[viji]

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

[Ragavan G]

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