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
  1. Home
  2. Forum
  3. WPF
  4. Report from dataset inside project.
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.

Report from dataset inside project.

Hi,
I have a project with DataSet. How can I reference this projects DataSet in the Designer. DataSet is based on MS Access database.
Project:

Best regards,

5 Replies
VS Vinoth Srinivasan Syncfusion Team July 26, 2017 01:12 PM UTC

Hi Dubravko, 
 
Thanks for your interest in Syncfusion Components. 
 
You can convert the DataSet as list of objects and use those list of objects as datasource in our WPF report designer. The RDLC DesignMode in ReportDesigner allows you to use business objects as datasource in reports. We have prepared a sample based on this and it can be downloaded from the following location. 
 
 
Please refer our online UG documentation for more details on this. 
 
 
Regards, 
Vinoth S. 


DF df July 26, 2017 02:17 PM UTC

Hi,

thanks for the sample. I managed to get it work. 

One more question, how to avoid datasource pop up window to choose datasource, dataset and method, in other words how to set this

from code behind so that report is just shown.

Thanks


VS Vinoth Srinivasan Syncfusion Team July 27, 2017 08:36 AM UTC

Hi Dubravko, 
 
The pop up is used to get details of the Dataset object at first execution of the report in Report Designer. If the saved report definition has dataset info, then the selected items are shown in the pop up, by default. Report Designer supports to dynamically change method, class, and the namespace of the business object, so the pop up shows up with all default selection items. Once the report has been saved with dataset info then the dataset info code will be generated in the report definition. Please refer to the below screenshot for the saved dataset information.  
 
 
 
 
However, you can edit the report definition of the report in code behind and you can insert the above highlighted code. Please refer the following KB for editing the report in code behind. 
 
Regards, 
Vinoth S. 


DF df July 28, 2017 02:08 PM UTC

Thanks for the info, it works now. 

Best regards


VS Vinoth Srinivasan Syncfusion Team July 31, 2017 04:36 AM UTC

Hi Dubravko, 

Thanks for your update. Please let us know if you require any further assistance on this. 

Regards, 
Vinoth S. 


Loader.
Up arrow icon