Small and medium business | Business Central, N...

How to add comment throw report request page?

(0) Share

Report

Posted on by T_Mauser

397 User Group Leader

Hello,

does anyone have experience how to add a comment throw the report request page on to the printed report?

The field "AddComment" is provided in the table where the data is obtained.

field(9; AddComment; Text[200]) //For reports to get an additional description/comment.
        {
            Caption = 'Additional Comment';
        }

To show the field in the request page:

So the question is how to I play the entered comment back into the table/field to use it in the report. Save the entered comment throught the request page to the record.

Thank you guys!

Tom

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

JAngle 152 on at

Like (0)

Report
Copy link

Link copied!

So the user sets a comment before they see the report? Adding comments to reports is standard Powet BI btw - whilst looking at the data visuals.

Maybe try setting the value from the request page to a variable and display that in the output. Then using the Onpost trigger set the value in the table with the stored variable.

Was this reply helpful? Yes No
Suggested answer

Vaishnavi J 3,094 on at

Like (0)

Report
Copy link

Link copied!

Hi

Below is pseudo code for the same.

Trigger OnPreReport()

Var Rec_XYS: Record XYZ;

begin

Rec_XYS.Setrange(No, PK)

if RecXYS.findfirst () then

RecXYS.Comment:= AddComment;

RecXYS.Modify(true);

end;

if your table is posted entries table then you have to add permission as well for RIMD for that table.

once you have set the value in table you can use it as field/column in your report and then show it on report.

If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much

Was this reply helpful? Yes No
T_Mauser 397 User Group Leader on at

Like (3)

Report
Copy link

Link copied!

Vaishnavi Joshi thank you! One problem I had with your solution is that the record (which ccome from the report.run()) wasn't initialized at this point (OnPreReport()) -> OnPostReport() works :D

JAngle everything works now! -> had to change the variable in the column as you said with a global variable.

Thank you both for your quick response!

Cheers

Tom

Was this reply helpful? Yes No
Suggested answer

Yash_Mistry 90 on at

Like (0)

Report
Copy link

Link copied!

Hello,

You can use InstructionalText property for that.

Reference:https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-instructionaltext-property?wt.mc_id=d365bc_inproduct_alextension

Regards,
Yash Mistry

Was this reply helpful? Yes No