Skip to Content
Former Member
Nov 09, 2015 at 05:46 AM

Unablw to apply rank () over function for universe based crystal report?


Dear Experts,

I have a requirement to apply rank () over function. My Crystal report is based on universe. I have created an object in universe however SQL generated in crystal report contains rank () over in SELECT clause as well GROUP BY clause. Due to GROUP BY clause it throws an error I would like to remove it. However I am unable to edit my SQL generated from universe in SAP Crystal report 2013.

Any suggestion how to achieve that?