Create paginated report for distribution

[Anonymous]

 Hi all,

I only have pro licence and not premium. How do I go about with what i have in order to generate out pdf for each agent (around 200 agents) automatically? This is based on a dimension agent. I tried Power BI Report builder that i can download into my own laptop (just that i cant publish it due to Pro licence only).

I can create table and seperate each agent by using page break, and save it into excel by tabs. I can consider create macro to save each tab into seperate pdf. But my question is, even though i cant create table and seperate agent by page break, i can't do this similar way on charts. There will be only 1 chart at the end that sums up all agent. Any idea how to go about it? 

Basically each agent should have their own table and chart showing performance in one page, and next page for next agent, and so on and forth.

[dax · Accepted solution]

Hi @Anonymous , 

According to your description, it seems that you want to show table and chart of each agent in each page, right? If so, I think you use List in report builder.

Inset a List , then set groups in "Details", and insert table and chart in List, then set page break of List like below

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.