Report Builder | Exporting reports exercise | Exporting to Excel - one worksheet per group

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Software ==> Report Builder  (42 exercises)
Version ==> RB 3 or RB 2016
Topic ==> Exporting reports  (2 exercises)
Level ==> Average difficulty
Subject ==> Report Builder training
Before you can do this exercise, you'll need to download and unzip this file (if you have any problems doing this, click here for help).

You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Create a report which lists out the films made grouped by actor:

Report Builder 3.0 exercise - Exporting reports (image 1)

Your report could look something like this

Create a copy of the table shown above, and set its visibility and other properties so that you see the report shown above normally, but a workbook like the following when you export the report to Excel:

Report Builder 3.0 exercise - Exporting reports (image 2)

What the start of the Excel workbook generated by the report might look like

You can set the PageName property of the group to be the ActorName field, and the Hidden property of the table to be an expression which depends on the value of the RenderFormat.Name property.

Save this report as Excellent actors.

You can unzip this file to see the answers to this exercise, although please remember this is for your personal use only.
This page has 0 threads Add post