Using EVALUATE function to display Duplicate results in the report.

If you ever get a requirement to dispay duplicate values for a report that has aggregation on one column, you can use the EVALUATE(‘rownum’ AS INTEGER ) function.  In order to achieve this functionality add a new column, and hide that column ( if needed ).  By doing this you can display the duplicated values as well.  There might be one error that you might occur during this:


State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 46030] Field descriptor id 0 is beyond the maximum field count 0. (HY000)

If you get this error uncheck the pref_internal_switch_join feature in the DB features in the physical layer.