How to populate a Temporary Table in a report from a Query

(6) Share

Report

Posted on by ME-31032107-0

683

Relatively new to BC coding using AL. I have created a Query that I use to populate a Temp Table, which is then used to build a Page. I followed this link, which was extremely helpful. https://yzhums.com/4869/

I have also used the Query to create an RDLC report, which works great, but as I understand it, you cannot define Report Filters when the DataSet is a Query.

So I would like to use the Query to load data into the Temp Table so I can utilize the Report Filters.

I am trying to use the OnPreReport trigger in the report.al file, but the table is empty (apparently) as I get an error saying there is no data in the report.

Not sure what I am missing, but does anyone have some sample code I can review to see how this is done?

I am attaching the Query, Temp Table, and report.al (based on the Query) that I have so far.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (9)

Answers (1)

ME-31032107-0 683 on at

Like (2)

Report

I forgot to attach the files, here they are. Thanks.

ABCSalesLineItems...

SalesLineItemsQue...

ABCSalesLineItems...

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,548 Super User 2025 Season 2 on at

Like (2)

Report

Hi, hope the following helps.

Dynamics 365 Business Central: How to use a query to create a report dataset (Creating Report with Query)

https://yzhums.com/58885/

As for filtering, you can try adding it to the trigger below.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/query/queryinstance-setfilter-method?wt.mc_id=DX-MVP-5004336

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,439 Super User 2025 Season 2 on at

Like (3)

Report

Please check this too:https://community.dynamics.com/forums/thread/details/?threadid=5b033777-410f-4d54-b2ae-09aa6e51d183

https://community.dynamics.com/forums/thread/details/?threadid=35460005-db7d-4fab-9df7-469239a55ef9

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,439 Super User 2025 Season 2 on at

Like (3)

Report

I can see the value in report

Was this reply helpful? Yes No
ME-31032107-0 683 on at

Like (3)

Report

YUN ZHU, thanks for your reply. I am not trying to filter the dataset, but rather have the ability for the report to add a filter in the UI, like when using the RequestFilterFields = "No.". When I try to use it, I get the error "Reference No. in application object Integer does not exist".

Was this reply helpful? Yes No
ME-31032107-0 683 on at

Like (2)

Report

Khushbu Rajvi, I have read that article and am trying to replicate it, but it is not working. If you were successful, can you share your code so I can see what I am missing?

Was this reply helpful? Yes No
Verified answer

Gerardo Rentería Ga... 25,225 Most Valuable Professional on at

Like (3)

Report

Hi, good day
I hope this can help you, and give you some hints.

How to design a high performant inventory report in Business Central - D365 Business Central Freelance Developer

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,439 Super User 2025 Season 2 on at

Like (3)

Report

Hi, ME-31032107-0

you please check this : https://community.dynamics.com/forums/thread/details/?threadid=eaa3aac1-0310-f011-9989-7c1e52643bb6

Was this reply helpful? Yes No
ME-31032107-0 683 on at

Like (3)

Report

gdrenteria, thank you. Your post was very helpful to me being able to get what I needed. Thanks!!

Was this reply helpful? Yes No