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