How to alternately display colored records ...

[msng]

In my Crystal report, I need to show the alternate line displayed in yellow color. How can I do it? Also, I am suppressing some lines in my report if a given record has the same id as the previous record.

Please help.

 

[synapsevampire]

I would eliminate the rows in the report rather than suppressing them, but you've not shared enough information to assist you properly with that, Generally a one line request for help is a waste of time, please post technical information:

Crystal version
Database/connectivity used
Example data
Expected output

Here's the whitepaper on the topic:

http://support.businessobjects.com/library/kbase/articles/c2014182.asp

I would suggest that you eliminate to rows as well, because otehrwise you're going to have to include that kludge into the alternating color logic.

In general if you have multiple rows with the same ID's, and you group by the ID, you can use something like:

Report->Selection Formulas->Group

{table.date} = maximum({table.date},{table.id})

This would limit the rows to the maximum date of that id.

-k