SBX - Search With Button

SBX - Forum Post Title

Error - Adjust Cost Item Entries report does not have a DataItem that uses the table (Table 27 Item) specified in the function SetTableView.

Microsoft Dynamics NAV Forum

jsshivalik asked a question on 5 Jun 2019 5:36 AM
My Badges

Question Status

Suggested Answer

Hi

   When i call the report i get above error

MyRec is Record Datatype with SubItem Item


MyRec.RESET;
MyRec.SETRANGE("No.","No.");
IF MyRec.FINDFIRST THEN
REPORT.RUN(795, TRUE, TRUE, MyRec);

Thanks

Reply
Teddy Herryanto responded on 5 Jun 2019 3:09 PM
My Badges
Suggested Answer

Your report must have the same data type Item in it.

Reply
jsshivalik responded on 6 Jun 2019 12:03 AM
My Badges

Hi

 Then what changes should i made to the below line so thar Report 795 should run . I want to pass only 1 item.

In Report 795 there is Global Variable on request page ItemNoFilter related to table Item. So I want that No should be passed to this variable so that report should run.

REPORT.RUN(795, TRUE, TRUE, MyRec);

Thanks

Reply
Andrea Antoniazzi responded on 6 Jun 2019 6:03 AM
My Badges

Hi,

you can try this way

Item.RESET;

Item.SETRANGE("No.", 'INSERT HERE THE ITEM CODE YOU NEED TO FILTER');

IF Item.FINDFIRST THEN

BEGIN

 CLEAR(AdjustCostItemEntries);

 AdjustCostItemEntries.InitializeRequest(Item."No.", '');

 AdjustCostItemEntries.USEREQUESTPAGE(FALSE);

 AdjustCostItemEntries.RUN;

END;

Item is a global variable on table Item

AdjustCostItemEntries is a global variable on report 795

Best regards

Reply
Teddy Herryanto responded on 6 Jun 2019 3:52 PM
My Badges
Suggested Answer

Because the report 795 does not take Item variable as parameter.

Use the InitializeRequest as Andrea said.

Reply
jsshivalik responded on 11 Jun 2019 5:56 AM
My Badges

Hi Andrea

 Can u pls guide how the below line's work.

    CLEAR(AdjustCostItemEntries);

    AdjustCostItemEntries.InitializeRequest("No.", '');

Thanks

Reply
Teddy Herryanto responded on 11 Jun 2019 3:08 PM
My Badges
Suggested Answer

The CLEAR(AdjustCostItemEntries) will clear any variables in that report.

The AdjustCostItemEntries.InitializeRequest(ItemNoFilter,ItemCategoryFilter) use the Item No filter and Item Category filter to filter the items.

Reply
Teddy Herryanto responded on 5 Jun 2019 3:09 PM
My Badges
Suggested Answer

Your report must have the same data type Item in it.

Reply
Teddy Herryanto responded on 6 Jun 2019 3:52 PM
My Badges
Suggested Answer

Because the report 795 does not take Item variable as parameter.

Use the InitializeRequest as Andrea said.

Reply
Teddy Herryanto responded on 11 Jun 2019 3:08 PM
My Badges
Suggested Answer

The CLEAR(AdjustCostItemEntries) will clear any variables in that report.

The AdjustCostItemEntries.InitializeRequest(ItemNoFilter,ItemCategoryFilter) use the Item No filter and Item Category filter to filter the items.

Reply

SBX - Two Col Forum

SBX - Migrated JS