SQL 2008 Reporting Services Rendering (Set the Default Export option to Excel without choosing it)

We have a requirement regarding reporting services rendering option. I've managed to limit the rendering option to excel only but after running the report the default value in the drill down list box is still asking to select a format option even i have only one item in the list.

Do you know what configuration or code i need to add or modify in order to achieve this kind of requirement per report basis?
Who is Participating?
Chris LuttrellConnect With a Mentor Senior Database ArchitectCommented:
I do not think that is possible on a per report basis or for all of them, you can limit the choices in the configuration as you must have already found, but that is it.  At least I have not run across that option anywhere.  Sorry.
All Courses

From novice to tech pro — start learning today.