Hi,
How can I customize the tables being displayed on the "Select Data" window through "Add New DataSource" button.
We need to show only some tables for users to select.
Furthermore we do not want users to edit the sql command or create new queries. How we can do that?
Tks
Customize "Select Data" window
-
marco.correa
- Posts: 26
- Joined: Wed Nov 16, 2011 12:33 pm
- Location: Blumenau, Santa Catarina, Brazil
Customize "Select Data" window
Hello.
[quote="marco".correa]How can I customize the tables being displayed on the "Select Data" window through "Add New DataSource" button.
We need to show only some tables for users to select.
Furthermore we do not want users to edit the sql command or create new queries. How we can do that?[/quote]
Unfortunately, it's impossible to filter tables in the 'Select Data' window but you could do it in our SQL server.
To restrict ability to edit the Data Source and add new one, please, use next code:
Thank you.
[quote="marco".correa]How can I customize the tables being displayed on the "Select Data" window through "Add New DataSource" button.
We need to show only some tables for users to select.
Furthermore we do not want users to edit the sql command or create new queries. How we can do that?[/quote]
Unfortunately, it's impossible to filter tables in the 'Select Data' window but you could do it in our SQL server.
To restrict ability to edit the Data Source and add new one, please, use next code:
Code: Select all
report.Dictionary.Restrictions.Add("DataSourceName", StiDataType.DataSource, StiRestrictionTypes.DenyEdit);
StiConfig.HideProperty("SqlCommand");