case sensitive

Navi_Learner

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!

ara3n

could you paste the txt code of the report?

Savatage

Also are you using "OR" with your filters?

filter: this or that

Navi_Learner

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

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;

NaviDev

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;

Navi_Learner

Thanks for your help! It works perfectly!