Run dataport & filter on active record

Dan

Hi,

I'm using a button with a RunObject command to export files from a purchase order to an excel sheet. I'm using following code "on push": PurchaseHeader.SETRANGE("No.",PurchaseHeader."No.");
How come this filter doesn't work? The dataport exports all the purchase headers to excel! What am I doing wrong?
Thanks! ](*,)

kine

What is in PurchaseHeader??? You mean with your code this?

PurchaseHeader.SETRANGE("No.","No.");  //take the No. from Rec...

Or this?

CurrForm.SETSELECTIONFILTER(PurchaseHeader); //set filter for selected items on form to variable Purchase Header

Czmiel

Hi,
Has anyone found a sollution?
I have a simmilar problem. I added a CommandButton to Form with RunObject property set to MyDataport.
MyDataport exports some data from table Table1.
I want to limit the data Exported to data selected on the form.

kine

Than you cannot use RunObject property but C/AL code in OnPush of the button.

Czmiel

Could you write, how can I set the filter for MyDataport in C/AL Code in the OnPush trigger?