sql - How to write ROW_NUMBER in Crystal Reports? -

i wondering if can use row_number in formula in crystal reports? here part code wrote in ssms sql.

 row_number() on (partition bedside_ua_csn order ua_time) "session_number" 

any valid sql can used in crystal reports. there 2 ways can use.

first way can directly use add commnad while creating database connection.

second way can write in sql expression fields inside reports in way need enclose sql inside ()