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

Data driven subscription to fileshare Expand / Collapse
Author
Message
Posted Wednesday, September 26, 2012 8:00 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, November 6, 2014 3:08 AM
Points: 47, Visits: 206
Hi,

I am new to ssrs and need to create a data driven subscription to a fileshare for a report.

What do I need to enter in step 3 of the create data driven subscription wizard if I want the report to export as CSV to a fileshare?
Post #1364704
Posted Thursday, September 27, 2012 5:15 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, November 6, 2014 3:08 AM
Points: 47, Visits: 206
I found a solution for what I wanted to do by using

SELECT 'ReportName_' + REPLACE(CONVERT(VARCHAR(10),GETDATE(),101),'/','') AS [FileName]

This then allowed me to proceed to step 4 where I could populate the necessary options for the fileshare csv file
Post #1365146
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse