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
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 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
2009R2 RDLC Building Filters on report request form
jbra
Member Posts: 32
We have a reports where users want/need to build lengthy filters and because they are typically on field type Code, it would be best to use the lookup.
They'd like to be able to still us the look up and add | or & as appropriate. Is there a way to accomplish this?
Simple Example of things we've tried using the Customer Listing. The Goal here is to set a filter on Customer.No_ for CustA|CustB
Run Customer Listing
For No. use the lookup to select CustA
Then type "|"
*attempt to select CustB from look up - fails.
OR
Run Customer Listing
*For No. use the lookup then click advanced, select multiple customers - fails, user can only select one.
They'd like to be able to still us the look up and add | or & as appropriate. Is there a way to accomplish this?
Simple Example of things we've tried using the Customer Listing. The Goal here is to set a filter on Customer.No_ for CustA|CustB
Run Customer Listing
For No. use the lookup to select CustA
Then type "|"
*attempt to select CustB from look up - fails.
OR
Run Customer Listing
*For No. use the lookup then click advanced, select multiple customers - fails, user can only select one.
0
Comments
/Claus Lundstrøm
I'm blogging here:http://mibuso.com/blogs/clausl and used to blog here: http://blogs.msdn.com/nav
I'm also offering RDLC Report Training, ping me if you are interested. Thanks to the 700 NAV developers that have now already been at my training. You know you can always call if you have any RDLC report issues :-)
http://blogs.msdn.com/b/nav/archive/2011/11/25/few-tips-about-filters-usage-in-latest-dynamics-nav-rtc-builds.aspx
It does not solved your issue with "|" but maybe it will make searching easier for you on NAV 2009.
/Claus Lundstrøm
I'm blogging here:http://mibuso.com/blogs/clausl and used to blog here: http://blogs.msdn.com/nav
I'm also offering RDLC Report Training, ping me if you are interested. Thanks to the 700 NAV developers that have now already been at my training. You know you can always call if you have any RDLC report issues :-)