Profile

Would ROW_NUMBER() OVER (PARTITION BY ORDER BY id>) work if you have something like customer id number?

Thank you Petr for your reply and your consideration that is appreciated.  I am not certain what flavor of DB is being used I believe it is some variation of Apache Hive SQL.  The JDBC that was provided to me I believe is a custom driver developed by the software vendor Qualifacts.  So are you thinking ...

I am new to this community and to Pentaho Report Designer 9.3 but I have been using PRD since 5.x I am currently on 6.1 preparing to migrate to 9.3 or 10.x I am using PRD as a supplement to our EHR system CareLogic (developed and maintained by Qualifacts+Credible) designing customized reports Has ...