Errors exporting to excel

Report works fine in HTML and exporting to PDF but when exporting to excel and opening the file we receive a notification that errors were detected and a repair was attempted. The repair notification states that the damage to the file was too extensive to repair and the file can be opened with only the raw tabular data (no formatting or charts).
This only happens with certain parameter values?
--
Message posted via http://www.sqlmonster.comThere are a couple of fixes out there for Excel. Take a look at
Microsoft.com for Excel\Reporting services issues.
If you have a good repro I can do in house, please send it to me.
--
| From: "William Nichols via SQLMonster.com" <forum@.SQLMonster.com>
| Subject: Errors exporting to excel
| Date: Fri, 28 Jan 2005 13:07:35 GMT
| Organization: http://www.SQLMonster.com
| Message-ID: <b4e260ddb47c48b7bf16a89e152b3412@.SQLMonster.com>
| X-Abuse-Report: http://www.SQLMonster.com/Uwe/NB/Abuse.aspx
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 178.67-18-207.reverse.theplanet.com 67.18.207.178
| Lines: 1
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXS01.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08
.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:41174
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Report works fine in HTML and exporting to PDF but when exporting to
excel and opening the file we receive a notification that errors were
detected and a repair was attempted. The repair notification states that
the damage to the file was too extensive to repair and the file can be
opened with only the raw tabular data (no formatting or charts).
|
| This only happens with certain parameter values?
|
| --
| Message posted via http://www.sqlmonster.com
||||I've got the same problem!
I turned off the legend on the chart, and now it works perfectly!
Any ideas'
Try turning off the legend and let me know if that worked.
- Joel
"William Nichols via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:b4e260ddb47c48b7bf16a89e152b3412@.SQLMonster.com...
> Report works fine in HTML and exporting to PDF but when exporting to excel
> and opening the file we receive a notification that errors were detected
> and a repair was attempted. The repair notification states that the
> damage to the file was too extensive to repair and the file can be opened
> with only the raw tabular data (no formatting or charts).
> This only happens with certain parameter values?
> --
> Message posted via http://www.sqlmonster.com

Error: Subreport could not be shown.

Does anyone have an idea what would cause this error when viewing this in
Report Manager or thru a subscription to be rendered as a PDF attachment?
Subreports view fine through Visual Studio .NET Report project.
Thanks in advance.whats the error u r getting?
"Microsoft PrivateNews" <Dave.Troyer@.cliftoncpa.com> wrote in message news:<uRRh35dwEHA.1524@.TK2MSFTNGP09.phx.gbl>...
> Does anyone have an idea what would cause this error when viewing this in
> Report Manager or thru a subscription to be rendered as a PDF attachment?
> Subreports view fine through Visual Studio .NET Report project.
> Thanks in advance.|||I figured out the problem. In report manager, the error displayed was
'Error: Subreport could not be shown.' What happen was when I uploaded the
reports thru report manager and then change the name of the reports in
report manager. The subreport could not be found that was specified
originally.
Thanks for replying.
"Amit Bhandari" <abhandari2004@.gmail.com> wrote in message
news:c3d1e67b.0411041027.63b0acf4@.posting.google.com...
> whats the error u r getting?
>
> "Microsoft PrivateNews" <Dave.Troyer@.cliftoncpa.com> wrote in message
> news:<uRRh35dwEHA.1524@.TK2MSFTNGP09.phx.gbl>...
>> Does anyone have an idea what would cause this error when viewing this in
>> Report Manager or thru a subscription to be rendered as a PDF attachment?
>> Subreports view fine through Visual Studio .NET Report project.
>> Thanks in advance.