1. Home
  2. Forum
  3. WPF
  4. reportDefinition. DataSet AND BindingSource.DataSource
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.

reportDefinition. DataSet AND BindingSource.DataSource

Hi
how can I create a report using a dynamically created column


for example jet based on sqlce but ultimately I need DB2 IBM


I need to implement the scenarios contained in
1. ReportDefinition button2
2. reportViewerControl button3


please help





Attachment: test_ReportDesigner002_fa2398a0.rar

21 Replies
MM Mageshyadav M Syncfusion Team August 15, 2018 09:47 AM UTC

Hi Gregory, 
 
Thanks for contacting Syncfusion support. 
 
how can I create a report using a dynamically created column  
You can dynamically modify the number of rows and columns by editing the report definition of a report at code behind. We have prepared a sample in which the table is created dynamically based on the number of columns selected by the user and it can be downloaded from the below link.

http://www.syncfusion.com/downloads/support/forum/123629/DYNAMI~1630305586.ZIP 
 
for example jet based on sqlce but ultimately I need DB2 IBM 

I need to implement the scenarios contained in
1. ReportDefinition button2
2. reportViewerControl button3 

please help 
The shared rar file was corrupted and we are getting the error while extracting the rar file as shown in below shared screenshot. The error might be occurred due to corrupted the zip file while compressing the files. So please re-zip the files and share it again to validate the reported issue. 
 
 
 
 
 
Regards, 
Mageshyadav.M 


GP Gregory Pe replied to Mageshyadav M August 15, 2018 03:25 PM UTC

Hi Gregory, 
 
Thanks for contacting Syncfusion support. 
 
how can I create a report using a dynamically created column  
You can dynamically modify the number of rows and columns by editing the report definition of a report at code behind. We have prepared a sample in which the table is created dynamically based on the number of columns selected by the user and it can be downloaded from the below link.

http://www.syncfusion.com/downloads/support/forum/123629/DYNAMI~1630305586.ZIP 
 
for example jet based on sqlce but ultimately I need DB2 IBM 

I need to implement the scenarios contained in
1. ReportDefinition button2
2. reportViewerControl button3 

please help 
The shared rar file was corrupted and we are getting the error while extracting the rar file as shown in below shared screenshot. The error might be occurred due to corrupted the zip file while compressing the files. So please re-zip the files and share it again to validate the reported issue. 
 
 
 
 
 
Regards, 
Mageshyadav.M 


Hi Mageshyadav
I am sending again


Regards, 
Gregory

Attachment: test_ReportDesigner002_a122f353.rar

MM Mageshyadav M Syncfusion Team August 21, 2018 02:23 AM UTC

Hi Gregory, 
  
Sorry for the long delay in getting back to you. 
  
While verifying the snapshot shared in your sample application, we can see method 'SerializeReport' is not called but in your sample application you have already implemented the method 'SerializeReport' which contains all the code to edit dataset and add column. 
  
When we debug your application, we cannot get the new column name in this.dataSource list as shared in snapshot. Please find the snapshot we have taken while debugging your application. 
  
  
  
  
Hence we added the new column name has default while calling EditDataset method for testing but we can visualize the new column added in Dataset section of ReportDesigner. 
  
Snapshot of New column added as default: 
  
 
  
Snapshot of new column loaded in ReportDesigner: 
  
  
  
The reported issue doesn't reproduces in your sample application and we didn't get the new column name in binding datasource itself hence tested by adding in EditDataset method by default which loads properly in ReportDesigner. Hence can you please confirm whether the issue still reproduces on your side or resolved since we can find difference like SerializeReport called in sample application but missing in snapshot. 
  
If the issue still reproduces, can you please share some additional details of your requirement to assist you with proper solution. 
  
Regards, 
Mageshyadav.M 


GP Gregory Pe replied to Mageshyadav M August 25, 2018 08:04 PM UTC

Hi Gregory, 
  
Sorry for the long delay in getting back to you. 
  
While verifying the snapshot shared in your sample application, we can see method 'SerializeReport' is not called but in your sample application you have already implemented the method 'SerializeReport' which contains all the code to edit dataset and add column. 
  
When we debug your application, we cannot get the new column name in this.dataSource list as shared in snapshot. Please find the snapshot we have taken while debugging your application. 
  
  
  
  
Hence we added the new column name has default while calling EditDataset method for testing but we can visualize the new column added in Dataset section of ReportDesigner. 
  
Snapshot of New column added as default: 
  
 
  
Snapshot of new column loaded in ReportDesigner: 
  
  
  
The reported issue doesn't reproduces in your sample application and we didn't get the new column name in binding datasource itself hence tested by adding in EditDataset method by default which loads properly in ReportDesigner. Hence can you please confirm whether the issue still reproduces on your side or resolved since we can find difference like SerializeReport called in sample application but missing in snapshot. 
  
If the issue still reproduces, can you please share some additional details of your requirement to assist you with proper solution. 
  
Regards, 
Mageshyadav.M 


Hi Mageshyadav
I modified the example

1.
but I can not read in
ReportDefinition - button2
View an Run (ShowReportViewer)
error
in Syncfusion.RDL.Data.ReportModel.UpdateDataSource ()
in Syncfusion.RDL.Data.ReportModel.Evaluate ()

2.
in reportViewerControl - button3
but I can not read the created report
An error occurred while processing the report. item 'TextBox10' Provide Dataset inputs for Report

please help

Regards, 
Gregory

Attachment: test_ReportDesigner002_fdcf1075.rar

MM Mageshyadav M Syncfusion Team August 28, 2018 11:28 AM UTC

Hi Gregory, 
 
We have validated your sample and determined the actual cause for your reported errors. 
 
Actually, you are using only DataSet0 in your shared report “Report.rdlc” but you have defined 10 additional datasets which is not referred with any of the report items. Please find the snapshot of your datasets created in your RDLC report, 
 
 
 
Next issue is binding datasource passed to ReportViewer Datasources is null in shared  report. Please find the snapshot showcasing it. 
 
 
 
For your information, we don’t support System.Windows.Forms.BindingSource to be inputted as value to ReportDataSource. We support only DataTable, DataSet and Business object collection as value for ReportDataSource.  
 
Hence we suggest below changes to run your report without any error, 
 
  1. First pass the proper DataSource for binding source to avoid null issue as provided in below snippet
 
        private void button3_Click(object sender, System.EventArgs e) 
        { 
            try 
            { 
                this.SQLCE_BindingSource.DataSource = dstest007ce; 
                Form101 ChildForm = new Form101(this, this.SQLCE_BindingSource, "Report");// "Modified.rdlc"); 
                ChildForm.MdiParent = this.MdiParent; 
                ChildForm.Show(); 
            } 
 
            catch (Exception ex) 
            { 
                MessageBox.Show("Error : " + ex.Message); ;// throw; 
            } 
        } 
 
Next, pass the data table has values instead of binding source as provided in below snippet. 
 
        private void Form101_Load(object sender, EventArgs e) 
        { 
            ElementHost host = new ElementHost(); 
            host.Dock = DockStyle.Fill; 
            reportViewerControl.ProcessingMode = ProcessingMode.Local; 
            //zmiana na nazwa raportu dnamiczna       reportViewerControl.ReportPath = @"../../Report0.rdlc"; 
       //     reportViewerControl.ReportPath = @"../../" + name_RDLC + ".rdlc"; 
            reportViewerControl.ReportPath = @"REPORT_RDLC/" + name_RDLC + ".rdlc"; 
 
            reportViewerControl.DataSources.Add(new Syncfusion.Windows.Reports.ReportDataSource { Name = "DataSet0", Value = (form0.SQLCE_BindingSource.DataSource as DataSet).Tables["Order_Details"] }); 
 
            //reportViewerControl.DataSources.Add(new Syncfusion.Windows.Reports.ReportDataSource { Name = "DataSet1", Value = form0.SQLCE_BindingSource }); 
            //reportViewerControl.DataSources.Add(new Syncfusion.Windows.Reports.ReportDataSource { Name = "DataSet2", Value = form0.SQLCE_BindingSource }); 
            //reportViewerControl.DataSources.Add(new Syncfusion.Windows.Reports.ReportDataSource { Name = "DataSet3", Value = form0.SQLCE_BindingSource }); 
 
 
  1. Next ensure, you are adding ReportDataSource to reportViewerControl.DataSources for all the DataSet created in the report or remove the unused datasets in the report. In your provided sample, you defined datasources for DataSet1, DataSet2, DataSet3 but not for other Datasets created in the RDLC report and also you missed to pass datasource value for DataSet0 which is the DataSet referred for Table hence error has been thrown.
 
Please find the modified report with unused DataSets removed which will run fine with above suggested changes, 
 
 
Regards, 
Mageshyadav.M 


GP Gregory Pe replied to Mageshyadav M August 28, 2018 06:37 PM UTC

Hi Gregory, 
 
We have validated your sample and determined the actual cause for your reported errors. 
 
Actually, you are using only DataSet0 in your shared report “Report.rdlc” but you have defined 10 additional datasets which is not referred with any of the report items. Please find the snapshot of your datasets created in your RDLC report, 
 
 
 
Next issue is binding datasource passed to ReportViewer Datasources is null in shared  report. Please find the snapshot showcasing it. 
 
 
 
For your information, we don’t support System.Windows.Forms.BindingSource to be inputted as value to ReportDataSource. We support only DataTable, DataSet and Business object collection as value for ReportDataSource.  
 
Hence we suggest below changes to run your report without any error, 
 
  1. First pass the proper DataSource for binding source to avoid null issue as provided in below snippet
 
        private void button3_Click(object sender, System.EventArgs e) 
        { 
            try 
            { 
                this.SQLCE_BindingSource.DataSource = dstest007ce; 
                Form101 ChildForm = new Form101(this, this.SQLCE_BindingSource, "Report");// "Modified.rdlc"); 
                ChildForm.MdiParent = this.MdiParent; 
                ChildForm.Show(); 
            } 
 
            catch (Exception ex) 
            { 
                MessageBox.Show("Error : " + ex.Message); ;// throw; 
            } 
        } 
 
Next, pass the data table has values instead of binding source as provided in below snippet. 
 
        private void Form101_Load(object sender, EventArgs e) 
        { 
            ElementHost host = new ElementHost(); 
            host.Dock = DockStyle.Fill; 
            reportViewerControl.ProcessingMode = ProcessingMode.Local; 
            //zmiana na nazwa raportu dnamiczna       reportViewerControl.ReportPath = @"../../Report0.rdlc"; 
       //     reportViewerControl.ReportPath = @"../../" + name_RDLC + ".rdlc"; 
            reportViewerControl.ReportPath = @"REPORT_RDLC/" + name_RDLC + ".rdlc"; 
 
            reportViewerControl.DataSources.Add(new Syncfusion.Windows.Reports.ReportDataSource { Name = "DataSet0", Value = (form0.SQLCE_BindingSource.DataSource as DataSet).Tables["Order_Details"] }); 
 
            //reportViewerControl.DataSources.Add(new Syncfusion.Windows.Reports.ReportDataSource { Name = "DataSet1", Value = form0.SQLCE_BindingSource }); 
            //reportViewerControl.DataSources.Add(new Syncfusion.Windows.Reports.ReportDataSource { Name = "DataSet2", Value = form0.SQLCE_BindingSource }); 
            //reportViewerControl.DataSources.Add(new Syncfusion.Windows.Reports.ReportDataSource { Name = "DataSet3", Value = form0.SQLCE_BindingSource }); 
 
 
  1. Next ensure, you are adding ReportDataSource to reportViewerControl.DataSources for all the DataSet created in the report or remove the unused datasets in the report. In your provided sample, you defined datasources for DataSet1, DataSet2, DataSet3 but not for other Datasets created in the RDLC report and also you missed to pass datasource value for DataSet0 which is the DataSet referred for Table hence error has been thrown.
 
Please find the modified report with unused DataSets removed which will run fine with above suggested changes, 
 
 
Regards, 
Mageshyadav.M 


Hi Mageshyadav

thank you - it is working now

Regards, 
Grzegory

VS Vinoth Srinivasan Syncfusion Team August 29, 2018 04:42 AM UTC

Hi Gregory, 

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

Regards, 
Vinoth S. 


GP Gregory Pe December 9, 2018 02:02 PM UTC

Hi
after upgrading to v4.0.30319 and 16.3450.0.29
an error occurs.

press:
ReportDefinition  button2


please help



Attachment: test_ReportDesigner002_fae85619.rar

GP Gregory Pe February 27, 2019 05:13 PM UTC


Hi

I repeat the unresolved problem

after upgrading to v4.0.30319 and 16.3450.0.29
an error occurs.

press:
ReportDefinition  button2


please help


Attachment: test_ReportDesigner002_fa2398a0_e97efeae.rar

MM Mageshyadav M Syncfusion Team February 28, 2019 02:55 PM UTC

Hi Gregory, 
 
Sorry for the delay in getting back to you. 
 
We are able to reproduce the mentioned issue with your shared sample at our end. We will get back to you with timeline details on March 1st, 2019. 
 
Regards, 
Mageshyadav.M 


MM Mageshyadav M Syncfusion Team March 1, 2019 02:11 PM UTC

Hi Gregory, 
 
We were able to reproduce the mentioned issue in our Report Designer and we have confirmed that the issue is a defect and logged a defect report on this. You can keep track of this bug from the feedback portal below.  
  
  
The fix for this issue will be estimated to be available on 06th March 2019. 
  
If you have any more specification/precise replication procedure or a scenario to be tested you can add it as a comment in the portal. 
 
Regards, 
Mageshyadav.M 


MM Mageshyadav M Syncfusion Team March 8, 2019 09:46 AM UTC

Hi Gregory, 
  
We have fixed the reported object reference exception issue and generated the custom patch in version 16.3.0.29. Please find the patch from below location,  
  
Recommended approach - exe will perform automatic configuration  
Please find the patch setup from below location: 
 
Advanced approach – use only if you have specific needs and can directly replace existing assemblies and NuGet packages for your build environment  
Please find the patch assemblies alone from below location: 
 
Please find the patch NuGet alone from below location: 
 
To automatically run the Assembly Manager, please check the Run assembly manager checkbox option while installing the patch. If this option is unchecked, the patch will replace the assemblies in precompiled assemblies’ folder only. Then, you will have to manually copy and paste them to the preferred location or you will have to run the Syncfusion Assembly Manager application (available from the Syncfusion Dashboard, installed as a shortcut in the Application menu) to re-install assemblies.  
  
Note: 
You can change how you receive bug fixes by navigating to the following link and updating your preferences.  
 
Disclaimer: 
Please note that we have created this patch for version 16.3.0.29 specifically to resolve the following issue reported in this the forum. 139270 
If you have received other patches for the same version for other products, please apply all patches in the order received.  
  
Regards, 
Mageshyadav.M 


GP Gregory Pe November 13, 2019 08:53 PM UTC

Hi

how to prevent the page from opening after clicking on HELP
https://help.syncfusion.com/wpf/reportdesigner/add-dataset

my "PowerCollections.chm" help should open


private void helpSearchMenuItemToolStripMenuItem_Click (object sender, EventArgs e)
         {
             Help.ShowHelp (this, "Document Explorer Utility Help File.chm", HelpNavigator.Find, "Introduction");
         }

just like in files
ReportDesigner_help.png
Add DataSource.pnh
add_paramets.png

Regards, 
Gregory


Attachment: temp_a9ea9548.rar

VS Vinoth Srinivasan Syncfusion Team November 14, 2019 01:39 PM UTC

Hi Gregory, 
 
We have created a support incident under your account. Please log on to our support website to check for further updates. 

Regards, 
Vinoth S. 


GP Gregory Pe April 3, 2020 07:23 PM UTC

Hi
BarCode.rdl
QrCode.rdl
1.
I need to implement the scenarios contained in
1. ReportDefinition button2
2. reportViewerControl button3


I need to add columns to the report
BarCode22 and QrCode22
so that BarCode and QrCode can be displayed
I put
Image Name = "Barcode"
Source Database
MIMEType image / bmp
= Code.Convert (Fields! ProductID.Value)


but it doesn't work

2.after opening ReportDefinition button2
click open docunient and indicate files
BarCode.rdl and QrCode.rdl
also does not work.
Loads but the preview generates an error


please help







Attachment: test_ReportDesigner003_e8e62961.rar

VS Vinoth Srinivasan Syncfusion Team April 6, 2020 01:07 PM UTC

Hi Gregory, 

We are validating the shared sample at our end and update you the details by 7th April 2020. 

Regards, 
Vinoth S. 


VS Vinoth Srinivasan Syncfusion Team April 8, 2020 03:15 PM UTC

Hi Gregory, 

Sorry for the delay. 

We are facing when trying to run the sample with 16.3.0.29 version assemblies from nuget and will update you with more details by 9th April without further delay. 

Regards, 
Vinoth S. 


VS Vinoth Srinivasan Syncfusion Team April 9, 2020 06:16 PM UTC

Hi Gregory, 

We have tried to run the sample with 16.3.0.29 with from nuget packages, but we are facing some issues while restoring Syncfusion windows assembly. So, it is possible to share the Syncfusion assemblies you have used to run the sample. 

Regards, 
Vinoth S. 


GP Gregory Pe replied to Vinoth Srinivasan April 28, 2020 05:19 PM UTC

Hi Gregory, 

We have tried to run the sample with 16.3.0.29 with from nuget packages, but we are facing some issues while restoring Syncfusion windows assembly. So, it is possible to share the Syncfusion assemblies you have used to run the sample. 

Regards, 
Vinoth S. 


Hi Vinoth S.
was the problem solved?

Regards, 
Gregory

VS Vinoth Srinivasan Syncfusion Team April 29, 2020 05:31 PM UTC

Hi Gregory, 

Sorry for the delay. 

We are still facing some issue while running the sample and will update you the solution by 30th April 2020 without further delay. 

Regards, 
Vinoth S. 


VS Vinoth Srinivasan Syncfusion Team April 30, 2020 08:30 AM UTC

Hi Gregory, 

Thanks for your patience. 

I need to add columns to the report
BarCode22 and QrCode22
so that BarCode and QrCode can be displayed
I put
Image Name = "Barcode"
Source Database
MIMEType image / bmp
= Code.Convert (Fields! ProductID.Value) 
We have further validated the shared sample and the RDLC you are serializing don’t have custom code and assembly reference details. So, I have included the custom code and assembly reference details to render the report properly. Please find the below snaps for your reference. 

 



 

 


2.after opening ReportDefinition button2
click open docunient and indicate files
BarCode.rdl and QrCode.rdl
also does not work.
Loads but the preview generates an error 
We have validated the BarCode and QRCode rdl files with ReportDesigner. From our validation the issue occurs due to older version pdf.base and linq.base assemblies. So, we have used the 16.3.0.29 pdf and linq base assemblies to resolve the reported issue. Also, you are having dataset details in “QRCode.rdl” which cannot be processed in RDLC design mode ReportDesigner. So, we have modified the report and you can use “QRCodeModified .rdl” to render the report. Please find the below images for your reference. 

BarCode.rdl : 

 

QRCodeModified.rdl 

 



 


Please find the modified sample from below link. 


Regards, 
Vinoth S. 


Loader.
Up arrow icon