August 31, 2007, 02:49 PM
CathyBUsing the MORE function wont work in Report Library
First, I would like to thank everyone in this forum - I have learned so much from all of you.
My question or problem is - I have a report I wrote that is using the "MORE" function. But it seems if I schedule the report through the library to archive it fails - "function unknown"- which I'm assuming is the MORE function. The report runs fine live. Has anyone run into this? If so do you know of a workaround.
August 31, 2007, 04:19 PM
FrankDutchCathy
To help you we would like to know what version you have.
I use the function many times in RC but we have version 7.1, I'm not sure if it worked under 5.xx
September 06, 2007, 11:51 AM
CathyBFrank,
Sorry I haven't gotten back to you sooner. I am using 7.1 also - I'm using report caster to store the results in the library. It definately having issues with the MORE function. Any suggestions??
September 06, 2007, 04:55 PM
FrankDutchStrange Cathy, are you sure it's the MORE function that causes the problem?
Can you comment out that part and see if it works?
September 06, 2007, 06:30 PM
N.SelphIn an earlier version (4.3x?), I don't quite recall which, MORE did not work in Report Caster if the final table request (the one Caster distributes) was the request that contained the MORE. In that case, I had to hold the output and retable it.
September 06, 2007, 08:42 PM
PiipsterThe Report Caster Administration manual has Appendix C which gives you Tips and Techniques for coding reports to be run in Report Caster.
The section "Limitations for Using WebFOCUS Features" pg C-26 indicates that MORE is not supported in scheduled procedures.
September 07, 2007, 05:41 AM
FrankDutchI have several applications running each day or month that uses the code MORE several times.
All put the result in a temp HOLD file and the final report is created from that HOLD file.
So that should be tehe solution as suggested by N.Selph