SAP Crystal Reports 2011, Win User's Guide Page 480

  • Download
  • Add to my manuals
  • Print
  • Page
    / 718
  • Table of contents
  • BOOKMARKS
  • Rated. / 5. Based on customer reviews
Page view 479
8.
Click OK.
21.12.2 Applying conditional formatting using parameter fields
Parameter fields can be used to create conditional formatting formulas. You can customize these
formulas whenever you refresh the report data. A conditional formatting formula could be used for
color-flagging data that meets certain conditions. For example:
Sales representatives who sell more than 10% over quota.
Customers who have not ordered in the last quarter.
Inventory items that have not had any movement in the last month.
If the conditions under which you flag these items never change, you do not need to use parameter
fields. You can just use formulas (for text flags) or conditional formatting (for border flags). However,
to change the conditions from report to report, you need to use parameter fields in formulas and
conditional formatting formulas.
21.12.2.1 To apply conditional formatting using parameter fields
1.
Create the parameter field of the data type you need for the formula.
2.
Create the formula and use the parameter field in place of the fixed value you would normally use.
For example, to be prompted for all the customers whose last year's sales were over a certain
value, and to print their names in red, select the Last Year's Sales field and click Format from the
Expert Tools toolbar.
The Format Editor appears.
3.
Click the Conditional formula button next to the Color property on the Font tab, and format the
field using a conditional formatting formula like this:
If {customer.LAST YEAR'S SALES} > {?SalesTarget} Then
Red
Else
Black
Now, when you refresh the data, the program will prompt you for the value that triggers the color flag
(known as the threshold value). It then runs the report and flags all the customers that had sales last
year above the threshold figure. You can change the figure each time you run the report and the program
will flag a different set of Customer Names.
For more information see "Conditional formatting functions" in the online help.
2012-03-14480
Parameter Fields and Prompts
Page view 479
1 2 ... 475 476 477 478 479 480 481 482 483 484 485 ... 717 718

Comments to this Manuals

Edwinfet 29 Feb 2024 | 09:13:09

What are the upsides of contracting skilled web optimization organizations? Expert search marketing companies utilize teams of experts focused on elevating your site's content for browsing engines. This encompasses researchingsearch phrases, adjusting on site characteristics, and managing off-domain enhancements. Moreover, these firms monitor adjustment in from Google parameters and refresh the text on your website as needed. This saves both you your time and your workers from unwanted a

KarenSkaky 17 Apr 2024 | 12:11:41

Securing the security of your home is essential in today's unsettled times. Among the best ways to safeguard your belongings and peace of mind is by committing in a trustworthy safe. Regardless of whether you're securing money, important documents, or precious heirlooms, a safe gives a protected repository solution. Regarding selecting the right safe for your house, there are several elements to consider. Above all, assess your safety requirements. Determine what items you plan to store in

Helenlal 18 Apr 2024 | 10:19:10

Arranging an open-air wedding in Phenix and anxious about the unpredictable weather? Don't let Mother Nature rain on your parade – truly! At [Event Rentals Phoenix], we provide stunning wedding tent rentals that will ensure your distinctive day goes off without an hitch. Our wedding tent rentals are created to supply both charm and functionality. Say "I do" under tha elegant canopy of one of our tents, surrounded by your loved ones and tha breathtaking scenery of Pheonix. With one assortmen

Helenlal 29 Apr 2024 | 07:23:21

In both personal and professional situations, encountering issues is unavoidable. However, mastering productive trouble-shooting techniques is key for triumphing over hurdles and accomplishing success. In this piece, we delve into the strategies and methods for efficiently addressing dilemmas. From analytical thinking to creative brainstorming, we look into various approaches that can help individuals tackle challenges with certainty and accuracy. Effective challenge solving begins wit

Chrisnug 29 Apr 2024 | 16:39:54

Hello, im noob :)