Conditional Displaying

[sudhach]

Hi all,

I am using Crystal reports XI R1 . Here is the problem, I have an integer field (x), i need to display three more fields (a,b,c) based on that integer field (x) when it is maximum.

for example
when max(x) then i need to display the corresponding records of a, b, and c.

Any help would be greatly appreciated.

Thanks in advance
Sudharsan.

[Madhi]

What is the database?
I think you need to write the query

Select * from table
where x=(select max(x) from table)

and design the report using that query