07-27-2020 09:53 AM
We're on version 18.0.1.49
I have a report based on a custom SQL data provider that my customer would like to see a row count total when the results are displayed.
Is there a way to do this?
I know I can do a group by and put a group summary count in, but that still doesn't give the user a total count, they have to add the group totals.
I was also thinking of doing a dashboard with a text box at the bottom, but the grid control loses the ability (at least as far as I can tell) to do ad-hoc groupings and control of the results like you can if it's a report.
07-28-2020 11:09 AM
not sure how efficient this is, but I have been adding this as the first row to get around this...
SELECT ROW_NUMBER() OVER(Order By "field name from your actual query") as Row, *
FROM
(your actual query) as Z
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.