Rowbanding in Pentaho Reports


Problem Statement:

Applying different colors to each line in report is becoming common need these days. Pentaho Provides an inbuilt facility to Apply different colors or alternative colors to each line in the Report output using row banding.

Scope of this Article:

This article explains the usage of row banding step for alternate colors

Technology:

Pentaho Report Designer 3.5.0 GA or above

Details:

  • Create a new report that select few fields from the table.

Viewdata

  • Drag the values to details pane .
  • Select band from the palette

Viewdata

  • drag it on to the details.

Viewdata

  • Now place the band for selected values in details.
  • Goto format and select the row banding function

Viewdata

  • Then a dialog box appears  as the following

Viewdata

  • In the above screenshot I am selecting gray and light gray color as Visible and invisible color respectively.
  • You can observe the Report with alternative selected colors in below snapshot

Viewdata

Summary:-

Row banding in report designer save lot of development efforts compare to using formula option.

Walking Tree promotes Pentaho and we support the corporates as well as the developers to ensure that the business is able to take complete advantage of Pentaho’s wonderful capability. In case you are looking for a professional assistance then do visit our website to get in touch with us.

Reference:-

http://wiki.bizcubed.com.au/xwiki/bin/view/Pentaho+Tutorial/How+to+add+alternate+background

BI developer

Tagged with: , , ,
Posted in Data Warehouse & BI, Pentaho
One comment on “Rowbanding in Pentaho Reports
  1. tuhin says:

    can you suggest me the process …how i impose this (alternate color cause in cross tab report the field that use in row axis is not effected any alternate color)for cros tab report

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

We Have Moved Our Blog!

We have moved our blog to our company site. Check out https://walkingtree.tech/index.php/blog for all latest blogs.

Sencha Select Partner Sencha Training Partner
Xamarin Authorized Partner
Recent Publication
%d bloggers like this: