This page has 0 threads | Add post

Exercises

Finding our exercises useful? Please consider helping us to share more!

Software ==>	Report Builder (42 exercises)
Topic ==>	Expressions (5 exercises)
Level ==>	Harder than average
Subject ==>	Report Builder training

Amend a report so that it has an alternating row colour and flashing background, using expressions

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.

Before you can do this exercise, you'll need to download and unzip this file .

Open the report called The Directors in the above folder (or a version of the report that you have created yourself). You may need to edit the data source of the report so that it points to the correct connection.

Amend the report so that alternate rows appear shaded:

Report Builder 3.0 exercise - Expressions (image 1)

See the notes below for how to achieve this effect

To make this work, note that RowNumber(Nothing) will give the row number of the current row - the Nothing signifies that you're taking the row number over the entire table, not some limited scope within it - and that 17 mod 3 equals 2, for example (ie you can use mod to calculate the remainder when you divide one number by another).

Too easy? Set the Autorefresh property of the report to 1, and it will refresh itself automatically every second. You can then set the background colour of the report to an expression which gives a different colour every second: