IanWaterman
Programmer
CR9 reports on CE9 (using Oracle 9i database)
we use CE9 to publsh reports but instead of using Eportfolio we use custom ASP called from our oracle application.
I am trying to change a report within a folder on CE, it installs and runs through CMC without a problem.
Process I am following
Change label on existing report Object eg RPTABC010 to
RPTABC010_OLD and import new report as RPTABC010, both object work within CMC.
If I now call report in my ASP code I get the error
Error Type:
Microsoft VBScript runtime (0x800A0006)
Overflow: 'CInt'
/activebank/file1_CR.inc, line 102
This code refers to the report object number
'Create the report source and report factory objects
Set rptFactory = iStore.EnterpriseSession.Service("", "PSReportFactory")
Set rptSource = rptFactory.OpenReportSource(CInt(reportID))
However, if I rename the new object _NEW and change _OLD back to correct name and run ASP again it all works fine. I have also tried reimporting the OLD report and this will not run either. Its almost as if CE is not updating the Report object ID numbers and there is some sort of clash. I am reluctant to delete the old object just incase I can not import the new report at all. At least for now report works and changes were just cosmetic.
I have even tried giving report a new name RPTABC017, again runs through CMC, but fails for same reason. Its as if CE is generating Report Object IDs too big for the ASP code or the variable CInt.
Any suggestions as to what is going wrong.
Ian
we use CE9 to publsh reports but instead of using Eportfolio we use custom ASP called from our oracle application.
I am trying to change a report within a folder on CE, it installs and runs through CMC without a problem.
Process I am following
Change label on existing report Object eg RPTABC010 to
RPTABC010_OLD and import new report as RPTABC010, both object work within CMC.
If I now call report in my ASP code I get the error
Error Type:
Microsoft VBScript runtime (0x800A0006)
Overflow: 'CInt'
/activebank/file1_CR.inc, line 102
This code refers to the report object number
'Create the report source and report factory objects
Set rptFactory = iStore.EnterpriseSession.Service("", "PSReportFactory")
Set rptSource = rptFactory.OpenReportSource(CInt(reportID))
However, if I rename the new object _NEW and change _OLD back to correct name and run ASP again it all works fine. I have also tried reimporting the OLD report and this will not run either. Its almost as if CE is not updating the Report object ID numbers and there is some sort of clash. I am reluctant to delete the old object just incase I can not import the new report at all. At least for now report works and changes were just cosmetic.
I have even tried giving report a new name RPTABC017, again runs through CMC, but fails for same reason. Its as if CE is generating Report Object IDs too big for the ASP code or the variable CInt.
Any suggestions as to what is going wrong.
Ian