Page 1 of 1
Hiding Datasources from the top level
Posted: Tue Mar 15, 2011 3:38 am
by kmt54_99
Hi,
I have several data sources on a report with relations to each other, like below:
Datasource 1 (relation to Datasource 2)
Datasource 2
Datasource 3 (relation to Datasource 1, then Datasource 2)
Datasource 4 (relation to Datasource 1, then Datasource 2)
I want to hide DataSource 2 from the top level veiw, so that it only appears as a relation when datasource 1 is expanded.
Is this possible at all?
Thanks in advance
Hiding Datasources from the top level
Posted: Wed Mar 16, 2011 2:00 am
by Alex K.
Hello,
Please send us a your report with sample data for analysis.
Thank you.
Hiding Datasources from the top level
Posted: Wed Mar 16, 2011 4:14 am
by kmt54_99
Hi,
I've attached a sample report for you to look at.
Regards,
Darren
Hiding Datasources from the top level
Posted: Wed Mar 16, 2011 4:21 am
by kmt54_99
Hi,
The data is populated from a SQL database, so when I save and load the report the data will not be there for you (although the datasources are).
Is there a way of saving the data with the report file at all, so I can pass on everything to you?
Thanks,
Darren
Hiding Datasources from the top level
Posted: Wed Mar 16, 2011 2:51 pm
by Alex K.
Hello,
You can save data in the xml file with using following code:
Code: Select all
using (SqlConnection connection = new SqlConnection())
{
SqlDataAdapter da = new SqlDataAdapter("Select * from Table", connection);
DataSet ds = new DataSet("Data");
da.Fill(ds);
ds.WriteXml("path");
}
Thank you.
Hiding Datasources from the top level
Posted: Thu Mar 17, 2011 3:40 am
by kmt54_99
Hi,
I've just released I never asked for the solution to be in the code behind not through the designer.
I've attached a sample report, just in case that helps.
Thanks
Hiding Datasources from the top level
Posted: Thu Mar 17, 2011 2:18 pm
by Andrew
Hello,
I am very sorry for misunderstanding. Unfortunately, it is not possible to hide Data Source hiding Relation, which is linked to this data source.
Thank you.
Hiding Datasources from the top level
Posted: Fri Mar 18, 2011 2:35 am
by kmt54_99
Okay no worries my mistake for not stating it in the original post.
Thanks for your help.
Hiding Datasources from the top level
Posted: Fri Mar 18, 2011 4:17 am
by Alex K.
Hello,
Let us know if you need any additional help.
Thank you.