how to set the default filename when exporting the report

Dear Anyone,

When exporting a report to another format, say excel; the file name is always set to the report name. Our client has a requirement where whenever a user exports a report to excel, the timestamp of when the data of the report was made should be appended in the filename. Is there a way to do this in Reporting Services as well as report builder?

Thanks,
JosephThere is no way to change the name of the export. You could set up a subscription to save the file off to a file. Not sure if that will sufficient or not for your scenario.

-Daniel|||

With Reporting Service 2005, you can create a data-driven subscription and set the FILENAME parameter.

Here is a sample query:

select'bogus - '+LEFT(DATENAME(month,getdate()),3)+' '+(CAST(DatePart(dd,GetDate())asnvarchar)+' '+CAST(DatePart(yyyy,GetDate())asnvarchar))asFILENAME

Hope this helps!

Thanks.

|||I am not sure, but I recall
Data-Driven Subscription is part of SQL Server/Report Server 2005Enterprise edition only|||

hi,

Can you help me on this issue,

My requirement is need to change the Report data file name appending with timestamp.

1. I created RDL
2. Opening the RDL data into my GWT application with new IE window
3. Exporting the data into excel/pdf.
4. Able to popup Download file Dialog.
5. Asking the File to save. ( Here by defualt it's giving the RDL File name only. I want to display with RDL file name with timestamp).

But what every you said , I created data-driven subscription, In Delivery Query Screen: Even i tried with A shared data source, able to validate the Command text. Finally not able to change the file name. Can you please tell what is the problem is.

best regards

bhushanam

how to set the default filename when exporting the report

Dear Anyone,

When exporting a report to another format, say excel; the file name is always set to the report name. Our client has a requirement where whenever a user exports a report to excel, the timestamp of when the data of the report was made should be appended in the filename. Is there a way to do this in Reporting Services as well as report builder?

Thanks,
JosephThere is no way to change the name of the export. You could set up a subscription to save the file off to a file. Not sure if that will sufficient or not for your scenario.

-Daniel|||

With Reporting Service 2005, you can create a data-driven subscription and set the FILENAME parameter.

Here is a sample query:

select 'bogus - ' + LEFT(DATENAME(month, getdate()),3) + ' ' + (CAST(DatePart(dd, GetDate()) as nvarchar) + ' ' + CAST(DatePart(yyyy, GetDate()) as nvarchar)) as FILENAME

Hope this helps!

Thanks.

|||I am not sure, but I recall
Data-Driven Subscription is part of SQL Server/Report Server 2005 Enterprise edition only|||

hi,

Can you help me on this issue,

My requirement is need to change the Report data file name appending with timestamp.

1. I created RDL
2. Opening the RDL data into my GWT application with new IE window
3. Exporting the data into excel/pdf.
4. Able to popup Download file Dialog.
5. Asking the File to save. ( Here by defualt it's giving the RDL File name only. I want to display with RDL file name with timestamp).

But what every you said , I created data-driven subscription, In Delivery Query Screen: Even i tried with A shared data source, able to validate the Command text. Finally not able to change the file name. Can you please tell what is the problem is.

best regards

bhushanam

how to set the default filename when exporting the report

Dear Anyone,

When exporting a report to another format, say excel; the file name is always set to the report name. Our client has a requirement where whenever a user exports a report to excel, the timestamp of when the data of the report was made should be appended in the filename. Is there a way to do this in Reporting Services as well as report builder?

Thanks,
JosephThere is no way to change the name of the export. You could set up a subscription to save the file off to a file. Not sure if that will sufficient or not for your scenario.

-Daniel|||

With Reporting Service 2005, you can create a data-driven subscription and set the FILENAME parameter.

Here is a sample query:

select 'bogus - ' + LEFT(DATENAME(month, getdate()),3) + ' ' + (CAST(DatePart(dd, GetDate()) as nvarchar) + ' ' + CAST(DatePart(yyyy, GetDate()) as nvarchar)) as FILENAME

Hope this helps!

Thanks.

|||I am not sure, but I recall
Data-Driven Subscription is part of SQL Server/Report Server 2005 Enterprise edition only

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