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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

more than one dataset for a tablix control

Thread ID:





109025 May 27,2013 10:31 AM UTC May 29,2013 11:29 AM UTC ASP.NET MVC (Classic) 3
Tags: ReportViewer
Asked On May 27, 2013 10:31 AM UTC

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


Ragavan G [Syncfusion]
Replied On 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

Replied On 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

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. 


Ragavan G [Syncfusion]
Replied On 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


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon