Report with Relation not working
Posted: Fri Feb 10, 2023 10:24 am
Hi
I try to use relationships in my report
as soon as I put the relation no more data is displayed
Datasets are managed by my code
and the relationship manually
If you have an idea, you save me.
This is my code to register the data
The data is present in my report
using (SqlDataAdapter dataAdapter
= new SqlDataAdapter(sCommand, connectionS))
{
DataSet dataSet = null;
// create the DataSet
dataSet = new DataSet("DATA");
// fill the DataSet using our DataAdapter
dataAdapter.Fill(dataSet, liste_tab);
r.Dictionary.Databases.Clear();
r.CacheAllData = true;
r.RegData(dataSet);
r.Dictionary.Synchronize();
}
I try to use relationships in my report
as soon as I put the relation no more data is displayed
Datasets are managed by my code
and the relationship manually
If you have an idea, you save me.
This is my code to register the data
The data is present in my report
using (SqlDataAdapter dataAdapter
= new SqlDataAdapter(sCommand, connectionS))
{
DataSet dataSet = null;
// create the DataSet
dataSet = new DataSet("DATA");
// fill the DataSet using our DataAdapter
dataAdapter.Fill(dataSet, liste_tab);
r.Dictionary.Databases.Clear();
r.CacheAllData = true;
r.RegData(dataSet);
r.Dictionary.Synchronize();
}