Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Filter not working in a report!
Tiwaz
Member Posts: 98
Hi everyone.
I have a report, that is fairly simple, but I encountered a problem I cannot wrap my head around.
I have two DataItems (ex. Header and Line) which are linked (using ex. Var1, Var2, Var3).
Plus there is also a filter in Line DataItem property where variable ex. BoolVar=CONST(No).
I added a List in Report Designer where i added Group by using those same variables Var1, Var2, Var3.
In my list I added a table where I grouped data from Line on Line No.
I added Filter on List group to be BoolVar=FALSE.
But it doesn't work!
Can you say what could be the problem. I need to see only those Lines where BoolVar is TRUE.
Thanks in advance!
I have a report, that is fairly simple, but I encountered a problem I cannot wrap my head around.
I have two DataItems (ex. Header and Line) which are linked (using ex. Var1, Var2, Var3).
Plus there is also a filter in Line DataItem property where variable ex. BoolVar=CONST(No).
I added a List in Report Designer where i added Group by using those same variables Var1, Var2, Var3.
In my list I added a table where I grouped data from Line on Line No.
I added Filter on List group to be BoolVar=FALSE.
But it doesn't work!
Can you say what could be the problem. I need to see only those Lines where BoolVar is TRUE.
Thanks in advance!
0
Best Answers
-
Options
vaprog
Member Posts: 1,118
Hello Tiwaz
You said you have a filter in the dataitem on BoolVar=No. Therefore no lines with BoolVar = Yes are in the Dataset and thus, no such lines can be processed in the RDL layout.5 -
OptionsTiwaz
Member Posts: 98
I solved my problem by adding filters using SETRANGE in page action which is to call my report
5
Answers
You said you have a filter in the dataitem on BoolVar=No. Therefore no lines with BoolVar = Yes are in the Dataset and thus, no such lines can be processed in the RDL layout.
As Vaproj suggested can you please try dong the same, If you want to accomplish something else then please let us know.
Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/
Thank you for your response
Sadly, this does not dsolve the problem, I have tried it.
If I remove filter on DataItem and then place a filter in rdlc layout, it will show all Lines is BoolVar = FILTER(TRUE) and no lines if BoolVar = FILTER(FALSE).