Report Data not showing on Report

(0) Share

Report

Posted on by Bilal Fazrin

Hello,

This is my first time posting question in this forum regarding development.
I'm trying to recreate report Picking List (5752) and add additional field to the report but its not showing anything
Below are my step on creating the field, I'm not sure if my approach is already correct or not.

I create new table extension to add 2 additional fields ;Carton No and Pallet No, both are looking up from sales order
I create new page extension to show the field on the page
I added the field to dataset in OnAfterGetRecord() with condition if Carton No <> "" then Header Column = "Carton No." and line column get data from new field on table extension else if for pallet no.
I added the column to rdlc file

All responses (2)

Answers (1)

Verified answer

Bilal Fazrin 80 on at

Like (1)

Report

RE: Report Data not showing on Report

Hello sir, Thanks for the replying.

Turned out the cause is because the reference field is using calcFormula lookup,

I just now that I can't take field to report from calc Formula field.

So I create local procedure to call it straight from standard object.
Suggested answer

THE Italian on at

Like (1)

Report

RE: Report Data not showing on Report

You might try to run the debugger to see if these values are popuplated or not.

Visibility in the layout might depends WHERE you placed the column in your report. (in which data item).

I see you logged this request in NAV forum so I assume you could run Windows Client and the same report with the option to see the dataset (about this report).

From there, you could inspect how it looks like your dataset and if the fields is there and how is populated.