Hello
I'm trying to add a report I just built into our company Macro but am seeing the following, very vague error in the logs. "440-Impromptu: Multiple errors have occured with Impromptu"
The resulting report is empty despite the fact that I can run this report successfully on the same box with the same copy of Cognos (Administrator Series 7 ver 3) Manually.
What am I missing?
strReportName = "\\Fileserver\Reports\Cognos\Editorial\Editorial\eBooks\eBook and Print Comparison.imr"
strPromptValues = "Spring 2012"
print #iLogFile, date$, time$, "Report = "; strReportName
Set objImpRep = _
objImpApp.OpenReport(strReportName,strPromptValues)
objImpRep.RetrieveAll
Set objPDFPub = objImpRep.PublishPDF
objPDFPub.Publish "\\Fileserver\Reports\Title Management Reports\Spring 2012\eBooks\eBook and Print Comparison S12.pdf"
objImpRep.Save
objImpRep.CloseReport
Set objImpRep = Nothing
Set objPDFPub = Nothing
2 possiblities that I can think of:
1) the length of the reportname and output file name.
At what point does the macro fail? (Can you run in animate mode to see?)
If it's on either the OpenReport or the Publish, double check the file-paths, and if they're correct, move the report somewhere where the filepath is shorter - i.e. like C:\report.imr - and try it again. Similarly, create the pdf file somewhere local.
(I have a vague memory of there being a limit on the length of the filenames when opening from a macro.)
2) I have seen problems before where the overall size of the macro was too big. You say you are adding it in to your 'company' macro - is it particularly large, and if you were to (as a test) remove another part of it, does your report then run?
NB, I'm assuming the macro you're putting this in has previously opened the correct catalog for your report?