Color based on the line number

[jcao0000]

In a report, I need to specify the color of the line based on the line number. For example, Line 1,3,5... to be white background and Line 2,4,6... to be gray background. How can I do it?

Thanks in advance for the help!

 

[AndyMc]

lbass posted a solution in this thread:

http://www.tek-tips.com/viewthread.cfm?qid=1400693&page=1

 

[jcao0000]

Thanks, it works.

However, currently i specified the order of the group.
For example:
(Old)
Department A
Department B
Department C
Department D
The formula works fine

(Now)
Department A + Department C
Department D
Department B

The background color formula doesn't work any more.

Any other way I can fix it?

Thanks

 

[lbass]

The solution in that thread is based on the detail section, not group sections. Since you can't use specified order to "put" two groups in one section, did you use a formula like:

if {table.dept} in ["A","C"] then "A+C" else
{table.dept}

???
First try substituting groupnumber for recordnumber in the formula. If that doesn't meet your needs, please tell us a little more about your report.

-LB

 

[jcao0000]

It works... thanks!!!

 

[jcao0000]

Another question, can I set the color for rows in a cross tab? Thanks in advance for the help?

 

[lbass]

Please start a new thread and clarify what you want to do--alternate color? Or? Also specify your row, column and summary fields.

-LB