Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple report parts on an asp page

Status
Not open for further replies.

nickwild

IS-IT--Management
Apr 19, 2001
5
GB
I wish to publish various report parts from different reports in a table on an asp page.

I've got both showing initially however when I drill down on one it seems to affect both. I have the following code:-

where have I gone wrong

<tr>
<td align=&quot;LEFT&quot;>
<%
Dim iStore, id
Set iStore = Session(&quot;iStore&quot;)
set result = Istore.Query(&quot;Select SI_ID, SI_NAME From CI_INFOOBJECTS Where SI_NAME= 'World Sales Report'and SI_INSTANCE=0&quot;)
reportID=result.item(1).ID
set RptReportfactory=istore.EnterpriseSession.service (&quot;&quot;, &quot;PSReportFactory&quot;)

set reportsource= rptReportfactory.openreportsource(reportID)
set viewer=server.createobject(&quot;CrystalReports.crystalreportpartsviewer&quot;)
viewer.Reportsource=reportsource
viewer.processHttpRequest Request, Response, Null
%>
</td>
</tr>
<tr>
<td align=&quot;LEFT&quot;>
<%
Dim iStore, id
Set iStore = Session(&quot;iStore&quot;)
set result = Istore.Query(&quot;Select SI_ID, SI_NAME From CI_INFOOBJECTS Where SI_NAME= 'Inventory'and SI_INSTANCE=0&quot;)
reportID=result.item(1).ID
set RptReportfactory=istore.EnterpriseSession.service (&quot;&quot;, &quot;PSReportFactory&quot;)

set reportsource= rptReportfactory.openreportsource(reportID)
set viewer=server.createobject(&quot;CrystalReports.crystalreportpartsviewer&quot;)
viewer.Reportsource=reportsource
viewer.processHttpRequest Request, Response, Null
%>
</td>
</tr>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top