How Send a Dataset With 2 DataTable to Stimulsoft Report

c# dataset stimulsoft
Mehdi Radi picture Mehdi Radi · Aug 29, 2012 · Viewed 11.2k times · Source

I create a C# program and connected to stimulsoft for Make Reports.

I send a Dataset with 2 Datatable to my report with below code:

DataSet ds = new DataSet();
dtP.TableName = "dtP";
dtF.TableName = "dtF";
ds.Tables.Add(dtP);
ds.Tables.Add(dtF);
Report.RegData(ds);
Report.Show();

and "Report" is stireport object.

when my report page shown. my report is empty.

And when sent just 1 datatable as Dataset to my report that's work well.

Solve:

with add below code to my c# program can solve my problem:

objStiReport.Dictionary.Clear();
objStiReport.RegData(ds);
objStiReport.Dictionary.Synchronize();

Answer

Amin Saqi picture Amin Saqi · Jun 27, 2013

I also had this problem. I tried many ways but no one solve the problem. I changed something in the dictionary in stimulsoft report designer.

1) choose the Data from Dataset, DataTable data adaptor type

2) Set a name for Name In Source property (for example DS)

3) Add some tables to DS and set the Name In Source of them to something like this DS.Table1. Note that it's important to set the Name In Source property of tables like this.

As I set the Name In Source property of tables like DS.TableName, the problem gone away for me.

Related questions

Select method in List<t> Collection

I have an asp.net application, and now I am using datasets for data manipulation. I recently started to convert this dataset to a List collection. But, in some places it doesn't work. One is that in my old version …

Read More
How I can filter a Datatable?

I use a DataTable with Information about Users and I want search a user or a list of users in this DataTable. I try it butit don't work :( Here is my c# code: public DataTable GetEntriesBySearch(string username,string location,…

Read More
Reading DataSet

How do I read data from a DataSet in WPF? I have a train schedule table with just 2 columns and I want to be able to read the departure times and calculate when the next train is leaving. For example, …

Read More