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

How to generate a report on report server using two or more data sets?

Thread ID:

Created:

Updated:

Platform:

Replies:

140704 Nov 1,2018 10:41 PM UTC Nov 5,2018 11:28 AM UTC Report Platform 3
loading
Tags: Report Designer
Amanpreet
Asked On November 1, 2018 10:41 PM UTC

Hi Team,

Is it possible to generate a single report using two or more data sets? If yes , can you please point me with some references on how to do this.
I am aware of the documentation of using queries/joins on the data base to generate reports but I am intending to use datasets and generate reports from two or more datasets.

Looking forward to see your response.

Thanks,
Amanpreet

Mageshyadav M [Syncfusion]
Replied On November 2, 2018 12:29 PM UTC

Hi Amanpreet, 
 
Thanks for contacting Syncfusion support. 
 
Yes, we can create multiple dataset for single report by using both Desktop ReportDesigner and Web ReportDesigner. Please refer the below steps to create and use multiple datasets in both Desktop and  
Web ReportDesigner. 
 
1.Desktop Report Designer: 
 
  1. Create Multiple Dataset
We can create the multiple dataset by choosing the Add Dataset shown in below snap. 
 
 
 
  1. Choose datasets for creating reportitems.
We can choose the datasets for assigning data to created chart reportitem as shown in below snap. 
 
 
 
2.Web Report Designer: 
 
  1. Create Multiple Dataset
We can create the multiple dataset by choosing the Add Dataset shown in below snap. 
 
 
 
  1. Choose datasets for creating reportitems.
We can choose the datasets for assigning data to created chart reportitem as shown in below snap. 
 
 
 
If you need to modify the dataset for chart report item then we can choose the dataset name by clicking the dataset dropdown as highlighted above. 
 
Please refer the below links for Steps to create a dataset in Desktop and Web ReportDesigner. 
 
Regards, 
Mageshyadav.M 


Amanpreet
Replied On November 2, 2018 01:19 PM UTC

Hi Mageshyadav ,

I am aware of the fact that we can create multiple data sets and I am able to do that. But my query was regarding how to generate a report using data from multiple data sets. For example - If I have Employee data set with data as Name, Address, Phone Number, Email etc. and I have another Employer data set with data as Employer Name, Employee Name, Employer Address, Employer Email etc. And my requirement is to generate a report which contains data from both the data sets like Employee-Employer report with data as Name and Email from Employee data set and Employer Name and Employer Email from Employer data set.

Let me know in case you need any more inputs.
Looking forward to see your response.

Regards,
Amanpreet

Mageshyadav M [Syncfusion]
Replied On November 5, 2018 11:28 AM UTC

Hi Amanpreet, 
  
Thanks for clarifying your requirement. 
  
We have already logged a feature task regarding your requirement "Support to combine data from multiple datasources/datasets". We have plans to include this feature in any of our upcoming releases. 
  
Regards, 
Mageshyadav.M 


CONFIRMATION

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

;