This content has been marked as final. Show 2 replies
Uncheck the EXPRESSION_IN_ORDERBY_SUPPORTED
under database features
Yes. that was working when i have been following the below.
1. Untick the checkbox for EXPRESSIONS_IN_ORDERBY_SUPPORTED in the features tab of the database properties in the physical layer.
2. For a single report, go to the advanced tab and select the ‘Issue an explicit distinct’ checkbox.
The 1st was enough to resolve ur isuue i think.
Actually i got the same issue n now it was resolved.