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

Request filter on report based on temp table

(0) Share

Report

Posted on by Samantha73

2,841

Hi All

I have created a RDL report based on a temp table and on pre data item of the report, values are inserted to the temp table (table created with tabletype = temporary) to combine sales orders and archived sales orders. There is only one integer dataitem on the report. The problem is - how do I add run time request filters so the users can set dates for sales orders and archived sales orders as RequestFilterFields only get fields from the integer table (i.e.Number)

Thanks

All responses (2)

Answers (0)

Suggested answer

Akshay_Panchal 402 on at

Like (0)

Report

RE: Request filter on report based on temp table

Hii,

You can use variable for the date filter..and while inserting record on the temporary table put the date filter on the same..also you have also refer table from where you are inserting record into temp table.

Thanks

Verify, If this answer helpful to you.
Suggested answer

Inge M. Bruvik 1,025 Moderator on at

Like (0)

Report

RE: Request filter on report based on temp table

In the case where the sales order table is not a data item on your report you will have to get your datefilter from a request page and then use the filter you get from the request page to set the filter on your sales order table.