How can I change the connection string without coding?

[Andreas-Schmidt]

Hi,

I create a report for a customer. I send them the Report, the problem is that the customer have different connection string (username is different)
How can he change this in the report directly? There are no properties if the connection string wrong

Thanks for help!!!!

[Alex K.]

Hello,

Could you clarify your problem. Do you send users to a report template (.mrt) or a generated report (.mdc)? Also is there a possibility for a user to adjust the report in the designer? And how a user opens a report (application, viewer, designer)?

Thank you.

[Andreas-Schmidt]

Hi,

I use the designer and create a mrt file. The customer also have the designer but he can't edit the connection string.

Thanks!

[Alex K.]

Hello,

I send them the Report, the problem is that the customer have different connection string (username is different)

As a way, you can use "Promt User Name and Password" option for connection. In this case, before report rendering a username and password will be requested.

Thank you.