Home > BaaN, Infor > Bringing colors to #Baan #Reports in Display browser #in

Bringing colors to #Baan #Reports in Display browser #in


“Can I get a color indicator on my Baan reports, its difficult for me to analyse huge data ?”, well that was one of my user at client site, very eager to know whether its possible. He had complaints about Baan Consultants, always turning off when it comes to colors in Baan.

Genuine!! his requirement was very much genuine. When there is so much hype in analytics, with tons of BI products coming up with beautiful visual reports, why is Baan lagging so behind and can’t even get some colors in its display browser ?

Well thats not true, Baan can show colorful reports. Haa!! I agree that the display browser is not so funky like genx reporting tools, but its not limited to black & white.

Surprised!! not many have used fg$

Here is what help says:

string fg$( long color )
Use this to set the foreground color of text, starting at the current cursor position.

The color argument can have the following values:
CW.BLACK CW.BLUE CW.GREEN CW.CYAN
CW.RED CW.MAGENTA CW.YELLOW CW.WHITE

It worked for me, my user was happy to see colors in their black & white reports

All you need to do is, add a variable of type string with length 2 in the report layout and assign the desired color conditionally. Whatever part you wanna display in desired color, simply enclose the part within this variable.

declaration:
	extern	domain	tcmcs.str2	color.strip

before.program:
	color.strip = fg$(CW.WHITE)

detail.1:
before.layout:
color.strip = " "
color.strip = fg$(CW.WHITE)
if VALID_PUR_PRICE then
	color.strip = fg$(CW.RED)
else
	color.strip = fg$(CW.GREEN)
endif

If there not a need for a color indicator conditionally, then there is even more simpler solution.

Here’s the report screenshot

Now my clients have intelligent demands :-), instead of colored text now they want highlights, well that simple too. Tick the reverse option.

Alternatively you can use bg$() for highlights
Lets see what help says about bg$()

string bg$( long color )

Use this to set the background color of the current window. The color argument can have the following values:

CW.BLACK CW.BLUE CW.GREEN CW.CYAN
CW.RED CW.MAGENTA CW.YELLOW CW.WHITE

Advertisements
Categories: BaaN, Infor Tags: ,
  1. January 24, 2013 at 12:49 pm

    “Bringing colors to #Baan #Reports in Display browser #in Techbuzz” was a relatively nice blog,
    . Continue writing and I’m going to continue browsing! Thanks -Lavonne

    • vamsi
      April 24, 2013 at 8:34 pm

      quite usefull

  1. No trackbacks yet.

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

%d bloggers like this: