Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
shading alternating rows in BO? 1
- Thread starter smooveb
- Start date
-
1
- #2
This tip is on the BO public site.
Set column background color
1. Select all the body cells in the table columns.
2. Set the background color to pale blue..
Create a local variable
1. Right-click on the Report Manager Data tab and choose New Variable from the menu.
The Variable Editor is displayed.
2. On the Definition tab type Row band in the Name box and in the Qualification section, choose Measure.
3. On the Formula tab, type the following syntax in the Formulas tab:
=Mod(LineNumber(),2)
4. Click OK.
The variable, Row band, is displayed in the list in the report Manager Data tab.
Create an alerter
1. Click in anywhere in the table and click the Alerters button on the Report toolbar.
The Alerters dialog box is displayed.
2. Click Add.
The Edit Alerters dialog box is displayed.
3. On the Definition tab, type in the name, Alternate Row Shading, and add a description.
4. On the conditions tab, set the following conditions:
Set the Variable to Compare to Row band.
In the Operator 1 Box, choose =.
In the Value box, choose 1.
In the Result box, click on the arrow and choose Format from the menu.
In the Cell Format dialog box, click the Shading tab and set the Foreground and Background color to white and click OK.
zoom in
5. Click OK to close the Edit Alerters box.
The Alternate Row Shading alerter is added to the list in the Alerters box.
6. Click OK to close the Alerters box.
Use the alerter in the table
1. Select all the columns in the table and click the Alerters button on the Report toolbar.
2. Check the box next to Alternate Row Shading to turn the alerter on and click OK.
Every other row in the table is shaded white.
For more information on creating alerters and local variables, see the BusinessObjects User's Guide.
Note: If you want to regularly use this table style, include the Alternate Row Shading alerter in a template.
Steve Krandel
BASE Consulting Group
Set column background color
1. Select all the body cells in the table columns.
2. Set the background color to pale blue..
Create a local variable
1. Right-click on the Report Manager Data tab and choose New Variable from the menu.
The Variable Editor is displayed.
2. On the Definition tab type Row band in the Name box and in the Qualification section, choose Measure.
3. On the Formula tab, type the following syntax in the Formulas tab:
=Mod(LineNumber(),2)
4. Click OK.
The variable, Row band, is displayed in the list in the report Manager Data tab.
Create an alerter
1. Click in anywhere in the table and click the Alerters button on the Report toolbar.
The Alerters dialog box is displayed.
2. Click Add.
The Edit Alerters dialog box is displayed.
3. On the Definition tab, type in the name, Alternate Row Shading, and add a description.
4. On the conditions tab, set the following conditions:
Set the Variable to Compare to Row band.
In the Operator 1 Box, choose =.
In the Value box, choose 1.
In the Result box, click on the arrow and choose Format from the menu.
In the Cell Format dialog box, click the Shading tab and set the Foreground and Background color to white and click OK.
zoom in
5. Click OK to close the Edit Alerters box.
The Alternate Row Shading alerter is added to the list in the Alerters box.
6. Click OK to close the Alerters box.
Use the alerter in the table
1. Select all the columns in the table and click the Alerters button on the Report toolbar.
2. Check the box next to Alternate Row Shading to turn the alerter on and click OK.
Every other row in the table is shaded white.
For more information on creating alerters and local variables, see the BusinessObjects User's Guide.
Note: If you want to regularly use this table style, include the Alternate Row Shading alerter in a template.
Steve Krandel
BASE Consulting Group
- Status
Similar threads
- Locked
- Question
- Locked
- Question