Posted 4 October 2020, 3:35 am ESTI want to make the End-User Designer access a .Net dataset for a Winforms application with multiple tables available for reporting. Ideally, I'd like to display all of the tables and fields on the Report Explorer and allow the end-user to create their own queries on the datasource. Is this possible?
As an alternative, I can give access to the backend SQL server, but the user won't know the credentials and I don't want them to be able to execute queries that would alter the data or save the credentials in the report definition. I think this is a security risk. Help.