logo
small logo
  • Products
  • Buy
  • Support
  • Articles
  • Customer panel Support
    • en
    • ru
    • pt
    • es
    • de
    • pl
    • JP
    • ZH
  • Home
  • /
  • Articles
  • /
  • How to highlight data by condition in FastReport .Net
  • How to use Plugin Manager

    September 3, 2019

    FastReport.Net provides a plugin mechanism for extending the functionality of the report designer. Most of

    read more
  • How to connect to Firebird from FastReport.Net

    November 15, 2019

    In order to connect to Firebird database in FastReport.Net Designer a plug-in connector is provided. It

    read more
  • How to hide columns in a list if there is no data

    April 7, 2020

    When making the report, we want it to be "friendly" to the consumers as much

    read more
  • How to create a sales receipt from a WinForms application

    May 30, 2020

    Most likely every .Net developer started from Windows Forms applications. Countless number of such applications

    read more
  • PreviewControl.OnPrint and PreviewControl.OnExport Events

    October 1, 2020

    In FastReport 2019.4 added the ability to subscribe to PreviewControl.OnPrint and PreviewControl.OnExport events, which are

    read more

How to highlight data by condition in FastReport .Net

February 10, 2016

There are times when you need to highlight some of the data when analyzing tables.

Usually, when we review a paper version of the document, we highlight a data using a marker.

But why not do it at once, during the formation of the table?

FastReport .Net allows you to highlight the data depending on the specified conditions. A striking example of the use of conditional highlighting - the statistical data in the summary tables (matrices).

Let's create a matrix report. We use the data from the database nwind.xml, which is used in the demo reports of FastReport .Net. Use the table MatrixDemo.

The result here is a simple template:

If you run the report, we can see the dry statistics on the profitability of the company, brought by employees for months. But let's say we want to highlight cells with a yield of more than 3000r per month.

Select the cell [Revenue]. On the toolbar, click the icon:

In the next window you can set conditions for the highlighting and style of text or background.

Add Condition Value> 3000. Color can be a gradient or "glass".

You can add any number of conditions for the same object. Add another one: Value> 1000.

Since we have two conditions, it is necessary to take into account their order. If you move up the second condition, the cell with a value > 1000 will be yellow, as well as the value > 3000. This will happen because FastReport .Net handles the conditions in the order. Since the condition Value> 1000 covers the values > 3000, the second condition would not apply. Keep this in mind when using multiple conditions for a single object. Now let's see the result of our efforts:

If you want to highlight the columns Total, will have to add the same conditions for the cells in this column.

So, by simple manipulations we get a summary table that does not require further analysis with marker in hand.

about product download buy
avatar
Dmitriy Fedyashov
Head of QA
.NET FastReport

Add comment
logo
  • 800-985-8986 (English, US)
  • +4930568373928 (German)
  • +55 19 98147-8148 (Portuguese)
  • info@fast-report.com
  • 901 N Pitt Str #325 Alexandria VA 22314
  • Buy
  • Download
  • Documentation
  • Testimonials
  • How to uninstall
  • Ticket system
  • FAQ
  • Tutorial Video
  • Forum
  • Articles
  • Our News
  • Press about us
  • Resellers
  • Our team
  • Contact us

© 1998-2021 by Fast Reports Inc.

  • Privacy Policy