Creating reports and dashboards | Stimulsoft community forum

Hi,

I added a datasource through the code. But I don't want users to see it because of the username and password in it.

The code:

report.Dictionary.Databases.Add(new StiSqlDatabase("DataWarehouse", ConfigurationManager.ConnectionStrings["DataWarehouse"].ToString()));
report.Dictionary.Restrictions.Add("DataWarehouse", StiDataType.DataSource, StiRestrictionTypes.DenyShow);


The Datasource still remains visible after doing this. Even when I try DenyEdit, and then try to edit the Datasource connection string, i'm still able to edit.
I'm wondering if the String name of Restrictions.Add() is correct.

Please advise

Thank you

Hello,

You should replace StiDataType.DataSource by StiDataType.Database because you want hide database reference (not data source).

Thank you.

Hello,

I did like you said. However, what I am trying to accomplish is that the users cannot see or edit the connection string.
At this time, seeing and editing is possible when the datasource is visible.

Thank you

Hello Brix,

You have used web designer? In this case you need use static property - Stimulsoft.Report.Web.StiWebDesignerOptions.ModifyConnections.

Thank you.

Hello Jan,

This worked beautifully.

Thanks!!

Hello,

This is very nice - our advice works for you!

Thank you.