Announcements
Hi,
is it possible to use a Temp Table as a Source Table for a Report in Business Central ?
Thanks,
Nishantha.
hi,
Yes you can use Temp Table as source table for Report development.
Regards
Amit Sharma
www.erpconsultors.com
www.linkedin.com/.../
Yes, you can but make sure you delete your Temp table data after your reports run. ;)
Thanks
Yes, you can set UseTemporary = true; on a data item:
docs.microsoft.com/.../devenv-usetemporary-report-property
And you can also use temporary tables or recordvariables:
docs.microsoft.com/.../devenv-temporary-tables
Many reports do that, have a look at:
1306 Sales Invoice
111 Customer top 10
Hi, Yes, this is also the most performant and recommended practice.
You can use the following three ways to set the temp table.
Hope this helps as well.
Thanks.
ZHU
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 1,713 Super User 2026 Season 1
YUN ZHU 1,032 Super User 2026 Season 1
Grigorios Mavrogeorgis 914 Super User 2026 Season 1
