Microsoft Dynamics NAV (Archived)

Integer DataItem

(0) Share

Report

Posted on by jsshivalik

3,099

I have below DataItem.

Item

Item Ledger Entry.

In a report i am display Item Code, OpeningQty , ReceiptQty , IssueQty, ClosingQty.

In Item Ledger Entry - OnAfterGetRecord() i want if ReceiptQty-IssueQty = 0 then that record should be added to Integer DataItem and those records i want to display in another Tablix.

AT which position i should define Interger DataItem and Secondly when to add records .

Thanks

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Saurav.Dhyani 14,358 Super User 2025 Season 2 on at

Like (0)

Report

RE: Integer DataItem

Some Ideas -

1. Create a variable like TempItemLedgEntry (Temporary = TRUE).

2. In OnaftergetRecords of Item Ledger Entry check like -

IF (ReceiptQty-IssueQty) = 0 THEN BEGIN

TempItemLedgEntry.INIT;

TempItemLedgEntry.TRANSFERFIELDS("Item Ledger Entry");

TempItemLedgEntry.INSERT;

CurrReport.SKIP;

END;

Add a Data Item Integer at Indentation Zero "Last Data item".

In onPreSection check like -

IF TempItemLedgEntry.Count =0 Then

SETRANGE(Number,1,1);

ELSE

SETRANGE(Number,1,TempItemLedgEntry.Count);

In OnAfterGetRecord of Integer do whatever you want to do based on values in TempItemLedgEntry.

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report

RE: Integer DataItem

Hi

What should be DataType of TempItemLedgEntry variable.

Thanks

Was this reply helpful? Yes No
Suggested answer

Binesh 7,885 on at

Like (0)

Report

RE: Integer DataItem

Hello,

1. Create a variable like TempItemLedgEntry (Temporary = TRUE).

To achieve this follow the below steps:

Step 1: Ope the C/AL Globals and declare variables like:

Name DataType Subtype Length

TempItemLedgerEntry Record Item Ledger Entry

----------

Step 2: Goto property and Make, Temporary = Yes

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

RE: Integer DataItem

You need to store data in Temporary table and use that temporary table to display the value using Integer as data item.

Was this reply helpful? Yes No