New Version

tony.tomov · Post by **tony.tomov** » Thu Jan 13, 2011 2:26 am

Hello,
I can not figure out how to realise this.

Also here are my simple steps

1. Lunch Filters Dialog when on DataBand
2.Create a new filter with add
3. Select Field is Expression
4. In the Expression windows I select a Database Field so that we have
{DataSource1.CustomerID='ALFKI'}

Still the expression does not work.
I have try different variants, but without success.

Also I have try to define varaible1 and put it into the expression, but withourt success.

Also it seems that expression evaluator is not fixed or I have do something wrong.

Additionla information

Version: 2011.1.906 from 2011.01.12
Flash Player: 10.1.102 for Linux
OS: Ubuntu 10.10

Any help is welcome

Thank you

Kind Regards
Tony

Vladimir · Post by **Vladimir** » Thu Jan 13, 2011 6:42 am

Hello,

To determine the strings, please use double quotes. To compare values, please use the double equal.

{DataSource1.CustomerID=="ALFKI"}

Expression syntax follows the syntax of C# language. This behavior is for compatibility reports with .NET version of the report generator.

Thank you.

tony.tomov · Post by **tony.tomov** » Thu Jan 13, 2011 7:02 am

Hello,
Thank you.
This work OK, but it does not work with variable.

We have a previous scenario, but this time I have defined a Varaible1 and mark it request from user and set it to be a string.After this I have

{DataSource1.CustomerID==Variable1}

I have a empty record when I input ALFKI.
It work Ok without defining variable as per your advise in previous post

Thank you
Tony

tony.tomov · Post by **tony.tomov** » Thu Jan 13, 2011 7:55 am

Hello,
Today too many posts.
The above works only if I mark the variable as Function. Why?

If this is the way to do this, please document these things.
I'm sure that all of my posts today can not appear if this was documented and explained.

Thank you
Tony

Vladimir · Post by **Vladimir** » Thu Jan 13, 2011 8:14 am

Hello,

The above works only if I mark the variable as Function. Why?

This flag is not necessary. We checked the filter expressions with variables and with variables requested from the user - everything works correctly.

The 'Function' flag is intended for if you want to write an expression to a variable value. But this functionality is not yet fully supported.

Thank you.

tony.tomov · Post by **tony.tomov** » Thu Jan 13, 2011 8:16 am

Hello,
Thank you for the fast response.
For me this work only if I mark it as Function.

Did you tested this on Linux?
I have put my System details in previous post.

More one
MySQL Server version: 5.1.49-1ubuntu8.1
Apache/2.2.16 (Ubuntu)
MySQL client version: 5.1.49

Added: Browser used FireFox 3.6.13

Regards
Tony

Vladimir · Post by **Vladimir** » Thu Jan 13, 2011 8:33 am

Hello,

We use for testing a similar configuration. We were unable to reproduce the error, we will send you a simple test sample with data, there is one variable used in the filter expression. Please see the attached archive.

Thank you.

tony.tomov · Post by **tony.tomov** » Thu Jan 13, 2011 8:43 am

Hello,
Thank you again for the fast response and effort.

Should say: Big Thanks.

All my problems was with the Alias Name bug.
After clearing the cache and use Name=Alias everything work as should be.

Thank you again
Tony

Vladimir · Post by **Vladimir** » Thu Jan 13, 2011 9:03 am

Hello,

In expressions you should always use the variable name.

Thank you.

tony.tomov · Post by **tony.tomov** » Thu Jan 13, 2011 10:48 am

Thanks.
Will it work if the name contain spaces?
Something like this:

{DataSource1.CustomerID==Customer Number}

And we have a Name - Customer Number in the variable definition.

Tony