Run a report with filter information

nav_student

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.

Savatage

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

sendoh

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()

nav_student

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