Tricky filter for SQL Query from Variables.

Stimulsoft Reports.WEB discussion
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Tricky filter for SQL Query from Variables.

Post by HighAley »

Hello.

Please, enable Read Only option of these variables.
They will be calculated each time you use them.

Thank you.
victorinable
Posts: 152
Joined: Mon Aug 03, 2015 9:28 am

Re: Tricky filter for SQL Query from Variables.

Post by victorinable »

Hi Aleksey,

Thanks. It's working fine now. I just supposed Desktop Designer and Web Designer were working almost the same, as in the Desktop Designer I can see the variables calculated even if they're not read only.

Many thanks for the support.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Tricky filter for SQL Query from Variables.

Post by HighAley »

Hello.

In Desktop Designer you get the same behavior.
By default each variable is initialized with specified value at beginning of report rendering. But in this case you need to calculate value of the variable when you use it. So it's possible to do with Read Only option.

Thank you.
victorinable
Posts: 152
Joined: Mon Aug 03, 2015 9:28 am

Re: Tricky filter for SQL Query from Variables.

Post by victorinable »

Hi Aleksey,

I'm sorry to say that this is not real, at least with latest pre-release. The confussion has been raised, in fact, because once I've opened with the Web Viewer, behavior changed (Variables affected by variables were not calculated). That was my confussion.

Anyway, problem is solved ;)

Many thanks for the support.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Tricky filter for SQL Query from Variables.

Post by HighAley »

Hello.

Maybe there was something else.
Anyway we are always glad to help you.
Let us know if you need any additional help.

Thank you.
Post Reply