Set parameter in code

[rafaelwithoeft]

Hello, how i set parameters to report in the code?
Now i have this, but not work...

Code: Select all

report.Compile();
report.dictionary.variables["@sql"] = new StiVariable("@sql", parametros); 
//report["@sql"] = parametros;
report.Render(false);

Best Regards

[Alex K.]

Hello,

Please describe your task in more details. Which parameters you are want set - variable, parameters for the query?
Also please clarify which version are you are use?

Thank you.

[rafaelwithoeft]

Hello, i'm using Reports.FX for JAVA 2014.3, i want to set the value of variables and parameters to SQL, how i do it? (You make me a sample?)
I have variable named @sql, i want to send the sql to this variable to use in sql.

I have used this code, but not worked

Code: Select all

report.Compile();
report.dictionary.variables["@sql"] = new StiVariable("@sql", parametros); 
//report["sql"] = parametros;
report.Render(false);

Best Regards

[Vadim]

Hello.
For JAVA you can use next code:

Code: Select all

report.getDictionary().getVariables().get(variableName).setValue(value);
report.getVariables().put(variableName, value);
report.Render(false);

Hello, i'm using Reports.FX for JAVA 2014.3, i want to set the value of variables and parameters to SQL, how i do it? (You make me a sample?)
I have variable named @sql, i want to send the sql to this variable to use in sql.

I have used this code, but not worked

Code: Select all

report.Compile();
report.dictionary.variables["@sql"] = new StiVariable("@sql", parametros); 
//report["sql"] = parametros;
report.Render(false);

Best Regards

[rafaelwithoeft]

Thank you! It Worked!

[Andrew]

Hello,

Great!
We are always glad to help you!