Thanks Larry. I will present it to the boss today.
I learn new things all the time. James Belisle Making Information Systems People Friendly Since 1990 ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Lawrence Lustig Sent: Monday, January 23, 2012 8:35 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Variable Listview << SELECT (LISTOF(DISTINCT partnum)) INTO vnprt INDICATOR ivnprt + FROM inv_all_open WHERE availpcs < 0 How do I limit the row color to just the negative rows? >> Here's how: 1. Make sure the relation feeding the Listview is a view, not a table. (I'm assuming from the name inv_all_open that's already true). 2. Add a calculate column to the view that spits out the color you want. For instance: CREATE VIEW inv_all_open (. . ., FontColor) AS + SELECT . . ., (IFLT(availpcs, 0, 'RED', 'BLACK')) 3. On the Properties screen for the ListView, go to the Lookup Settings page. Find the last item on that page, Row Font Color Field. In the drop down, choose the new field you added to the view (in the example, FontColor). Voila! Note that where I used 'RED' and 'BLACK', you can use any of the formats in which R:Base understands colors including RGB to produce any color that the system is capable of displaying. -- Larry
