Problem of "Export to Excel" for "Chart" within "Matrix"

Hi
Please help to fix the following problem.
I design a report using a matrix to show the Sales data. Within the matrix,
I want to use a Bar Chart to show some the data.
Preview and Export to pdf format is ok and does not have any problem.
However, I get the error message "Specified Cast is not Valid" when I try to
export to Excel. How can I fix it, please help!
Thank You
TonyI have The same problem but with a table on report.
Anybody knows what is causing it?
"Tony" wrote:
> Hi
> Please help to fix the following problem.
> I design a report using a matrix to show the Sales data. Within the matrix,
> I want to use a Bar Chart to show some the data.
> Preview and Export to pdf format is ok and does not have any problem.
> However, I get the error message "Specified Cast is not Valid" when I try to
> export to Excel. How can I fix it, please help!
> Thank You
> Tony