export to excel, exclude totals

[#1]

Hi All,

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?

many thanks

Martina

[#2]

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..

[ngulliver]

Hi, Martina.

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.

Regards,

Neil