I have a .qvw containing a graph (straigh table) with the total displayed as last row.
Is there a way for the user to export data to excel excluding the totals?
What you send to excel is all the data that graphic have in the moment, what you can do is to remove the totals before its sent and put it back after, maybe with a macro or a trigger..
The only way I have found to do this is by:
right clicking on the table,
- Copy to clipboard
- Table Data Area
Unfortunately, this also excludes the column headers too.
Retrieving data ...