Is Excel really Excel

I have a client who uses Reporting Services for their reports. They
prefer Excel format, but what comes back doesn't seem to be a real Excel
file. It will only load in Office 2003 for the PC, everything else,
including Macs, thinks they are some XML file. For large reports,
several thousands rows that produce 52 MB files, do not load at all and
will cause desktops to crap out. What kind of Excel comes back from RS?Hi,
I think you need to install Service Pack 1 for Reporting services as it
introduces excel export for excel pre Office 2003.
Although Service Pack 2 is out now so you can just install that (it already
contains Service Pack 1).
"No One" wrote:
> I have a client who uses Reporting Services for their reports. They
> prefer Excel format, but what comes back doesn't seem to be a real Excel
> file. It will only load in Office 2003 for the PC, everything else,
> including Macs, thinks they are some XML file. For large reports,
> several thousands rows that produce 52 MB files, do not load at all and
> will cause desktops to crap out. What kind of Excel comes back from RS?
>|||Is this chosen with the same format specifier or a different one?
NH wrote:
> Hi,
> I think you need to install Service Pack 1 for Reporting services as it
> introduces excel export for excel pre Office 2003.
> Although Service Pack 2 is out now so you can just install that (it already
> contains Service Pack 1).
> "No One" wrote:
>
>>I have a client who uses Reporting Services for their reports. They
>>prefer Excel format, but what comes back doesn't seem to be a real Excel
>>file. It will only load in Office 2003 for the PC, everything else,
>>including Macs, thinks they are some XML file. For large reports,
>>several thousands rows that produce 52 MB files, do not load at all and
>>will cause desktops to crap out. What kind of Excel comes back from RS?|||I dont understand your question.
"No One" wrote:
> Is this chosen with the same format specifier or a different one?
> NH wrote:
> > Hi,
> >
> > I think you need to install Service Pack 1 for Reporting services as it
> > introduces excel export for excel pre Office 2003.
> >
> > Although Service Pack 2 is out now so you can just install that (it already
> > contains Service Pack 1).
> >
> > "No One" wrote:
> >
> >
> >>I have a client who uses Reporting Services for their reports. They
> >>prefer Excel format, but what comes back doesn't seem to be a real Excel
> >>file. It will only load in Office 2003 for the PC, everything else,
> >>including Macs, thinks they are some XML file. For large reports,
> >>several thousands rows that produce 52 MB files, do not load at all and
> >>will cause desktops to crap out. What kind of Excel comes back from RS?
> >>
>|||When you choose Excel prior to the service packs it came out in an XML
format known and supported by Excel. But, it had to be Excel 2003. With the
service pack they went to binary format of Excel which is supported by Excel
2000 and greater. When you select Excel after the service pack is applied
you will get the binary format.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"No One" <aintnoway@.blahblahblah.com> wrote in message
news:adbml2-jp9.ln1@.gandalf.grey-net.com...
> Is this chosen with the same format specifier or a different one?
> NH wrote:
>> Hi,
>> I think you need to install Service Pack 1 for Reporting services as it
>> introduces excel export for excel pre Office 2003. Although Service Pack
>> 2 is out now so you can just install that (it already contains Service
>> Pack 1).
>> "No One" wrote:
>>
>>I have a client who uses Reporting Services for their reports. They
>>prefer Excel format, but what comes back doesn't seem to be a real Excel
>>file. It will only load in Office 2003 for the PC, everything else,
>>including Macs, thinks they are some XML file. For large reports,
>>several thousands rows that produce 52 MB files, do not load at all and
>>will cause desktops to crap out. What kind of Excel comes back from RS?|||Thanks.
Is there anyway to tell if the stream returned in empty?
Bruce L-C [MVP] wrote:
> When you choose Excel prior to the service packs it came out in an XML
> format known and supported by Excel. But, it had to be Excel 2003. With the
> service pack they went to binary format of Excel which is supported by Excel
> 2000 and greater. When you select Excel after the service pack is applied
> you will get the binary format.
>|||It also works in OpenOffice. Very good.
Bruce L-C [MVP] wrote:
> When you choose Excel prior to the service packs it came out in an XML
> format known and supported by Excel. But, it had to be Excel 2003. With the
> service pack they went to binary format of Excel which is supported by Excel
> 2000 and greater. When you select Excel after the service pack is applied
> you will get the binary format.
>