CODEWITHSUNDEEP
reporting-servicesssrs-2008ssrs-2008-r2
RandiB1
RandiB1

Reputation: 76

Data Driven Subscription Special Characters needed in File Name

I have a data driven subscription with the file name as one of the columns in the object that SSRS uses to fulfill the subscription.

The file name is the subject of the report. I have tested this a few ways and the error is happening with the file name, not when I pass the item as a parameter.

For example, the report as a single Parameter, Item.

The report is written to a file share:

I have tried substituting the "&" with other characters, and of course it works, but it is really important for the file to be named Blue&White.pdf

Any suggestions are appreciated.

Upvotes: 1

Views: 741

Answers (2)

Phonz
Phonz

Reputation: 1

I am using a data driven subscription and used the SQL command to set the filename. The REPLACE function was used to change '&' to 'and'.

Upvotes: 0

dotNetE
dotNetE

Reputation: 616

I think it is interpreting the '&' as an argument separator as application/x-www-form-urlencoded.

You may want to consider different encoding of the Unicode Character 'AMPERSAND' (U+0026). However since '&' is used as an escape character you options may be limited.

&
%26
\u0026

Upvotes: 1

Related Questions