SSRS CreateSubscription method - render format

Question

I am trying to set up a website that allows users to add themselves to subscriptions for reports.

The problem is that when I try and make the subscription render the report as "Excel" it sets it too "XML with report data".

The piece of code I use to try and change the render format is below;

        extParameters.Add(new ParameterValue() { Name = "RenderFormat", Value = "Excel" });
        extParameters.Add(new ParameterValue() { Name = "TO", Value = strEmail });
        extParameters.Add(new ParameterValue() { Name = "IncludeReport", Value = "True" });
        extParameters.Add(new ParameterValue() { Name = "Subject", Value = "subject - " + " (" + strReportPath + ")" });

Thank you

Answer 1

Solved it now.

I had to put the RenderFormat value as "EXCEL" or "EXCELOPENXML"