sql server reporting services: Does anyone know if it is possible to create a file share subscription with a
custom naming convention. For example a subscription to "MyCustomReport" but
have it named with some information from the report like the phone number?
8155551212.pdf

????
--

Hi Kristin !

You can build your own filename in the sql string!
In the example below I build a filename with the use of the word 'Butikk' +
Parameter1 + Parameter2 and reference this AS FileName. The filename variable
will then be available to select in the filename dropdown box : )
My filename will typically be 'Butikk0000018_64020.pdf'

SELECT Butikk_id_Parent, Produkt_id, Produkt_navn,
YEAR(DATEADD(m, - 1, GETDATE())) AS YearLastMonth,
ForrigeMnd as Mnd,
'Butikk' + CAST(Butikk_id_Parent AS VARCHAR) + '_' + CAST(Produkt_id AS
VARCHAR) AS FileName
FROM dbo.MAN_RPT_ButikkInfo_V
WHERE (EMail IS NULL)

- Frank

[quoted text, click to view]