building reports from a form

martensens
martensens Member Posts: 7
edited 2004-06-25 in Navision Attain
Good morning,

i want to open a ledger entry report starting from the item card (form).
how can i transfer the filters from form to report.
Is there any idea ?

Thank's in advance

Steve

Comments

  • FPulsfort
    FPulsfort Member Posts: 43
    You can create a function in your report, which you call before you start your report. The parameters of the function contain your values with which you want to filter in your report. And in the function you can set with these values your filter or you can use the values later in your report.

    Hope this helps.

    Regards,
    Frank
  • TheDude27
    TheDude27 Member Posts: 6
    martensens wrote:
    Good morning,

    i want to open a ledger entry report starting from the item card (form).
    how can i transfer the filters from form to report.
    Is there any idea ?

    Thank's in advance

    Steve



    For Example in the report the function would look like this:
    FilterReport(DateVal : Date, ItemFilter2 : Code)
    "Item Ledger Entry".SETFILTER("Posting Date",DateVal);
    "Item Ledger Entry".SETFILTER("Item No.",ItemFilter2);




    From the form the code could look like this:
    ItemReport.FilterReport(Today,"No.");
    ItemReport.RUN;
  • RobertMo
    RobertMo Member Posts: 484
    and if you don't want to change your report you can make use of
    Report.SETTABLEVIEW(Record);
    rYourILE.SETFILTER("Item No.",rec."no.");
rYourILE.SETFILTER("Posting Date",rec."Date Filter");
rYourILE.SETFILTER("Location",rec."Location Filter");
rpYourReport.SETTABLEVIEW(rYourILE);
rpYourReport.RUNMODAL;
               ®obi           
    ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯

Categories