Hello-
I am new to Cognos and I have created a report that calls a SPROC and returns some data (report1). Then I use that report1 as a hotfile that gets called from the next report (report2). Report2 works just fine and returns the correct data. I have a final report (report3) that calls report2 in order to pass it as a parameter to a sproc (it creates a drop down the user chooses from). When I run this final report, I get the following error . . .
(path to report1)
Could not open query from the file
What could be causing this error, it has the correct path to the report1 and report2 runs fine, so report1 does not seem to be a problem there. Any suggestions?
Thanks for your help in advance-
Denise
I am new to Cognos and I have created a report that calls a SPROC and returns some data (report1). Then I use that report1 as a hotfile that gets called from the next report (report2). Report2 works just fine and returns the correct data. I have a final report (report3) that calls report2 in order to pass it as a parameter to a sproc (it creates a drop down the user chooses from). When I run this final report, I get the following error . . .
(path to report1)
Could not open query from the file
What could be causing this error, it has the correct path to the report1 and report2 runs fine, so report1 does not seem to be a problem there. Any suggestions?
Thanks for your help in advance-
Denise
