Change a SQl comment into a Formulla

[Sahubba]

Does any one know how can I do this Sql Statement as a formulla?

row_number() over (partition by pat_enc_csn_id, Event_Display_Name order by event_time) as rownum

Thanks

 

[IanWaterman]

My Oracle SQl is not that good.

What does it do in laymans terms, there might be a similar function in Crystal possibly Previous() or Next().

Ian

 

[Sahubba]

Hello Ian,

it basicly gives me the first time of the event display name.

I tried to use the previous or next and it did not work because my issues are within a group.

Thanks for responding.

 

[IanWaterman]

Add a new group based on display name field.

Sort you data in data time ascending, then move all you data from detail into Group header and suppress details and new group footer.

Ian

 

[Sahubba]

I wish it was that easily,
unfortunately if I do that the report won’t be right.
But thank you!