Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to use formula in crystal reports 10

Hi everybody

I am using Crystal reports 10 and Oracle Server.

In my user table having follwoing data.

ID Name

1 admin

2 sys

4 admin

5 admin

6 scott

7 administrator

My requirement is largest ID of the same user name.

I need out put is

ID Name

5 admin

How to write formula in crystal report.

Thank you

Raja shekar Reddy K.

Former Member
Former Member replied

you can group by Name field.

then just create a formula to output the ID which will have the highest value.

formula:

maximum(ID, Name)

1. you need to go to format editor for that formula and check the option 'Suppress If Duplicated' (otherwise you will have redundant data on report)

2. suppress the blank section if you want.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question