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?