streaming reports from report services

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

<HTML>
<P>I have&nbsp;applications written in Visual Web Developer 2005 that work fine, except for streaming reports. This works fine on IIS and I want it to work on Apache. A PDF is streamed to the client and the "open, save, cancel" dialog appears. Code to create the report is:</P>
<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dim localReport As New Microsoft.Reporting.WebForms.LocalReport<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; localReport.ReportPath = Server.MapPath("~/OnCallReport01.rdlc")<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dim command As New Data.SqlClient.SqlCommand(sql &amp; " ORDER BY InSort", connect)<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dim reader As Data.SqlClient.SqlDataReader = command.ExecuteReader<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; localReport.DataSources.Add(New Microsoft.Reporting.WebForms.ReportDataSource("DataSet1_DataTable1", reader))<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dim parameter() As Microsoft.Reporting.WebForms.ReportParameter = {New Microsoft.Reporting.WebForms.ReportParameter("Report_Parameter_0", tit)}<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; localReport.SetParameters(parameter)<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SubReportConnect = New Data.SqlClient.SqlConnection(DefaultConnect)<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SubReportConnect.Open()<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SubReportCommand = New Data.SqlClient.SqlCommand("", SubReportConnect)<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AddHandler localReport.SubreportProcessing, AddressOf OnCallReportSubreportProcessingEventHandler<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dim bytes As Byte() = localReport.Render("PDF", Nothing, Nothing, Nothing, Nothing, Nothing, Nothing)<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If Not IsNothing(SubReportReader) Then SubReportReader.Close()<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SubReportReader = Nothing<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SubReportConnect.Close()<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SubReportConnect = Nothing<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reader.Close()<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reader = Nothing<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Response.Clear()<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Response.ContentType = ""<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Response.AddHeader("content-disposition", "attachment; filename=OnCallReport.pdf")<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Response.BinaryWrite(bytes)<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Response.End()<BR>
</P>
<P>&nbsp;&nbsp; Public Sub OnCallReportSubreportProcessingEventHandler(ByVal sender As Object, ByVal e As Microsoft.Reporting.WebForms.SubreportProcessingEventArgs)<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SubReportCommand.CommandText = "SELECT Person.*,AtName,AgAbbreviation FROM Assignment LEFT JOIN Person ON Assignment.AsPnUnique=Person.PnUnique LEFT JOIN AssignmentType ON Assignment.AsAtUnique=AssignmentType.AtUnique LEFT JOIN Agency ON Person.PnAgUnique=Agency.AgUnique WHERE AsInUnique=" &amp; e.Parameters("InUnique").Values(0) &amp; " ORDER BY AtFunctionalOrder, AtName, AsCallOrder"<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If Not IsNothing(SubReportReader) Then SubReportReader.Close()<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SubReportReader = SubReportCommand.ExecuteReader<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; e.DataSources.Clear()<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; e.DataSources.Add(New Microsoft.Reporting.WebForms.ReportDataSource("DataSet1_Persons", SubReportReader))<BR>
&nbsp;&nbsp; End Sub</P>
<P>The asp.net portion of httpd.conf is:</P>
<P>#asp.net <BR>
LoadModule aspdotnet_module "modules/mod_aspdotnet.so" <BR>
AddHandler asp.net asax ascx ashx asmx aspx axd config cs csproj licx rem resources resx soap vb vbproj vsdisco webinfo <BR>
AliasMatch /aspnet_client/system_web/(\d+)_(\d+)_(\d+)_(\d+)/(.*) "C:/Windows/Microsoft.NET/Framework/v$1.$2.$3/ASP.NETClientFiles/$4" <BR>
#On Call<BR>
AspNetMount /oncall "C:/David/VS2005/WD/Projects/OnCall"<BR>
Alias /oncall "C:/David/VS2005/WD/Projects/OnCall"<BR>
&lt;Directory "C:/David/VS2005/WD/Projects/OnCall"&gt;<BR>
&nbsp;&nbsp;&nbsp; Options FollowSymlinks Indexes<BR>
&nbsp;&nbsp;&nbsp; AspNet files<BR>
&nbsp;&nbsp;&nbsp; Order allow,deny<BR>
&nbsp;&nbsp;&nbsp; Allow from all<BR>
&nbsp;&nbsp;&nbsp; DirectoryIndex OnCallInventory.aspx<BR>
&lt;/Directory&gt;<BR>
#reporting01<BR>
AspNetMount /Reports$SQLExpress "c:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportManager"<BR>
Alias /Reports$SQLExpress "c:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportManager"<BR>
&lt;Directory "c:/Program Files/Microsoft SQL Server/MSSQL.3/Reporting Services/ReportManager"&gt;<BR>
&nbsp;&nbsp;&nbsp; Options FollowSymlinks Indexes<BR>
&nbsp;&nbsp;&nbsp; AspNet files<BR>
&nbsp;&nbsp;&nbsp; Order allow,deny<BR>
&nbsp;&nbsp;&nbsp; Allow from all<BR>
&nbsp;&nbsp;&nbsp; DirectoryIndex Home.aspx<BR>
&lt;/Directory&gt;<BR>
#reporting02<BR>
AspNetMount /ReportServer$SQLExpress "c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer"<BR>
Alias /ReportServer$SQLExpress "c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer"<BR>
&lt;Directory "c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer"&gt;<BR>
&nbsp;&nbsp;&nbsp; Options FollowSymlinks Indexes<BR>
&nbsp;&nbsp;&nbsp; AspNet files<BR>
&nbsp;&nbsp;&nbsp; Order allow,deny<BR>
&nbsp;&nbsp;&nbsp; Allow from all<BR>
&nbsp;&nbsp;&nbsp; DirectoryIndex Default.aspx Default.htm Default.asp index.htm iisstart.asp<BR>
&lt;/Directory&gt;<BR>
#asp.net</P>
<P>Thanks</P>
<P>&nbsp;</P>
<P><BR>
-- <BR>
dgm <BR>
</P></HTML>
<BR>