Tuesday, March 27, 2012

Excel Export Garbeled

When I export to excel... the reprot is garbeled 100% of the time... even
with sample reports. My client is using Excel 2000. Is that a problem?You need to go to SP1 for Excel 2000 support.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RS_Girl" <RS_Girl@.discussions.microsoft.com> wrote in message
news:BC31853D-8780-47C1-900A-7565E6A566EC@.microsoft.com...
> When I export to excel... the reprot is garbeled 100% of the time... even
> with sample reports. My client is using Excel 2000. Is that a problem?|||? Sorry ... I don't understand... are you saying that I need to install SP1
on my server?
"Bruce L-C [MVP]" wrote:
> You need to go to SP1 for Excel 2000 support.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "RS_Girl" <RS_Girl@.discussions.microsoft.com> wrote in message
> news:BC31853D-8780-47C1-900A-7565E6A566EC@.microsoft.com...
> > When I export to excel... the reprot is garbeled 100% of the time... even
> > with sample reports. My client is using Excel 2000. Is that a problem?
>
>|||You will need to install Reporting Services SP1 wherever you currently have
it installed.
http://www.microsoft.com/downloads/details.aspx?FamilyId=580FEBF7-2972-40E7-BCCF-6CD90AC2F464&displaylang=en
Adrian M.
"RS-Girl" <RSGirl@.discussions.microsoft.com> wrote in message
news:1123B2C0-6D15-4EF0-A78B-EE2130AA640B@.microsoft.com...
> ? Sorry ... I don't understand... are you saying that I need to install
> SP1
> on my server?
> "Bruce L-C [MVP]" wrote:
>> You need to go to SP1 for Excel 2000 support.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "RS_Girl" <RS_Girl@.discussions.microsoft.com> wrote in message
>> news:BC31853D-8780-47C1-900A-7565E6A566EC@.microsoft.com...
>> > When I export to excel... the reprot is garbeled 100% of the time...
>> > even
>> > with sample reports. My client is using Excel 2000. Is that a
>> > problem?
>>|||Reporting Services has a service pack (SP1). This service pack changed how
the Excel export worked. Previously it only support Excel 2003, not Excel
2000 and Excel 97. This service pack is for both the server and for the
client tools. It also has some fixes particularly in the area of PDF
rendering.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RS-Girl" <RSGirl@.discussions.microsoft.com> wrote in message
news:1123B2C0-6D15-4EF0-A78B-EE2130AA640B@.microsoft.com...
> ? Sorry ... I don't understand... are you saying that I need to install
SP1
> on my server?
> "Bruce L-C [MVP]" wrote:
> > You need to go to SP1 for Excel 2000 support.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "RS_Girl" <RS_Girl@.discussions.microsoft.com> wrote in message
> > news:BC31853D-8780-47C1-900A-7565E6A566EC@.microsoft.com...
> > > When I export to excel... the reprot is garbeled 100% of the time...
even
> > > with sample reports. My client is using Excel 2000. Is that a
problem?
> >
> >
> >|||Hi Bruce,
Even I am also facing same work. some times Excel data is matching with
actual data and some times not.
I have WIn2k server Office 2k3 and SQL REporting Service Pack 1.
Can you pls give me inputs for the same.
"Bruce L-C [MVP]" wrote:
> Reporting Services has a service pack (SP1). This service pack changed how
> the Excel export worked. Previously it only support Excel 2003, not Excel
> 2000 and Excel 97. This service pack is for both the server and for the
> client tools. It also has some fixes particularly in the area of PDF
> rendering.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "RS-Girl" <RSGirl@.discussions.microsoft.com> wrote in message
> news:1123B2C0-6D15-4EF0-A78B-EE2130AA640B@.microsoft.com...
> > ? Sorry ... I don't understand... are you saying that I need to install
> SP1
> > on my server?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > You need to go to SP1 for Excel 2000 support.
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "RS_Girl" <RS_Girl@.discussions.microsoft.com> wrote in message
> > > news:BC31853D-8780-47C1-900A-7565E6A566EC@.microsoft.com...
> > > > When I export to excel... the reprot is garbeled 100% of the time...
> even
> > > > with sample reports. My client is using Excel 2000. Is that a
> problem?
> > >
> > >
> > >
>
>sql

No comments:

Post a Comment