2009R2 RDLC Building Filters on report request form

jbra
jbra Member Posts: 32
edited 2013-04-15 in NAV Three Tier
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.

Comments

  • clausl
    clausl Member Posts: 455
    The seperater "|" does not work in NAV 2009. That issue is fixed in NAV 2013, but this will of course not help you.

    /Claus Lundstrøm
    Claus Lundstrøm | MVP | Senior Product Manager | Continia.com
    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 :-)
  • jbra
    jbra Member Posts: 32
    That made me hopeful that I'd be able to build the filter using & and then replace, but alas, it does not work either. :(
  • clausl
    clausl Member Posts: 455
    I stubled upon this link, and thought maybe it could be usefull for you on NAV 2009:

    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
    Claus Lundstrøm | MVP | Senior Product Manager | Continia.com
    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 :-)

Categories