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
[quoted text, click to view] 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
[quoted text, click to view] <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
[quoted text, click to view] <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...
>
