Focal Point
Using the MORE function wont work in Report Library

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9681067442

August 31, 2007, 02:49 PM
CathyB
Using 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.


WEBFOCUS 7.14
WEBFOCUS.8.04
August 31, 2007, 04:19 PM
FrankDutch
Cathy

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




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

September 06, 2007, 11:51 AM
CathyB
Frank,

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??


WEBFOCUS 7.14
WEBFOCUS.8.04
September 06, 2007, 04:55 PM
FrankDutch
Strange Cathy, are you sure it's the MORE function that causes the problem?

Can you comment out that part and see if it works?




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

September 06, 2007, 06:30 PM
N.Selph
In 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.


(Prod: WebFOCUS 7.7.03: Win 2008 & AIX hub/Servlet Mode; sub: AS/400 JDE; mostly Self Serve; DBs: Oracle, JDE, SQLServer; various output formats)
September 06, 2007, 08:42 PM
Piipster
The 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.


ttfn, kp


Access to most releases from R52x, on multiple platforms.
September 07, 2007, 05:41 AM
FrankDutch
I 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




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7