Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Dynamically name report/file export in SSRS Expand / Collapse
Author
Message
Posted Sunday, March 21, 2010 11:31 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:58 AM
Points: 2,705, Visits: 3,768
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
Posted Monday, March 22, 2010 12:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Monday, March 22, 2010 3:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 7:25 AM
Points: 23, Visits: 117
I haven't done it myself, but I guess you could also dynamically configure the name if executing reports with rs.exe
Post #887225
Posted Monday, March 22, 2010 7:55 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Monday, March 22, 2010 8:03 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, April 14, 2014 5:52 AM
Points: 42, Visits: 172
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
Posted Monday, March 22, 2010 8:33 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:58 AM
Points: 2,705, Visits: 3,768
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
Posted Monday, March 22, 2010 12:03 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 9:08 AM
Points: 21,217, Visits: 14,920
Nice article.



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


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
Posted Monday, March 22, 2010 2:55 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 12:40 PM
Points: 20, Visits: 124
What about customer support?

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

Post #887695
Posted Tuesday, March 23, 2010 6:31 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:58 AM
Points: 2,705, Visits: 3,768
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
Posted Tuesday, March 23, 2010 9:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 2, 2014 2:23 PM
Points: 3, Visits: 17
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 »

Add to briefcase 123»»»

Permissions Expand / Collapse