Wednesday, March 21, 2012

Export - Excel Error

Hi All,
i am not able to export the report as excel. it showing the below
error:
i am using the MSRS2000. i have installed microsoft office excel 2003.
Microsoft Office Excel File Repair Log
Errors were detected in file 'C:\Documents and
Settings\vinod_banagani\Desktop\AppointmentLog.xls'
The following is a list of repairs:
Damage to the file was so extensive that repairs were not possible.
Excel attempted to recover your formulas and values, but some data may
have been lost or corrupted.
is RS2000 supports Excel 2000 only?
if anyone have faced this problem earlier, please tell me the solution.
Thanks in advance for your help...Thanks for your response Bruce.
i have upgraded SP2.
When I select the export to excel file format, I get the following in
the
excel file: "Data Regions within table/matrix cells are
ignored".
i am using tables and rectangles inside the table... and texboxes
inside the rectangle in my report. the report is showing perfectly but
when i select the export to excel file, it is throwing an error.
Is this a known bug in RS..
Any info will be appreciated.
Thanks,
Vinod
vinodsh_82@.hotmail.com wrote:
> Hi All,
>
> i am not able to export the report as excel. it showing the below
> error:
>
> i am using the MSRS2000. i have installed microsoft office excel 2003.
>
> Microsoft Office Excel File Repair Log
>
> Errors were detected in file 'C:\Documents and
> Settings\vinod_banagani\Desktop\AppointmentLog.xls'
> The following is a list of repairs:
>
> Damage to the file was so extensive that repairs were not possible.
> Excel attempted to recover your formulas and values, but some data may
> have been lost or corrupted.
>
> is RS2000 supports Excel 2000 only?
>
> if anyone have faced this problem earlier, please tell me the solution.
>
> Thanks in advance for your help...|||Well, at least you got a better error message. It sounds like whatever
combination of tables, rectangles, tables within tables etc causes a
problem.
I don't know if 2005 would work better or not.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<vinodsh_82@.hotmail.com> wrote in message
news:1147799266.536977.43720@.v46g2000cwv.googlegroups.com...
> Thanks for your response Bruce.
> i have upgraded SP2.
> When I select the export to excel file format, I get the following in
> the
> excel file: "Data Regions within table/matrix cells are
> ignored".
> i am using tables and rectangles inside the table... and texboxes
> inside the rectangle in my report. the report is showing perfectly but
> when i select the export to excel file, it is throwing an error.
> Is this a known bug in RS..
> Any info will be appreciated.
> Thanks,
> Vinod
>
> vinodsh_82@.hotmail.com wrote:
>> Hi All,
>>
>> i am not able to export the report as excel. it showing the below
>> error:
>>
>> i am using the MSRS2000. i have installed microsoft office excel 2003.
>>
>> Microsoft Office Excel File Repair Log
>>
>> Errors were detected in file 'C:\Documents and
>> Settings\vinod_banagani\Desktop\AppointmentLog.xls'
>> The following is a list of repairs:
>>
>> Damage to the file was so extensive that repairs were not possible.
>> Excel attempted to recover your formulas and values, but some data may
>> have been lost or corrupted.
>>
>> is RS2000 supports Excel 2000 only?
>>
>> if anyone have faced this problem earlier, please tell me the solution.
>>
>> Thanks in advance for your help...
>|||Hi Vinod. It sounds like you are using a sub-report. Sub-reports are not
exported in the Excel rendering extension in RS2000 or RS2005. MHTML and
PDF rendering extensions do support sub-reports.
-Tim
<vinodsh_82@.hotmail.com> wrote in message
news:1147799266.536977.43720@.v46g2000cwv.googlegroups.com...
> Thanks for your response Bruce.
> i have upgraded SP2.
> When I select the export to excel file format, I get the following in
> the
> excel file: "Data Regions within table/matrix cells are
> ignored".
> i am using tables and rectangles inside the table... and texboxes
> inside the rectangle in my report. the report is showing perfectly but
> when i select the export to excel file, it is throwing an error.
> Is this a known bug in RS..
> Any info will be appreciated.
> Thanks,
> Vinod
>
> vinodsh_82@.hotmail.com wrote:
>> Hi All,
>>
>> i am not able to export the report as excel. it showing the below
>> error:
>>
>> i am using the MSRS2000. i have installed microsoft office excel 2003.
>>
>> Microsoft Office Excel File Repair Log
>>
>> Errors were detected in file 'C:\Documents and
>> Settings\vinod_banagani\Desktop\AppointmentLog.xls'
>> The following is a list of repairs:
>>
>> Damage to the file was so extensive that repairs were not possible.
>> Excel attempted to recover your formulas and values, but some data may
>> have been lost or corrupted.
>>
>> is RS2000 supports Excel 2000 only?
>>
>> if anyone have faced this problem earlier, please tell me the solution.
>>
>> Thanks in advance for your help...
>

No comments:

Post a Comment