How to clear previous filter on request form of Report

gison

Dears,

I got a problem on the Report.
Once user executed the report, system will remember the filter user gave.
Does there have any way to clean this filter or make system not keep this filter?


thank you for your help.

kine

Check the report properties...

xin

Check the properties, there is SaveValues property, set it to NO

gison

Actually, i cannot find the control point from the report properties.

thank you

xin

gison wrote:

Actually, i cannot find the control point from the report properties.

thank you

it's on the request form property, not the field property in the request form. Just click on the request form and search.

Thanks

vijay_g

xin wrote:

gison wrote:

Actually, i cannot find the control point from the report properties.

thank you

it's on the request form property, not the field property in the request form. Just click on the request form and search.

Thanks

i think guy asking about Dataitem Filter not option form filter.

gison

vijay_g wrote:

i think guy asking about Dataitem Filter not option form filter.

yes, you are right, the problem is on Dataitem filter.

ara3n

call the report from a codeunit and pass a record without any filters.

report.SETTABLEVIEW(recordwithout anyfilter);
report.runmodal;

gison

ara3n wrote:

call the report from a codeunit and pass a record without any filters.

report.SETTABLEVIEW(recordwithout anyfilter);
report.runmodal;

Since we run the report by different way, and this report have more than one DataItem (ex: Sales Header, Purchase header, Sales Invoice...), so it's possible have filter on other DataItem.

REPORT.RUN(ReportSelection."Report ID",FALSE,FALSE,SalesInvHeader);

David_170

Same problem here !

I would like to clear previous filter without other report or any other thing !

aejlskov

I just had the same problem.

A report with 2 dataItems, where the user can set filters on both dataitems. When running the report. NAV will remeber the filters set on both dataitems, the next time the user want's to print the report.

When running your report, instead of using:

Report.RUN(REPORT::MyReport,TRUE,FALSE,MyRecord1)

Use this:

MyRecord1.RESET;
MyRecord2.RESET;

MyReport.SETTABLEVIEW(MyRecord1);
MyReport.SETTABLEVIEW(MyRecord2);
MyReport.RUN.

where MyRecord1 and MyRecord 2 are variables of datatype Record equal to the dataitems used in the report
and MyReport is a variable of datatype Report.

julkifli33

how about clear filter for the page???

CurrPage.SETSELECTIONFILTER(Rec);
REPORT.RUN(50000,TRUE, FALSE,Rec);

what should i add to clear the filter, after i pull the report?

Tommy_Schou

Use a variable of the same type as Rec and use that in your SETSELECTIONFILTER and REPORT.RUN instead of Rec.

AntidotE

aejlskov wrote:

I just had the same problem.

A report with 2 dataItems, where the user can set filters on both dataitems. When running the report. NAV will remeber the filters set on both dataitems, the next time the user want's to print the report.

When running your report, instead of using:

Report.RUN(REPORT::MyReport,TRUE,FALSE,MyRecord1)

Use this:

MyRecord1.RESET;
MyRecord2.RESET;

MyReport.SETTABLEVIEW(MyRecord1);
MyReport.SETTABLEVIEW(MyRecord2);
MyReport.RUN.

where MyRecord1 and MyRecord 2 are variables of datatype Record equal to the dataitems used in the report
and MyReport is a variable of datatype Report.

Thanks a lot!
How can we make difference between several dataitems to the same record?