Passing Default Report parameter for sending the email in Business central

(0) Share

Report

Posted on by M Saravanan

244

Dear members,

I would like to know how to pass the parameters for a default value while sending a email with attachment (Report) in business central. Currently, my email sending process gets failed when I am trying to send the email.

Please do suggest me the best way to pass the parameters for a default value.

Thanks in advance,

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

NAV_with_Narang 2,294 Moderator on at

Like (0)

Report

There are a couple of ways you can do that, Passing values through functions, passing values through SETTABLEVIEW if these values are table fields or can also pass values through a XML Formatted string in the request page

Scenario 1

If your report filters are all table fields, suggest you to use the below in your code

SETRANGE

SETRANGE

REPORT.SETTABLEVIEW

REPORT.RUN

Scenario 2

If the report request page parameters are variables instead of table fields, Create a global function on the report you'd like to be attached as PDF in the Email. Make sure this function has all the request page global variables on the left side of the assignment and all your function parameters on the right side, much like:

Now from the email batch report you have created, which attaches the above report as PDF, you can write the code as:

Was this reply helpful? Yes No