Variables in Data Report Query

hi

how can i use variables in a data report query

how can i set the default value from a data report parameter with a value from a variable

it works when i set a static default value in a Parameter and use this parameter in a query

but i need the value for the query from a parent custom field

klaus

another question

can i use variables in data report Connection string?

klaus

another question too

in the rdm help at data Report ther is the info:

This supports multiple queries in the statement and will display the results in different tab pages.

but i Can not do this with an ODBC mysql query

klaus

Hello,

It may be confusing to follow because we have our Dynamic Variables that allow to get information from RDM itself, or the SQL report variables.

Sadly ourDynamic variables are not integrated with the data report type. Its surprising really, I wonder how we've never gotten that request. I will move this topic in the Feature Request forum.

As for the multiple queries, it makes used of a feature called Multiple Active Result Sets. In your Connection String, please go in the advanced settings and have a look to find a property called MultipleActiveResultSets or MARS_xxx. IF there is one, you could set it to TRUE. If its not there, maybe the driver doesnt support it.

hi

thanks

looking Forward to a new release supporting this Feature

klaus

Hello,

We will add support for variables in the Connection String with the next version of RDM.

Unfortunately at the moment we cannot allow variables in the parameters. What you can do though is directly put your variables in the query. This should already work in the latest stable version of RDM. Does this work for your use case?

Regards,

Ok

Thank you

Klaus