Dynamically name report/file export in SSRS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Jason Selburg » Dynamically name report/file export in SSRS

21 posts, Page 1 of 3

1 2 3 »»»

Dynamically name report/file export in SSRS

Rate Topic

Display Mode

Topic Options

Author

Message

Jason Selburg

Posted Sunday, March 21, 2010 11:31 PM

SSCrazy

Group: General Forum Members
Last Login: Friday, June 14, 2013 1:01 PM
Points: 2,582, Visits: 3,555

Comments posted to this topic are about the item Dynamically name report/file export in SSRS

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg

Post #887162

meiscooldude

Posted Monday, March 22, 2010 12:11 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, July 21, 2010 1:17 PM
Points: 1, Visits: 9

I've been trying to figure out how to do this at work for ages!

Thanks a ton for the tip!

Post #887169

jezman

Posted Monday, March 22, 2010 3:25 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, May 24, 2013 5:18 AM
Points: 23, Visits: 107

I haven't done it myself, but I guess you could also dynamically configure the name if executing reports with rs.exe

Post #887225

Gaurav.Vinodkumar

Posted Monday, March 22, 2010 7:55 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 23, 2012 12:59 PM
Points: 12, Visits: 165

nice article...but one question..if we have to do the same thing at run time (means when user export the rport to pdf or excel) from the report viewer..is there any way to do this?

Post #887391

l543123

Posted Monday, March 22, 2010 8:03 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, September 28, 2012 6:27 AM
Points: 42, Visits: 170

nice tip.. I have played around updating the subscriptions table also.. because we needed to email the same report to 70 users, by just changing one user parameter on the report. I dint want to crate 70 subscriptions, so created 1 email subscriotion which created a record in subscriptions table and also a agent job.

1) created a table to store the 70 userid & email
2) Then wrote a SP to loop and update the parameters & extensionsettings fields in the subscription table
3) Kick off the subscription using below statement after each update
ReportServer.dbo.AddEvent @EventType='TimedSubscription', @EventData='asdasd-12sad-dsfas-dzfad-dfasdfsdfsd'
4) Wait a minute using "Waitfor Delay"
5) Updated the Agent job, commented the "ReportServer.dbo.AddEvent" in the job step and called the SP in that step.

So now the subscription throws an error when you try to edit from Report Manager, which is good because if somebody edits it, SSRS will update existing job with the addevent step. This works fine because if later I need to change email or add new users, I just need to add a record to the table.

Do you know of any other better way to do this??

Post #887396

Jason Selburg

Posted Monday, March 22, 2010 8:33 AM

SSCrazy

Group: General Forum Members
Last Login: Friday, June 14, 2013 1:01 PM
Points: 2,582, Visits: 3,555

Gaurav.Vinodkumar (3/22/2010)

nice article...but one question..if we have to do the same thing at run time (means when user export the rport to pdf or excel) from the report viewer..is there any way to do this?

Not that I know of.. :-(

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg

Post #887410

SQLRNNR

Posted Monday, March 22, 2010 12:03 PM

SSCoach

Group: General Forum Members
Last Login: Today @ 5:03 PM
Points: 18,853, Visits: 12,438

Nice article.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #887560

SQL-Student

Posted Monday, March 22, 2010 2:55 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 1:21 AM
Points: 20, Visits: 120

What about customer support?

From what I know, Microsoft will not support you, if you make modifications to the SSRS Catalog manually.

Post #887695

Jason Selburg

Posted Tuesday, March 23, 2010 6:31 AM

SSCrazy

Group: General Forum Members
Last Login: Friday, June 14, 2013 1:01 PM
Points: 2,582, Visits: 3,555

SQL-Student (3/22/2010)

What about customer support?

From what I know, Microsoft will not support you, if you make modifications to the SSRS Catalog manually.

*grin* Don't tell them

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg

Post #888036

josh.fraser

Posted Tuesday, March 23, 2010 9:40 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, November 01, 2012 2:30 PM
Points: 3, Visits: 16

Jason,

Did you know that in the subscription you could just set the filename to

@ReportName@ParameterName and it will save the report ?

Post #888256

« Prev Topic | Next Topic »

21 posts, Page 1 of 3

1 2 3 »»»

Permissions