How to set excel sheet name?

Is there any possibility that I can change properties of excel format
when exporting into it.? I need to have two or many sheets in that excel and
I manage to do that but their names are Sheet1,Sheet2,Sheet3 etc.
How can I name them in design mode of report?
DomagojThere is no way to specify sheet names in the current version. This is on
our wishlist for a future release.
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Domagoj Fabricni" <something@.pero.com> wrote in message
news:%23RZPVNAkEHA.672@.TK2MSFTNGP10.phx.gbl...
> Is there any possibility that I can change properties of excel format
> when exporting into it.? I need to have two or many sheets in that excel
and
> I manage to do that but their names are Sheet1,Sheet2,Sheet3 etc.
> How can I name them in design mode of report?
> Domagoj
>|||Has control over the sheetnames been included in the SP2? I can't see the
functional enhancements list as I'm not a beta program member.
"Chris Hays [MSFT]" wrote:
> There is no way to specify sheet names in the current version. This is on
> our wishlist for a future release.
> --
> This post is provided 'AS IS' with no warranties, and confers no rights. All
> rights reserved. Some assembly required. Batteries not included. Your
> mileage may vary. Objects in mirror may be closer than they appear. No user
> serviceable parts inside. Opening cover voids warranty. Keep out of reach of
> children under 3.
> "Domagoj Fabricni" <something@.pero.com> wrote in message
> news:%23RZPVNAkEHA.672@.TK2MSFTNGP10.phx.gbl...
> > Is there any possibility that I can change properties of excel format
> > when exporting into it.? I need to have two or many sheets in that excel
> and
> > I manage to do that but their names are Sheet1,Sheet2,Sheet3 etc.
> > How can I name them in design mode of report?
> >
> > Domagoj
> >
> >
>
>|||No, it is not included.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Peter Capazzi" <PeterCapazzi@.discussions.microsoft.com> wrote in message
news:E2E21646-9E16-44F7-AD7D-36FD4DB3301F@.microsoft.com...
> Has control over the sheetnames been included in the SP2? I can't see the
> functional enhancements list as I'm not a beta program member.
> "Chris Hays [MSFT]" wrote:
>> There is no way to specify sheet names in the current version. This is
>> on
>> our wishlist for a future release.
>> --
>> This post is provided 'AS IS' with no warranties, and confers no rights.
>> All
>> rights reserved. Some assembly required. Batteries not included. Your
>> mileage may vary. Objects in mirror may be closer than they appear. No
>> user
>> serviceable parts inside. Opening cover voids warranty. Keep out of reach
>> of
>> children under 3.
>> "Domagoj Fabricni" <something@.pero.com> wrote in message
>> news:%23RZPVNAkEHA.672@.TK2MSFTNGP10.phx.gbl...
>> > Is there any possibility that I can change properties of excel
>> > format
>> > when exporting into it.? I need to have two or many sheets in that
>> > excel
>> and
>> > I manage to do that but their names are Sheet1,Sheet2,Sheet3 etc.
>> > How can I name them in design mode of report?
>> >
>> > Domagoj
>> >
>> >
>>|||You may want to check out SoftArtisians's OfficeWriter:
http://officewriter.softartisans.com/officewriter-250.aspx
--
Adrian M.
MCP
"Peter Capazzi" <PeterCapazzi@.discussions.microsoft.com> wrote in message
news:E2E21646-9E16-44F7-AD7D-36FD4DB3301F@.microsoft.com...
> Has control over the sheetnames been included in the SP2? I can't see the
> functional enhancements list as I'm not a beta program member.
> "Chris Hays [MSFT]" wrote:
>> There is no way to specify sheet names in the current version. This is
>> on
>> our wishlist for a future release.
>> --
>> This post is provided 'AS IS' with no warranties, and confers no rights.
>> All
>> rights reserved. Some assembly required. Batteries not included. Your
>> mileage may vary. Objects in mirror may be closer than they appear. No
>> user
>> serviceable parts inside. Opening cover voids warranty. Keep out of reach
>> of
>> children under 3.
>> "Domagoj Fabricni" <something@.pero.com> wrote in message
>> news:%23RZPVNAkEHA.672@.TK2MSFTNGP10.phx.gbl...
>> > Is there any possibility that I can change properties of excel
>> > format
>> > when exporting into it.? I need to have two or many sheets in that
>> > excel
>> and
>> > I manage to do that but their names are Sheet1,Sheet2,Sheet3 etc.
>> > How can I name them in design mode of report?
>> >
>> > Domagoj
>> >
>> >
>>

how to send the reports as an exe file

Hi,

can any one tell me how to send the reports as an exe file. Is there any possibility in ssrs. I have to send all my reports to my client along with the .net application. can any one help me out in this.

Thanks in advanceI doubt this is possible. Why not just deploy the reports on the client's PC?|||

You will probably have to look at building a .net app to run the RDL file, and distributing both the .exe for the .net app and the rdl file.

You may want to check out Project RDL.

http://www.codeproject.com/csharp/rdlproject.asp

The RDL Project is an open source (GPL) C# implementation of the Report Definition Language (RDL) for the .NET environment, by fyiReporting Software.

RDL is an XML based language created by Microsoft with the goal of promoting interoperability of reporting products. Microsoft implemented RDL as part of the Microsoft SQL Server Reporting Services

cheers,

Andrew

|||I have created all my reports in one application. I have to send this as an exe along with my .net project. so that they can install that in their machines. can u tell me What are the possible solutions for this?|||

Hi Andrew,

Thanks for u r reply, my requirement is how to send this as an exe along with .net project. So that my client will install in his machines. is there any possibility for this.

Thanks

Rahul

|||

So, your problem is how to deploy your reports to a client?

Your reports need to be published (deployed) to your client's reporting server. Sending the rdl files in an exe (i.e. as an install exe or a zip exe) will not achieve this. I suggest you either make an msi with a custom action to deploy the reports, or you use the report manager on your client's site to upload the reports to the server (the reports can be uploaded from your machine to your customer's reporting server in this way).

Did that make sense?

|||

Thanks for the reply.

I created MSI setup for deplying the reports. can any one tell me how to change the target server. Here I added a webreference of that. but in my client place target server name may be different. how can I make it dynamic. will there be any possiblity?

Thanks

Rahul