Page 1 of 1
Databand Filter: X AND (Y OR Z)
Posted: Thu Jan 17, 2013 1:06 pm
by jmmv2005
I am trying to do the following data filter:
"CODE=UC" AND ("_KUNDE=ALLE" OR "_KUNDE=KUNDE1")
shorter version to understand better: X AND (Y OR Z)
How can I do that with the designer?
Re: Databand Filter: X AND (Y OR Z)
Posted: Thu Jan 17, 2013 1:21 pm
by HighAley
Hello.
You could add such filter by switching the Field Is to Expression and write your filter expression there.
- FilterExpression.png (30.68 KiB) Viewed 2930 times
Thank you.
Re: Databand Filter: X AND (Y OR Z)
Posted: Thu Jan 17, 2013 1:43 pm
by jmmv2005
thanks for the fast response.
How would my expression look like?
Related_Requirements.Code = "UC" AND (Related_Requirements._Kunde = "ALLE" OR Related_Requirements._Kunde = "KUNDE1")
Re: Databand Filter: X AND (Y OR Z)
Posted: Thu Jan 17, 2013 4:25 pm
by jmmv2005
This does work
Related_Requirements.Code.Substring(0,2) == "UC"
However, if I try to relate them with AND and OR, it doesnt. Any ideas?
Related_Requirements.Code.Substring(0,2) == "UC" AND (Related_Requirements._Kunde = "ALLE" OR Related_Requirements._Kunde = "KUNDE1")
Edit:
Neither does it works with logical operators from C
Related_Requirements.Code.Substring(0,2) == "UC" && (Related_Requirements._Kunde = "ALLE" || Related_Requirements._Kunde = "KUNDE1")
Re: Databand Filter: X AND (Y OR Z)
Posted: Fri Jan 18, 2013 5:08 am
by HighAley
Hello.
You could use either C# or VB.NET syntax. It depends on the Script Language property of a report. If you want to use VB.NET syntax, you should set the Script Language property of the report to VB.
Thank you.
Re: Databand Filter: X AND (Y OR Z)
Posted: Fri Jan 18, 2013 9:24 am
by jmmv2005
I looked up, I am using C# as script language.
Why is this code still wrong?
Related_Requirements.Code.Substring(0,2) == "UC" && (Related_Requirements._Kunde = "ALLE" || Related_Requirements._Kunde = "KUNDE1")
Re: Databand Filter: X AND (Y OR Z)
Posted: Fri Jan 18, 2013 10:07 am
by HighAley
Hello.
jmmv2005 wrote:I looked up, I am using C# as script language.
Why is this code still wrong?
Related_Requirements.Code.Substring(0,2) == "UC" && (Related_Requirements._Kunde = "ALLE" || Related_Requirements._Kunde = "KUNDE1")
Please, try to use next code:
Code: Select all
Related_Requirements.Code.Substring(0,2) == "UC" && (Related_Requirements._Kunde == "ALLE" || Related_Requirements._Kunde == "KUNDE1")
Thank you.
Re: Databand Filter: X AND (Y OR Z)
Posted: Fri Jan 18, 2013 12:04 pm
by jmmv2005
Thanks, I now see I forgot to write ==.
There seems however to be a bug in the system.
Some elements of "Related_Requirements._Kunde" on my DB have "ALLE" as value, others have "KUNDE1", "KUNDE2", ...
I want to select all elements that have the value "ALLE" or "KUNDE1".
On specific elements of "Related_Requirements._Kunde" on my DB has these two values: "KUNDE1" and "KUNDE2"
With this query, the element is not selected.
Code: Select all
Related_Requirements.Code.Substring(0,2) == "UC" && (Related_Requirements._Kunde == "ALLE" || Related_Requirements._Kunde == "KUNDE1")
If I use this query, the element is selected.
Code: Select all
Related_Requirements.Code.Substring(0,2) == "UC" && (Related_Requirements._Kunde != "KUNDE2")
Now if we introduce a third value "KUNDE3", it will be selected if I use the second query. Is this a bug or where is the problem?
many thanks
Re: Databand Filter: X AND (Y OR Z)
Posted: Fri Jan 18, 2013 1:14 pm
by HighAley
Hello.
Please, send us your report template with sample data for analysis.
Thank you.