Prev: HTTP Error 401.1 - Unauthorized
Next: ASP.NET Reports Web Site vs. ASP.NET Crystal Reports Web Site?
From: shaikat.das on 6 Dec 2007 20:00
Hi,

To export your query results in excel, in management studio, check
this option under query-> results to -> results to file. Then run your
query and itll ask you for a location , specify it as an excel file
and it will create a file if the file does not exist. Run your query ,
also run a dummy query by declaring a bigint variable and doing a
select . If you have updated service packs, then it has to be RS,
SQL , Excel or some rogue data. Try elimination to determine the cause
and then maybe we can look at why the crash happens.


Cheers

Shai

On Dec 6, 11:07 pm, <chrisexen...(a)newsgroups.nospam> wrote:
> Hi Wei and Shai
>
> Thanks you for the replies......
>
> We do already have the latest service pack on.
> Because the reporting services and SQL server are installed on two
> serperated servers, I have checked both file versions.
>
> The SQL Server version is :
> Product Version is 9.00.3054.00
> Product Level is SP2
> Edition is Standard Edition (64-bit)
> slqservr.exe (64-bit) File version is 2005.90.3054.0 - from HotFixbuild 3159
>
> ReportingServicesService.exe (32-bit) File version is 9.0.3054.0
>
> To answer Shai questions,
> Unfotunately the dataset returned by the stored procedure do not have two
> column with the same data type (BigInt) that I used for the table grouping.
> I only tried another column with data type Int that returned the similar
> data.
>
> We have tried to run and export the report on two client machines, one has
> Excel 2003 and one has Excel 2007.
>
> And I am trying to figuring it out how to output the results from SQL
> management studio to an excel file. :)
>
> "Wei Lu [MSFT]" <we...(a)online.microsoft.com> wrote in messagenews:xPpOT%238NIHA.5204(a)TK2MSFTNGHUB02.phx.gbl...
>
>
>
> > Hello Chris,
>
> > I would like to know whether you have applied the latest service pack of
> > SQL Server.
>
> > Please apply the service pack and let me know whether this issue resolved.
>
> > Sincerely,
>
> > Wei Lu
> > Microsoft Online Community Support
>
> > ==================================================
>
> > When responding to posts, please "Reply to Group" via your newsreader so
> > that others may learn and benefit from your issue.
>
> > ==================================================
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.- Hide quoted text -
>
> - Show quoted text -

From: chrisexentra on 7 Dec 2007 06:44
Hi Shai,

I have set the results to file in the management studio. But when I execute
the stored procedure,
the save resoults dialog does not have Excel file type for me to select in
the 'save as type'.
It only has 'Report files (*.rpt)' type!

And I think we have all the latest service pack installed for SQL server and
RS.
We have a server running 64-bit sql server 2005, another server running
32-bit 2005 reporting services along with out web application.
On the RS server machine, we do not have Excel installed, or do we needed
to?

I run and export the report on my machine which has Excel 2007 installed.

I am currently run out of options Please, please help !


<shaikat.das(a)gmail.com> wrote in message
news:b3eaf170-0e92-4224-b34b-363d92811c7b(a)d21g2000prf.googlegroups.com...
> Hi,
>
> To export your query results in excel, in management studio, check
> this option under query-> results to -> results to file. Then run your
> query and itll ask you for a location , specify it as an excel file
> and it will create a file if the file does not exist. Run your query ,
> also run a dummy query by declaring a bigint variable and doing a
> select . If you have updated service packs, then it has to be RS,
> SQL , Excel or some rogue data. Try elimination to determine the cause
> and then maybe we can look at why the crash happens.
>
>
> Cheers
>
> Shai
>
> On Dec 6, 11:07 pm, <chrisexen...(a)newsgroups.nospam> wrote:
>> Hi Wei and Shai
>>
>> Thanks you for the replies......
>>
>> We do already have the latest service pack on.
>> Because the reporting services and SQL server are installed on two
>> serperated servers, I have checked both file versions.
>>
>> The SQL Server version is :
>> Product Version is 9.00.3054.00
>> Product Level is SP2
>> Edition is Standard Edition (64-bit)
>> slqservr.exe (64-bit) File version is 2005.90.3054.0 - from HotFixbuild
>> 3159
>>
>> ReportingServicesService.exe (32-bit) File version is 9.0.3054.0
>>
>> To answer Shai questions,
>> Unfotunately the dataset returned by the stored procedure do not have two
>> column with the same data type (BigInt) that I used for the table
>> grouping.
>> I only tried another column with data type Int that returned the similar
>> data.
>>
>> We have tried to run and export the report on two client machines, one
>> has
>> Excel 2003 and one has Excel 2007.
>>
>> And I am trying to figuring it out how to output the results from SQL
>> management studio to an excel file. :)
>>
>> "Wei Lu [MSFT]" <we...(a)online.microsoft.com> wrote in
>> messagenews:xPpOT%238NIHA.5204(a)TK2MSFTNGHUB02.phx.gbl...
>>
>>
>>
>> > Hello Chris,
>>
>> > I would like to know whether you have applied the latest service pack
>> > of
>> > SQL Server.
>>
>> > Please apply the service pack and let me know whether this issue
>> > resolved.
>>
>> > Sincerely,
>>
>> > Wei Lu
>> > Microsoft Online Community Support
>>
>> > ==================================================
>>
>> > When responding to posts, please "Reply to Group" via your newsreader
>> > so
>> > that others may learn and benefit from your issue.
>>
>> > ==================================================
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.- Hide quoted text -
>>
>> - Show quoted text -
>


From: Wei Lu [MSFT] on 10 Dec 2007 01:23
Hello,

Have you tried to export the result to csv and open it in Excel?


Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

From: shaikat.das on 10 Dec 2007 19:18
Chris,

In the dialog box that opens , select "Allfiles", then type in the
file name with the extension , viz. Test.xls and that will create the
file for you.


Cheers

Shai

On Dec 10, 5:23 pm, we...(a)online.microsoft.com (Wei Lu [MSFT]) wrote:
> Hello,
>
> Have you tried to export the result to csv and open it in Excel?
>
> Sincerely,
>
> Wei Lu
> Microsoft Online Community Support
>
> ==================================================
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
>
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.

From: Wei Lu [MSFT] on 11 Dec 2007 01:18
Hello,

I would like to get the report definition so that I can go for further
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: HTTP Error 401.1 - Unauthorized
Next: ASP.NET Reports Web Site vs. ASP.NET Crystal Reports Web Site?