Prevent/Control setting of filters in Reports

idiot

Can the user be restricted from selecting only certain fields to be filtered in the reports?



If not can all the filter that are selected by the user be shown on the report?
Any function to achieve this?

Albertvh

Hi,
To show all filters selected you can do the following

FilterText variable size 250

OnPreReport

IF SalesLine.GETFILTERS <> '' THEN
FilterText := 'Filters: ' + SalesLine.GETFILTERS;

FilterText you can put on one of your heading sections or create
a separate heading.

If you want to stop them adding new filters you can't but you could test
with
IF SalesLine.GETFILTER("No.") <> '' THEN
ERROR('You may not enter a No. Filter');

or something like this.


Albert

idiot

Thanks
Seems like there's no easy way out