Hello,
I have created a report within visual studio and it creates a connection string in the app.config file in the main module, however i would like the report to pick the application connection string at run time because in production environment the server connection strings are dynamic and keeps on changing depending on the location of the database. I have followed instructions given in support Ticket T19225 and implemented ConfigureDataConnection event in the SqlDataSource. However when i run the application i still get an error of a missing connection as shown in the attached document. Secondly the Modifier Property is not available when defining report parameters while creating a report at run time therefore its not possible to set the parameters as public if they are to be used for sub report. I have attached a sample application for your review. in the sample the database is in the database folder and the error is in the error folder.
Thank you