Using Paginated Reports to develop Sales Collateral

PBI_AMS — Sat, 24 Feb 2024 17:52:59 GMT

I'm not totally clear if this is the right place to post, but I welcome any suggestions. I'm trying to develop a workflow for creating some marketing collateral for a large team, and I'm wondering if Paginated Reports builder can work. Here's how I've got it set up:

Users are completing a webform that includes a variety of fields:

Name of the product
What the product does
A photo of the product
How the product can change your life
List of features of the product
List of part numbers associated with the product
A contact person for the product, their phone number, and email address
A list of products that are related in one way or another.

These are all text fields, essentially. The structure will not change, but users need to be able to ADD products and edit some of the existing fields. The survey tool creates a data model, and I'm pulling that data model into PowerBI service for an interactive version of this product surfer. (Savvier users can access it via their smart phones in the app, for example) But I also need to be able to create printable PDF versions of it embedded in PowerBI. This is where Paginated Reports come in. I've built a flat data table that has ballooned to thousands of rows given all the related fields, and I've pulled it into paginated reports builder. What I can't seem to figure out is how to use the parameters to generate a single page for each product that will list ALL related content for that product on the same page. What I really need is to see a video or tutorial from someone else who has done something like this. I know this sounds like a dumb use of this tool since there's no data analysis anywhere in the mix, but I'm sure someone else has attempted. Any advice?

Re: Using Paginated Reports to develop Sales Collateral

josef78 — Mon, 26 Feb 2024 19:36:57 GMT

You can add "List" object to report, and into row of this list, you can insert another sub-objects (like fields, tables, charts, pictures) as you want. Also you can set page-break on each row of this list.

topic Re: Using Paginated Reports to develop Sales Collateral in Report Server

Using Paginated Reports to develop Sales Collateral

Re: Using Paginated Reports to develop Sales Collateral