Page 1 of 1

Customize "Select Data" window

Posted: Tue Feb 21, 2012 1:18 pm
by marco.correa
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

Posted: Wed Feb 22, 2012 7:15 am
by HighAley
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:

Code: Select all

report.Dictionary.Restrictions.Add("DataSourceName", StiDataType.DataSource, StiRestrictionTypes.DenyEdit);
StiConfig.HideProperty("SqlCommand");
Thank you.