Hiding Datasources from the top level

[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

[Alex K.]

Hello,

Please send us a your report with sample data for analysis.

Thank you.

[kmt54_99]

Hi,

I've attached a sample report for you to look at.

Regards,

Darren

[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

[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.

[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

[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.

[kmt54_99]

Okay no worries my mistake for not stating it in the original post.

Thanks for your help.

[Alex K.]

Hello,

Let us know if you need any additional help.

Thank you.