is there a way to show a total row count on a report?

[Kirk_Sumpter]

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.

[Thomas_Reu]

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