Book Image

Microsoft Dynamics NAV 2015 Professional Reporting

By : Steven Renders
Book Image

Microsoft Dynamics NAV 2015 Professional Reporting

By: Steven Renders

Overview of this book

Table of Contents (19 chapters)
Microsoft Dynamics NAV 2015 Professional Reporting
Credits
About the Author
Acknowledgement
About the Reviewers
www.PacktPub.com
Preface
Index

Conditional formatting in a report


Conditional formatting means using expressions to determine how information is formatted. In its simplest form, and in most common examples, it is used in the color (and background color) properties. An example is using the following expression for the color property of a textbox:

=Iif(Me.Value > 0,"Blue","Red")

In this example, I'm using the Me object, and Me refers to the current textbox. Another example is this expression:

=Iif(Rownumber(Nothing) MOD 2,"PaleGreen","White")

If you use it for the background color property of a row then it means that the even rows will become pale green and odd rows will become white.

Note

Sometimes Me.Value is not recognized in the expression builder. It will depend on if you use Report Builder or Visual Studio.

Let's use this now in a report. You can import the object: Packt - CH04-3 to follow the steps.

The dataset of the report is as follows:

I have used a matrix in the layout to show the inventory (Sum of Quantity) by Location...