Connect a variable to parameter in SQL query

Stimulsoft BI Server discussion
Post Reply
Edmund Andersson
Posts: 35
Joined: Thu May 20, 2010 11:26 am
Location: Sweden

Connect a variable to parameter in SQL query

Post by Edmund Andersson »

Hi!

How can I connect a variable with a value from the user into a query (MySQL)?
Variable.png
Variable.png (20.38 KiB) Viewed 3911 times

I also would like to report a bug:
When using querys in the report designer the name is not visible, instead a hash is shown (below is from Chart Properties).
Hash.png
Hash.png (19.38 KiB) Viewed 3911 times
Best Regards

Edmund
Andrew
Posts: 4104
Joined: Fri Jun 09, 2006 3:58 am

Re: Connect a variable to parameter in SQL query

Post by Andrew »

Dear Edmund,

Thank you for the questions.

1.This is an issue with specifying SQL parameters. If you need a patch where this issue is fixed, please send us a request to support@stimulsoft.com . We will prepare it send it to you.

2. This is not a hash. The columns are called this way to rename them without changing the report. This issue is fixed in the new version. We are ready to provide a patch by sending a request to support@stimulsoft.com .

Thank you.
Edmund Andersson
Posts: 35
Joined: Thu May 20, 2010 11:26 am
Location: Sweden

Re: Connect a variable to parameter in SQL query

Post by Edmund Andersson »

Hi Andrew!

Thanks for your response. When will be the next release where this is fixed?

Another thing, we will need to have the system in Swedish, what if we contribute with the translation?

Best Regards

Edmund
Andrew
Posts: 4104
Joined: Fri Jun 09, 2006 3:58 am

Re: Connect a variable to parameter in SQL query

Post by Andrew »

Dear Edmund,

Thank you for the questions.
When will be the next release where this is fixed?
We expect it be released in April, most probably, the second half of the month. We are not in the process of re-branding. The product will be called Stimulsoft Reports.Server. Following the customer's feedback we have equipped the product with new features and options, simplified it and made it more user-friendly.
Another thing, we will need to have the system in Swedish, what if we contribute with the translation?
Sure. It is possible. Please send us a request to support@stimulsoft.com referring to this forum thread.

Please let us know if you have additional questions.
Thank you.
Post Reply