Run a report with filter information

nav_student
nav_student Member Posts: 175
edited 2010-02-16 in NAV/Navision Classic Client
Hi guys i want to populate a report with information from the form Reminder Header table.

The dataitem of my report is made by the table " Issued Reminder Header".


How can i call this Report with the information that is given by the record that is on the Reminder Header table?


I have tried this code


IssRemindHeader.SETCURRENTKEY(IssRemindHeader."No.");
IssRemindHeader.SETFILTER("No.", ReminderHeader."No.");

r.SETTABLEVIEW(Rec);
r.RUN()


but error is telling me

The Remimnder report does not have a DataItem that uses the table 297 specified the function SetTableView.



I try to use the functiuon TRANSFERFIELDS but Nav gives me an error telling me that the fields has to belong to the same table.

Can you help me?


Best Regards.

Comments

  • Savatage
    Savatage Member Posts: 7,142
    Check the c/side ref guide for RUNMODAL for details.

    use search search.php
    for "pass filter to report" for many posts & examples

    here's 1 to start:
    viewtopic.php?f=23&t=37286
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • sendoh
    sendoh Member Posts: 207
    IssRemindHeader.SETCURRENTKEY(IssRemindHeader."No.");
    IssRemindHeader.SETFILTER("No.", ReminderHeader."No.");

    r.SETTABLEVIEW(Rec); <-- the problem is here instead of rec it should be IssRemindHeader
    r.RUN()
    Sendoh
    be smart before being a clever.
  • nav_student
    nav_student Member Posts: 175
    With this the problem remains

    The Remimnder report does not have a DataItem that uses the table 297 specified the function SetTableView.
    IssRemindHeader.SETCURRENTKEY(IssRemindHeader."No.");
IssRemindHeader.SETFILTER("No.", ReminderHeader."No.");

r.SETTABLEVIEW(IssRemindHeader); 
r.RUN()


    I try also this
    CLEAR(r);
IssRemindHeader.INIT;
IssRemindHeader.TRANSFERFIELDS(Rec,FALSE);
IssRemindHeader.INSERT;
IssRemindHeader.SETCURRENTKEY(IssRemindHeader."No.");
IssRemindHeader.SETFILTER("No.", ReminderHeader."No.");
r.SETTABLEVIEW(IssRemindHeader);
r.RUNMODAL;

    The debugger stops on r.SETTABLEVIEW(IssRemindHeader).

    I do not understand why i have this error the data item´s for my report are:

    Issued Reminder Header
    Integer
    Integer
    Issued Reminder Line
    Issued Reminder Line
    Issued Reminder Line
    Integer
    Integer

    On the referenceGuide i see this

    This function only narrows the view of the table that was set through the SourceTableView property of the form, or the DataItemTableView property of the data item.

    Form has SourceTableView -> Reminder Header
    Report has DataItem -> Issued Reminder Header

Categories