Creating reports and dashboards | Stimulsoft community forum

I was able to successfully make a new connection to an existing database by entering the following connection string in the New Connection interface in the report designer:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Q:\Engineering\Microvellum\Jobs 2012\mdb test\Manufacturing Data\Part Labels_NEST.mdb;

The problem is that the portion of the path "Jobs 2012\mdb test\Manufacturing Data" will change every time a report rendering is required. From what I've gathered from reading the forums, it's not possible to use a "variable" or a "parameter" through the New Connection interface but there is a way to make a dynamic connection string through the code tab. When I view the code tab, I see my connection string information as follows:
Unfortunately, I don't know the first thing about writing code behind the reports. So, is there any way I can modify this code to make the connection string dynamic? Perhaps by prompting the user to enter part of the connection string? Thanks, in advance, for your assitance.

Hello.

You could change your connecting string with next code: Thank you.

Hello,

Thanks for your response. Please correct me if I am wrong, but the part of the code "YourNewConnectionString" is still a hard-coded string, right? I need to be able to change the string every time the report is rendered (without having to modify the code--as it is not feasible for the end user to change the code each time). Is there any way to accomplish this? Can I use a variable or a parameter in the code that represents the connection string that can be changed either automatically based on information in the report or manually by prompting the user for an input?

Hello.

You could any string variable or function that returns string instead of "YourNewConnectionString".

Thank you.