Exporting to Excel

Hello,
I have got problem exporting a Report to Excel.
I am using SQL Server 2000 Reporting Services Evaluation Edition.
I have tried the same by programming Reporting Services : URL
Access(Specifying rs:Format=EXCEL. But it too doesnot resolve the issue.
Pls help me resolving this.
Thanks,
Rahul.What is the problem you are having?
Please send the exact error you get..
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''''s
community of SQL Professionals.
"Rahul Behal" wrote:
> Hello,
> I have got problem exporting a Report to Excel.
> I am using SQL Server 2000 Reporting Services Evaluation Edition.
> I have tried the same by programming Reporting Services : URL
> Access(Specifying rs:Format=EXCEL. But it too doesnot resolve the issue.
> Pls help me resolving this.
> Thanks,
> Rahul.|||Hello Wayne,
Actually, from the UI, there was no problem saving...it was asking me the
path....saving the data......able to open up the file........but all the
data was junk
My data was like :
Column1 Column2
Val11 Val21
Val12 Val22
but all was coming as junk.........not actually able to understand.......
I was opening that excel file in Excel 2000....where it was coming as junk
characters......
I happened to open that file on excel 2002......it all came in shape....so
the problem was resolved.
So now the problem remains : SQL server reporting services save the data in
format for Excel 2002 onwards on windows 2000 professional...What if I want
to get it saved in format of Excel for Excel 2000 or anything else.....
I hope you understand the problem.
Thanks,
Rahul.
rahul.behal@.india.techspan.com
"Wayne Snyder" wrote:
> What is the problem you are having?
> Please send the exact error you get..
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''''s
> community of SQL Professionals.
>
> "Rahul Behal" wrote:
> > Hello,
> > I have got problem exporting a Report to Excel.
> > I am using SQL Server 2000 Reporting Services Evaluation Edition.
> > I have tried the same by programming Reporting Services : URL
> > Access(Specifying rs:Format=EXCEL. But it too doesnot resolve the issue.
> > Pls help me resolving this.
> >
> > Thanks,
> > Rahul.|||You need to install SP1 or SP2. The initial release of RS did not support
Excel 2000.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rahul Behal" <RahulBehal@.discussions.microsoft.com> wrote in message
news:3163A1FA-EBEA-4D2A-BAA4-D5C51B931E50@.microsoft.com...
> Hello Wayne,
> Actually, from the UI, there was no problem saving...it was asking me the
> path....saving the data......able to open up the file........but all
> the
> data was junk
> My data was like :
> Column1 Column2
> Val11 Val21
> Val12 Val22
> but all was coming as junk.........not actually able to
> understand.......
> I was opening that excel file in Excel 2000....where it was coming as
> junk
> characters......
> I happened to open that file on excel 2002......it all came in
> shape....so
> the problem was resolved.
> So now the problem remains : SQL server reporting services save the data
> in
> format for Excel 2002 onwards on windows 2000 professional...What if I
> want
> to get it saved in format of Excel for Excel 2000 or anything else.....
> I hope you understand the problem.
> Thanks,
> Rahul.
> rahul.behal@.india.techspan.com
>
> "Wayne Snyder" wrote:
>> What is the problem you are having?
>> Please send the exact error you get..
>> --
>> Wayne Snyder MCDBA, SQL Server MVP
>> Mariner, Charlotte, NC
>> I support the Professional Association for SQL Server ( PASS) and it''''s
>> community of SQL Professionals.
>>
>> "Rahul Behal" wrote:
>> > Hello,
>> > I have got problem exporting a Report to Excel.
>> > I am using SQL Server 2000 Reporting Services Evaluation Edition.
>> > I have tried the same by programming Reporting Services : URL
>> > Access(Specifying rs:Format=EXCEL. But it too doesnot resolve the
>> > issue.
>> > Pls help me resolving this.
>> >
>> > Thanks,
>> > Rahul.|||RS supports rendering format which takes you back to Excel 97...
Unless you are using some strange formulas, or exceeding an excel limit, I
do not have a clue....
My suggestion would be to reduce your problem to the simplest form, keep
eliminating things and testing until you get to the place where it works...
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and
it''''s
community of SQL Professionals.
"Rahul Behal" wrote:
> Hello Wayne,
> Actually, from the UI, there was no problem saving...it was asking me the
> path....saving the data......able to open up the file........but all the
> data was junk
> My data was like :
> Column1 Column2
> Val11 Val21
> Val12 Val22
> but all was coming as junk.........not actually able to understand.......
> I was opening that excel file in Excel 2000....where it was coming as junk
> characters......
> I happened to open that file on excel 2002......it all came in shape....so
> the problem was resolved.
> So now the problem remains : SQL server reporting services save the data in
> format for Excel 2002 onwards on windows 2000 professional...What if I want
> to get it saved in format of Excel for Excel 2000 or anything else.....
> I hope you understand the problem.
> Thanks,
> Rahul.
> rahul.behal@.india.techspan.com
>
> "Wayne Snyder" wrote:
> > What is the problem you are having?
> > Please send the exact error you get..
> > --
> > Wayne Snyder MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> >
> > I support the Professional Association for SQL Server ( PASS) and it''''s
> > community of SQL Professionals.
> >
> >
> > "Rahul Behal" wrote:
> >
> > > Hello,
> > > I have got problem exporting a Report to Excel.
> > > I am using SQL Server 2000 Reporting Services Evaluation Edition.
> > > I have tried the same by programming Reporting Services : URL
> > > Access(Specifying rs:Format=EXCEL. But it too doesnot resolve the issue.
> > > Pls help me resolving this.
> > >
> > > Thanks,
> > > Rahul.