case sensitive

Navi_Learner
Navi_Learner Member Posts: 356
edited 2008-04-09 in NAV/Navision Classic Client
Hi expert! I have four filters in my report and one is date and the rest of them are items. If I coded all items with non-case sensitive search, it works only for one item and also if I filter the date only, it retrieve zero page. Could you let me know how to fix it? thanks!

Comments

  • ara3n
    ara3n Member Posts: 9,258
    could you paste the txt code of the report?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Savatage
    Savatage Member Posts: 7,142
    Also are you using "OR" with your filters?

    filter: this or that
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • Navi_Learner
    Navi_Learner Member Posts: 356
    Here is the code! Thanks!

    filterprinter := '@'+"factory".GETFILTER(Printer);
    "factory".SETFILTER(Printer,filterprinter) ;

    filteritem1 := '@'+"factory".GETFILTER("Product Model 1");
    "factory".SETFILTER("Product Model 1",filteritem1) ;


    filteritem2 := '@'+"factory".GETFILTER("Product Model 2");
    "factory".SETFILTER("Product Model 2",filteritem2) ;

    It works only for the first search. I also have a date range, but after adding these codes, if only enter the date range, there is no data retrieved.
  • sendoh
    sendoh Member Posts: 207
    It works only for the first search
    what is this means? in first page only?in product model 1 only or what?
    I also have a date range, but after adding these codes, if only enter the date range, there is no data retrieved.

    add this to returns all data if there's no filter entered on you require filter.

    if GETFILTER(Printer) <> '' then begin
    filterprinter := '@'+"factory".GETFILTER(Printer);
    "factory".SETFILTER(Printer,'%1',filterprinter) ;
    end;


    if GETFILTER("Product Model 1") <> '' then begin

    filteritem1 := '@'+"factory".GETFILTER("Product Model 1");
    "factory".SETFILTER("Product Model 1",'%1',filteritem1) ;
    end;


    if GETFILTER("Product Model 2") <> '' then begin
    filteritem2 := '@'+"factory".GETFILTER("Product Model 2");
    "factory".SETFILTER("Product Model 2",'%1',filteritem2) ;

    end;
    Sendoh
    be smart before being a clever.
  • NaviDev
    NaviDev Member Posts: 365
    I think this way is what sendoh means.
    IF  "factory".GETFILTER(Printer) <> '' then begin
  filterprinter := '@'+"factory".GETFILTER(Printer);
  "factory".SETFILTER(Printer,'%1',filterprinter) ;
END;


IF "factory".GETFILTER("Product Model 1") <> '' THEN BEGIN
  filteritem1 := '@'+"factory".GETFILTER("Product Model 1");
  "factory".SETFILTER("Product Model 1",'%1',filteritem1) ;
END;


IF "factory".GETFILTER("Product Model 2") <> '' THEN BEGIN
  filteritem2 := '@'+"factory".GETFILTER("Product Model 2");
  "factory".SETFILTER("Product Model 2",'%1',filteritem2) ; 
 
END;
    Navision noob....
  • Navi_Learner
    Navi_Learner Member Posts: 356
    :) Thanks for your help! It works perfectly!

Categories