Hide connection string in Report Designer

[robinpearce]

Hiya,

Is there any way to hide the Connection String inside the Report Designer ?

This is required because we have wrapped the designer up in our own application and we automatically make the connection to the database for the operator, but we really do not want the customer to see the logon details.

Any ideas would be gratefully received.

Many thanks
Robin

[Edward]

Hi Robin,

Yes, there is a way how to hide a Database connection with a certain name from Dictionary.

Use the special Restrictions class. For example:

report.Dictionary.Restrictions.Add("Demo", StiDataType.Database, StiRestrictionTypes.DenyShow);

Here is the definition of the StiRestrictionTypes enumeration:
public enum StiRestrictionTypes
{
None = 0,
DenyEdit = 1,
DenyDelete = 2,
DenyMove = 4,
DenyShow = 8
}

Thank you.

[robinpearce]

Thank you very much Edward.

That is exactly what I needed

Thanks
Robin

[Edward]

Hi Robin,

You are welcome

Please let us know if you need any help.

Thank you.