How to add field from custom table as a column to a report extension?

(1) Share

Report

Posted on by jdrco

481

I am trying to add a column on my report extension that is linked to a field from a custom table I made.

The custom table is called "Program"

Here is how I am trying to do it:

Screen-Shot-2022_2D00_05_2D00_18-at-9.09.06-AM.png

Screen-Shot-2022_2D00_05_2D00_18-at-9.10.23-AM.png

But I get this error:

The Program does not exist. Identification fields and values: Program Code='', ID=0.

This is the way I have been grabbing fields from default tables onto my report extension, so is there anything different I have to do since this time I am trying to access a field from a custom table?
How would I go about accomplishing this requirement?

Thanks,

I have the same question (0)

All responses (13)

Answers (2)

Verified answer

YUN ZHU 90,632 Super User 2025 Season 2 on at

Like (0)

Report

RE: How to add field from custom table as a column to a report extension?

Hi, It looks like you have a problem with Get method. Please confirm the primary key in the ProgramCard, and whether the content of the primary key can be retrieved in the Report.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Giambattista Malvasi 195 on at

Like (0)

Report

RE: How to add field from custom table as a column to a report extension?

You can vote my respinse?

Was this reply helpful? Yes No
jdrco 481 on at

Like (0)

Report

RE: How to add field from custom table as a column to a report extension?

Thank you all. I was able to achieve what I wanted. I basically just added this under OnAfterAfterGetRecord():

ProgramCard.get("Program Code", ID);

Was this reply helpful? Yes No
Giambattista Malvasi 195 on at

Like (0)

Report

RE: How to add field from custom table as a column to a report extension?

Were is the connection from "Sales Invoice Header" to "program Card"?

Was this reply helpful? Yes No
jdrco 481 on at

Like (0)

Report

RE: How to add field from custom table as a column to a report extension?

It is a Record of "Sales Invoice Header"

Was this reply helpful? Yes No
Giambattista Malvasi 195 on at

Like (0)

Report

RE: How to add field from custom table as a column to a report extension?

What is the Record of the DataItem "Header?"

Was this reply helpful? Yes No
jdrco 481 on at

Like (0)

Report

RE: How to add field from custom table as a column to a report extension?

How do I deal with using SetRange to target the field?

Was this reply helpful? Yes No
Verified answer

Giambattista Malvasi 195 on at

Like (0)

Report

RE: How to add field from custom table as a column to a report extension?

You can use trigger OnAfterAfterGetRecord()

Was this reply helpful? Yes No
Suggested answer

Alok.kulshreshtha 934 on at

Like (0)

Report

RE: How to add field from custom table as a column to a report extension?

Hi,

When i say , "Field I Want" in header, I am actually referring a value in "Field I want".

so the value in ProgramCard."Field i want" is exist in any column in header table? if yes than use that field in place of

"Field I want" in ProgrameCard.get(Header."Field i want")

Regards,

Alok

Please Verify my answer if you find my post helpful.

Was this reply helpful? Yes No
jdrco 481 on at

Like (0)

Report

RE: How to add field from custom table as a column to a report extension?

Thanks for this, unfortunately the requirement I have is a bit more abstract than what is explained in the docs.

Is there a a site or service where I could get live on-call help regarding this AL implementation?

Was this reply helpful? Yes No