Is it possible to name the Excel sheets of an exported report ?

Hello,
Is there a way to name Excel sheets when I export a report ?
My report generate several sheets and I would like to name each one.
Thanks for your help.Unfortunately, this is not possible in this release of Reporting
Services.
Mike|||It gets asked for a lot. I'm still amazed that they haven't been willing to
add this feature. Many people have been asking for it since day one of RS
going live.
"Bassist695" wrote:
> Unfortunately, this is not possible in this release of Reporting
> Services.
> Mike
>sql

Is it possible to launch a report rendered in excel or pdf instead of report viewer?

On my reporting services website, I would like to browse to a report,
click on it and have it render to excel or pdf by instead of report
viewer. Is this possible? I know that I can create rs scripts that run
a report and render to excel, but would like to users to experience
this on the web if possible. I couldn't find this option.you can try to send the format you want in the URL:
http://localhost/......&rs:Format=Excel
"steve" <stevensherman@.comcast.net> wrote in message
news:1165705966.309429.275880@.16g2000cwy.googlegroups.com...
> On my reporting services website, I would like to browse to a report,
> click on it and have it render to excel or pdf by instead of report
> viewer. Is this possible? I know that I can create rs scripts that run
> a report and render to excel, but would like to users to experience
> this on the web if possible. I couldn't find this option.
>|||Putting the format in the url works nicely. Thanks for the reply - that
helps. I was hoping that the report manager would have a configuration
setting for a report that would indicate how to render it.
Jeje wrote:
> you can try to send the format you want in the URL:
> http://localhost/......&rs:Format=Excel
>
> "steve" <stevensherman@.comcast.net> wrote in message
> news:1165705966.309429.275880@.16g2000cwy.googlegroups.com...
> > On my reporting services website, I would like to browse to a report,
> > click on it and have it render to excel or pdf by instead of report
> > viewer. Is this possible? I know that I can create rs scripts that run
> > a report and render to excel, but would like to users to experience
> > this on the web if possible. I couldn't find this option.
> >|||I'm not sure, maybe you'll found in the config files of your reporting
services installation the default rendering format.
I'm sure there is a list of authorized formats, so I presume there is a
default rendering option.
"steve" <stevensherman@.comcast.net> wrote in message
news:1165768599.615241.90010@.j44g2000cwa.googlegroups.com...
> Putting the format in the url works nicely. Thanks for the reply - that
> helps. I was hoping that the report manager would have a configuration
> setting for a report that would indicate how to render it.
>
> Jeje wrote:
>> you can try to send the format you want in the URL:
>> http://localhost/......&rs:Format=Excel
>>
>> "steve" <stevensherman@.comcast.net> wrote in message
>> news:1165705966.309429.275880@.16g2000cwy.googlegroups.com...
>> > On my reporting services website, I would like to browse to a report,
>> > click on it and have it render to excel or pdf by instead of report
>> > viewer. Is this possible? I know that I can create rs scripts that run
>> > a report and render to excel, but would like to users to experience
>> > this on the web if possible. I couldn't find this option.
>> >
>|||Report manager is not configurable that way. You have to create your own
portal if you want to do that. I recommend against doing this. HTML is much
much faster and having all your reports default to PDF is just not a good
idea.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"steve" <stevensherman@.comcast.net> wrote in message
news:1165768599.615241.90010@.j44g2000cwa.googlegroups.com...
> Putting the format in the url works nicely. Thanks for the reply - that
> helps. I was hoping that the report manager would have a configuration
> setting for a report that would indicate how to render it.
>
> Jeje wrote:
>> you can try to send the format you want in the URL:
>> http://localhost/......&rs:Format=Excel
>>
>> "steve" <stevensherman@.comcast.net> wrote in message
>> news:1165705966.309429.275880@.16g2000cwy.googlegroups.com...
>> > On my reporting services website, I would like to browse to a report,
>> > click on it and have it render to excel or pdf by instead of report
>> > viewer. Is this possible? I know that I can create rs scripts that run
>> > a report and render to excel, but would like to users to experience
>> > this on the web if possible. I couldn't find this option.
>> >
>sql

Is it possible to export a View to Excel in MS SQL 2000 ?

Hi all,

In MS SQL Management Console I can right-click on any Table and I have
the option All Tasks > Export Data where I can export the table to
Excel. In a View however this isn't there. I have many views I want
to simply export to Excel, but the only way I've found to do it is
creating an ODBC connection to the MS SQL database from MS Access,
linking the Views to Access Tables, and exporting from Access. surely
there's someway to export a View to Excel within MS SQL easily like
exporting a table...

Thanks --

AlexIf this is a one-off task, the Import/Export Wizard can export to a
..xls. If you need to run it regularly, then you can save the DTS
package created by the wizard, and modify it as required.

Simon

Is it possible to edit the list of export options in RS 2000?

Hi,

I'm trying to edit the list of export options in Reporting Services 2000. I only want to display Excel and PDF in the export options list. I tried looking in the CSS file in the Styles folder, but didn't see anything that could be changed to accomplish this. Is it possible to do this?

Thanks,

Mike

Look in the RSReportSErver.config file. Add visible="false" to any rendering extensions you do not want to show up. You can also just remove them if you don't ever want people to use them (Although getting rid of html4.0 would break Report Manager.)|||Excellent! Thanks.

is it possible to change the Datatype in a excel file from the Float to varchar

Hi,

I have a excel file and i am trying to import zip codes to the database... but the some of the zip codes start with 06902 but the excel file treats them as float but i want to treat them as varchar...

How can i do it.

Regards

Karen

Try changing the column in Excel to a Text Column. To do that, select the column by clicking on the column heading, then format the cells and select text.|||

Thanks for ur answer,

I did it... But when i transfer the data to sql and the column which were converted to Text are NULL in Sql server...

so what should i do... and when i create a table it takes it RtnAddrZip as Float in excel

REgards

Karen

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.
>

Is Excel ASOLEDB9 taking advantage of cube partitioning?

Hi,

I wonder if Excel ASOLEDB9 is benefiting from cube partitioning?
Some queries are very slow and the Excel generated code look not that good

I tried to pick some queries from SQL Server Profiler and run them in an mdx query window and I get syntax errors.

This leaves me perplex since I have the feeling that people try endless queries through their Excel pivot cube, then, after a while they cancel the Excel query because it takes forever, then the server remain stuck on a high level of CPU usage.

Is it because the syntax error or is it because they just ask for too much data?
Is canceling an Excel pivot data refresh enough to stop the server's query processing?

Yesterday night, it was so bad (100% CPU) that I had to restart the server.

Thanks,

Philippe

Cube partitioning is server-side, so all clients should benefit from it.

When you cancel a query in Excel, you dont cancel it server-side. Check out the following thread for more info on this.

|||Guys,
This is going to be a big problem.
Queries cancelled by the user keep running on the server.

This kills the server and there is no way that someone would spend time trying to manually trace these runaway queries and manually cancel them on the server.

It is also a big issue to have to restart the server everyday just because of these runaway queries.

I would like to see a fix for it in SP2 with a high Priority rating.

This is a server killer.

Probably the biggest bug ever in SSAS2005.

Philippe|||

If anything, this is probably a Excel bug.

If you are really struggeling with this you could try to write some custom code that identifies long running queries (look at the activityviewer sample application). Then you could cancel these queries with a xmla cancel command. Finally schedule your code to run every ten minutes or so with SQL Server Agent.