Selecting a variable in Stimulsoft from MySQL backend

[stimuljohn]

Hi,

I'm new to the company I'm working for and they use Stimulsoft version 2007.2 from 4 September 2007 to create reports for clients. Rather than bother my development team with some simple requests, like this one, I'd like to try and learn what I can about this software to better utilize my skills and time.

We provide a proprietary piece of software to clients which includes the Stimulsoft editing software as part of general functionality. This software interacts with a MySQL database back-end and this is where data is pulled from for report usage.

For one report, I'm trying to understand how I can change the variables that are associated with it. In the 'Dictionary' section of Stimulsoft, I can see the 'Data Sources' and variables that are available from it, but I can't figure out how to either add a new data source or add new variables to the existing data source.

Please let me know if I can clarify my request. And thank you in advance for any feedback anyone can provide.

[Alex K.]

Hello,

If we have correctly understood your problem. If a report is not compiled then you can use the following code for set value of variables:

Code: Select all

report.Dictionary.Variables[VariableName].Value = Value;

else

Code: Select all

report[VariableName] = Value;

Please clarify, you want add variables and data sources from code or from designer.

Thank you.

[stimuljohn]

Hi Aleksey,

Thank you for your reply.

I am looking to add variables from designer, I think. I've attached a screen shot of the editor that I use and hopefully this should clarify a bit more for you. You can see all of the available fields in the "StatementHeader" section, but I am looking for another variable that is not listed. It may be part of another data source; I guess that's what I'm trying to figure out. I know what table/field the data resides in, in MySQL, but I don't know how to translate this into a variable to use in Stimulsoft.

Thank you again for any feedback you can provide. Please let me know if I can clarify any of this information.


Cheers,

John

[Alex K.]

Hello,

If we understand you correctly, you need to create a new connection, then add the necessary data sources (tables). And then you can use fields of these tables in your report.

Thank you.