Date variable in Dataport

mfhmfh Member Posts: 28
Hello,

The user who runs an export dataport should be able to enter a specific date (YYYYMMDD) before exporting. I want to put this date in a Text variable StartDate, which is one of the dataport fields to be exported.
However, if I add the field to the request form, the standard Path and Export/Import fields on the options tab seem to have dissapeared!

Is there a possibility to enter this variable date on running the report somewhere else?

Regards,
Michiel
Regards,
Michiel

Comments

  • AlbertvhAlbertvh Member Posts: 516
    Hi mfh

    If I remeber correctly put the filename control on the request form with id 1


    Albert
  • David_CoxDavid_Cox Member Posts: 509
    Create a Variable called FileName text 250

    On the request form add a textbox with the datasource as FileName, this control must be control ID = 1, then set the property to AssisEdit = yes

    Dataport - OnPreDataport()
    IF FileName = '' THEN
       ERROR('Please Enter a Valid File Name');
    
    CurrDataport.FILENAME := FileName;
    

    David
    Analyst Developer with over 17 years Navision, Contract Status - Busy
    Mobile: +44(0)7854 842801
    Email: david.cox@adeptris.com
    Twitter: https://twitter.com/Adeptris
    Website: http://www.adeptris.com
  • mfhmfh Member Posts: 28
    Thanks Albert, David, that worked!!
    Regards,
    Michiel
Sign In or Register to comment.