Forum Discussion
Power BI Report Builder Capability
By the way, the number of companies is not pre-determined and it depends on the timing of data refresh. I would need to be able to provide X number of tables when there are X number of companies.
Yes, it is possible.
SSRS and paginated reports on PBIRS are same, FYI.
There are FEW WAYS to do it. I guess you are looking as
A list data region with Company ID/Company Name
and nested table with the format you need of the columns 1, 2, 3, 4
Other way is nested table and make certain rows and column have zero borders to get the effect.
Check these to give you an idea
https://sqlserverbi.blog/2010/03/11/nested-tables-in-a-repeating-list-data-region-2/
https://www.tutorialgateway.org/create-a-list-report-in-ssrs/
https://sqlserverbi.blog/2017/04/05/chapter-7-advanced-report-design/
