"Bernardina" <Bernardina@discussions.microsoft.com> wrote in message
news:AA48BA55-78CF-4307-8F80-D897252DDC14@microsoft.com...
> Is there a way to render a format that is not a part of the standard
> parameter prefixes? Example: my code renders a report in Excel format;
> however, when the prompt appears to the user (to either open or save the
> file), they want the report name + parameter to show in prompt.
>
> More detailed example -- AReport.rdl. Once they have accessed the report
> via
> Report Manager, they choose an item from the field (parameter), click the
> Run
> Report button. Once the prompt comes up, they want to see: AReport -
> (parameter).xls. Is there an "output" format in my code that I can use? My
> code looks similar to this:
>
> parmstring &= "&rs:Command=Render&rs:Format=EXCEL&rc:OmitFormulas=true"
> Me.OpenDialog(Me.ReportServiceURL("AReport", parmstring), 600, 800, True,
> False, Nothing)
>