In this chapter, we will talk about formulas. We will explain in detail how to create them and use them. As in previous chapters, we will use a practical example to guide us as we explain how to work with formulas, creating general-use formulas that we can use as an object and specific-use formulas that we can apply to our objects' styles and attributes. We will see the full potential that formulas offer in our reports, and we will create formulas that can be manipulated by the parameters that end users select.
By the end of the practical example, we will see how the combination of formulas and parameters opens up new horizons for the creation and personalization of reports and allows us great flexibility in design.
In this chapter we will do the following:
At the end of the chapter, we propose that you make some modifications to the report created in this chapter.
In this chapter, we will create a copy of the report created in the previous chapter, then we will do the necessary changes in its layout; the final result is as follows:
As we can observe in the previous screenshot, the rectangle that is to the left of each title changes color. We'll see how to do this, and much more, shortly.