{"id":86,"date":"2010-02-07T05:02:00","date_gmt":"2010-02-07T05:02:00","guid":{"rendered":"\/lisa\/post\/2010\/02\/07\/YAPS-on-Custom-Excel-for-RS-Drive-Subscriptions-with-a-Stick-Shift.aspx"},"modified":"2010-02-07T05:02:00","modified_gmt":"2010-02-07T05:02:00","slug":"yaps-on-custom-excel-for-rs-drive-subscriptions-with-a-stick-shift","status":"publish","type":"post","link":"https:\/\/spacefold.com\/lisa\/2010\/02\/07\/yaps-on-custom-excel-for-rs-drive-subscriptions-with-a-stick-shift\/","title":{"rendered":"YAPS on Custom-Excel-for-RS: Drive Subscriptions with a Stick Shift"},"content":{"rendered":"

 <\/p>\n

The title gives away the punchline on this one…<\/p>\n

Cliff Leighton asks<\/a><\/p>\n

\n

Also, does anyone know how to make the output filename end with .XLS in an emailed SSRS Subscription with the “XML file with report data” option? The emailed file from the Subscription comes out as *filename*.xml and my users will be very confused with an XML file versus a XLS file.<\/p>\n<\/blockquote>\n

and at least one other person (Sanket<\/a>) appeared to have a similar problem last November:<\/p>\n

\n

Hi,I want to change name of report file when exporting to excel.
i have got no idea how to do it. \"Frown\"
 Please help \"Smile\"<\/p>\n<\/blockquote>\n

… which certainly makes it a question worth answering. I asked Sanket this:<\/p>\n

\n

Sanket: are you exporting using an application?  Or is the user doing the export from ReportViewer or Report Manager? Or what?<\/p>\n<\/blockquote>\n

… and you’ll see why shortly.<\/p>\n

Before I answer, the inevitable caveat<\/h2>\n

Folks, while an XML extension may be confusing, consider the following:<\/p>\n