SQL Reporting Services

I'm running SQL Reporting Services 2005 on my SBS Premium 2003. I have
it installed in the Default Website. It runs well except for one
issue. After rendering a report, if you select the "Acrobat (PDF)
File" format and click on "Export", it will come up with a File
Download prompt to save the file, but it wants to name the file
"Reserved.ReportViewerWebControl.axd". This behaviour happens for all
the reports. On other installations of Reporting Services on Windows
Server 2003 the behaviour is that it the prompt will have the default
of the name of the report with the pdf file extension (such as
"MonthlySales.pdf"). This leads me to believe this is something unique
to the settings on the SBS server.

Has anyone experienced this and found a solution?

PHason
Fri Jun 27 07:50:15 PDT 2008

One other bit of information: I am not using ISA on the server, it was
installed, but I have removed it.



On Jun 27, 9:14=A0am, PHason <jko...@palmerhamilton.com> wrote:
> I'm running SQL Reporting Services 2005 on my SBS Premium 2003. I have
> it installed in the Default Website. It runs well except for one
> issue. After rendering a report, if you select the "Acrobat (PDF)
> File" format and click on "Export", it will come up with a File
> Download prompt to save the file, but it wants to name the file
> "Reserved.ReportViewerWebControl.axd". This behaviour happens for all
> the reports. On other installations of Reporting Services on Windows
> Server 2003 the behaviour is that it the prompt will have the default
> of the name of the report with the pdf file extension (such as
> "MonthlySales.pdf"). This leads me to believe this is something unique
> to the settings on the SBS server.
>
> Has anyone experienced this and found a solution?

bass_player
Sun Jun 29 22:56:52 PDT 2008

Do you have PDF reader installed on the client?


"PHason" <jkopac@palmerhamilton.com> wrote in message
news:9fc6567c-ec00-420e-a63a-663346821b96@x35g2000hsb.googlegroups.com...
> One other bit of information: I am not using ISA on the server, it was
> installed, but I have removed it.
>
>
>
> On Jun 27, 9:14 am, PHason <jko...@palmerhamilton.com> wrote:
>> I'm running SQL Reporting Services 2005 on my SBS Premium 2003. I have
>> it installed in the Default Website. It runs well except for one
>> issue. After rendering a report, if you select the "Acrobat (PDF)
>> File" format and click on "Export", it will come up with a File
>> Download prompt to save the file, but it wants to name the file
>> "Reserved.ReportViewerWebControl.axd". This behaviour happens for all
>> the reports. On other installations of Reporting Services on Windows
>> Server 2003 the behaviour is that it the prompt will have the default
>> of the name of the report with the pdf file extension (such as
>> "MonthlySales.pdf"). This leads me to believe this is something unique
>> to the settings on the SBS server.
>>
>> Has anyone experienced this and found a solution?
>

PHason
Mon Jun 30 08:50:35 PDT 2008

Yes, I get the results expected on the client when exporting the
reports from a different server.

I was thinking that there was something different about the settings
in IIS on the SBS server like the SBSFLT ASAPI Filter for the default
website.

But if others have installed reporting services and haven't
experienced the issue, then perhaps I have a messed up setting in one
of the reporting services config files.


On Jun 30, 12:56=A0am, "bass_player" <bass_pla...@mvps.org> wrote:
> Do you have PDF reader installed on the client?
>
> "PHason" <jko...@palmerhamilton.com> wrote in message
>
> news:9fc6567c-ec00-420e-a63a-663346821b96@x35g2000hsb.googlegroups.com...
>
>
>
> > One other bit of information: I am not using ISA on the server, it was
> > installed, but I have removed it.
>
> > On Jun 27, 9:14 am, PHason <jko...@palmerhamilton.com> wrote:
> >> I'm running SQL Reporting Services 2005 on my SBS Premium 2003. I have
> >> it installed in the Default Website. It runs well except for one
> >> issue. After rendering a report, if you select the "Acrobat (PDF)
> >> File" format and click on "Export", it will come up with a File
> >> Download prompt to save the file, but it wants to name the file
> >> "Reserved.ReportViewerWebControl.axd". This behaviour happens for all
> >> the reports. On other installations of Reporting Services on Windows
> >> Server 2003 the behaviour is that it the prompt will have the default
> >> of the name of the report with the pdf file extension (such as
> >> "MonthlySales.pdf"). This leads me to believe this is something unique
> >> to the settings on the SBS server.
>
> >> Has anyone experienced this and found a solution?- Hide quoted text -
>
> - Show quoted text -

PHason
Tue Jul 15 06:56:14 PDT 2008

I haven't found a solution yet, but here are more details on its
behaviour.

If a member server is running Reporting Services, then the export to
pdf works correctly with the file being named appropriately.

When Reporting Services is run on the SBS2003 server, the export to
pdf and naming the file works correctly for all machines that are not
members of the domain, but for members, it will export the file name
as "Reserved.ReportViewerWebControl.pdf" now. Prior to this it was not
exporting as a pdf, but I reinstalled acrobat reader on the client and
that seemed to fix the file extension problem.

Since this problem only happens on machines joined to the domain, this
leads me to believe it must be security GPO setting or something on
the clients that is causing this. Yet it's still strange that it only
happens when it's on the SBS server, not a member server.

Does anyone have any suggestions? Thanks.