Alternate Row Shading

building reports desktopintelligence
1

how do i apply alternate row shading if i apply a break on the object.

Juhi

juhi (BOB member since 2004-11-04)

2

Create a variable,

Var=Odd(LineNumber())

Use this variable to do alerters.

KhoushikTTT :us: (BOB member since 2005-02-24)

3

Dear Juhi,
Following is the link.

http://support.businessobjects.com/tips/power_reports.asp

where you can find whatever you want.
It’s in Detail.
Hope this helps you.

Omkar Paranjpe :us: (BOB member since 2006-02-13)

4

This just gives me the alternate row shading and when i apply a break and center the value across the break it should select the altenate rows in the break no matter how many rows are there in one break. Can i Acheive this.

Juhi

juhi (BOB member since 2004-11-04)

5

can you explain with an example what you really need…Its hard to guess and would be easier if you explain your issue with an example.

Thanks
Mahipal

Mahi (BOB member since 2004-07-22)

6

It depends on the report…If you could attach the report, some one can give you better ideas… there are different ways you can achieve this…
but the basic idea remains the same:

  1. Find syntax for a variable that gives you either 1 and 0 OR “Y” and “N” for every alternative row.
  2. Insert Alerter on this variable to change the format of your cell/rows of table when the value is either 1 or “Y”

I have a report with breaks & Fold, I created a measure variable with follwoing syntax and applied the Alerter based on this variable:

=Mod(RowIndex() ,2)

thanks

multicube :india: (BOB member since 2005-09-28)

7

I am attaching a spreadsheet to further explain how i need the alternate row shading, i need by alternate event numbers.

Thanks
Juhi
Event Report.xls (13.0 KB)

juhi (BOB member since 2004-11-04)

8

Take a look at this similar discussion. That post is talking about job number, but just substitute event number in your case.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

9

Hi,

I am trying to do a alternate row shading in BO Client 6.5.

I am doing the following :

Creating a variable var_RowShade=Mod(Linenumber(), 2)

Creating an alerter as below

If var_RowShade=1 then I am doing my necessary format.

But the problem is as soon as I apply the alerter, the values for each row for var_RowShade becomes 0, and the alerter is not working.

Things are working perfectly on BO Client 5.1.7.

Can someone give any idea, if it is different in 6.5.

Regards,
Biswajit

Biswajit Sarkar :india: (BOB member since 2003-11-25)

10

Hi Biswajit,

It is a bit of a bug in 6.5. You should find that if you save your report close it and open it again it should work. Also someone thinks clicking OK instead of Apply also seems to work better. It is all discussed in the following post

irish_stan :ireland: (BOB member since 2003-05-13)