Don't want so save data item filters on report

mabl4367

Hello everybody!

I have created a report with four data items. Usually the user will only enter filters in one of the data items. Data items with no filters will be skipped when the report is run. My problem is that if a user has run the report once and set some filters on one data item then the same filters will be present the next time the report is run.

I don't want the user to be forced to check all data item tabs to be sure that there are no old filters left.

Is there a way to not save the data item filters? Maby it is possible to clear them before they are saved.

mabl4367

I still got nothing on this. Any one else?

Alex_Chow

Forgot where I got this from. But essentially, you need to recompile the object in order to clear the filters:

ZapFile := 'C:\Zap.txt';
EVALUATE(ObjectNo,TxtObjectNo);

IF Object.GET(ObjectType, '', [Object Number]) THEN BEGIN
  Object.CALCFIELDS("BLOB Reference");
  Object."BLOB Reference".EXPORT(ZapFile);
  Object."BLOB Reference".IMPORT(ZapFile);
  Object.MODIFY;
END;

mabl4367

I tried this but it does not seam like the objekt is recompiled even if I export and import it. How can i trigger a recompile from code?

SLF25

There is no elegant way of doing this, you can try running it from codeunit like that:

DataItem1.RESET;
DataItem2.RESET;
DataItem3.RESET;
DataItem4.RESET;

TestReport.SETTABLEVIEW(DataItem1);
TestReport.SETTABLEVIEW(DataItem2);
TestReport.SETTABLEVIEW(DataItem3);
TestReport.SETTABLEVIEW(DataItem4);
TestReport.RUN;

mabl4367

I tried it but no luck! ](*,)

mabl4367

I take my last post back. It works when I call the report from a codeunit like you suggested SLF25. :oops:

mabl4367

Does anyone know why it doesn't work to reset the filters in the reports OnInitRreport trigger or the request forms OnInit or OnOpenForm triggers?

Miklos_Hollender

SaveTableView property of the RequestForm? Should work.

Savatage

shoulda, woulda, coulda but doesn't

all the resets & clears too - I was surprised when I tried everything I could think of..I guess it's not usually a big deal.. so it's never been addressed by MS?

Alex_Chow

:?:

The code I posted will work. It's in production for a few of our clients. What's the problem you're having?

Savatage

He's got it working..

mabl4367 wrote:

I take my last post back. It works when I call the report from a codeunit like you suggested SLF25. :oops:

mabl4367

Yes it's working and I have also found the same solution used in Relationship Management module. When adding, deleting or refining the contacts in a segment the Add conatcs report (5198) for example is cleared of all its filters in the same way before it's run from frm 5091 Segment.