Creating a report where each record is displayed on a separate sheet

[Ulriklooker62]

Test database and sample report 

I an using forms and sheets a lot, but have struggled to get a good report output.  I have the feeling, that looker can help me, but I am not sure!

I want to make a report design, where each record is displayed on a separat page.  Could be shared or exported as PDF.

In the attached report at have med a small sample database and a sample report

What to do?

[lauratilton]

Yes, you can definitely do this in a Looker Studio report.

The simplest option is to create a horizontal table that displays a single record (1 "row" although if it's horizontal it will appear as a column) and add all the fields you want to display.

Then create a single-select filter control that allows you to choose an exercise (you'll need to add a default value, I like to use "Select" or something simiilar.

You'd then need to format it as desired but here's an example of the way it would function: 
https://lookerstudio.google.com/reporting/b94c6314-9dbf-4dbd-80f2-f06cd825d958

[fabioselau]

Thanks for reply! Resolved my problem! Thanks

[lauratilton]

If you needed more flexibility in where you place/format the fields, you could use multiple single-column, single-row vertical tables and it would work the same way. I've added that option to my example.

[hbudayao]

Hello, for this kind of layout is it possible to be downloaded to a single pdf file for printing where each record in the select control will  be displayed on each page automatically? 

[lauratilton]

Unfortunately, no.