Data driven subscription to fileshare

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » Data driven subscription to fileshare

Data driven subscription to fileshare

Rate Topic

Display Mode

Topic Options

Author

Message

Paul Manning-255673

Posted Wednesday, September 26, 2012 8:00 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 2:59 AM
Points: 25, Visits: 127

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

Paul Manning-255673

Posted Thursday, September 27, 2012 5:15 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 2:59 AM
Points: 25, Visits: 127

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 »

Permissions