I have a database connection string in the backend that I want to force the user to use and not be able to change with any of the available buttons. Should not be able to switch to Excel or Entity for example. After that I have some columns in different tables I want to restrict them from having access to display on the report.
End user reporting - Use hardcoded connstring for Database connection that user cannot change
Answers approved by DevExpress Support
Hello Tobias,
You can use the XtraReport.FilterComponentProperties event to hide DataSource and DataMember properties. See: Hide Properties from the Report Designer.
Also, refer to this help topic for details on how to prevent data sources from being added and edited: EndUserReportDesigner: Disable adding of DataSources.
Regards,
Denis