Is MORE available in DEV STUDIO GUI? I know how to write “FILE DEF....END MORE name”, but how can I develop the same code using the GUI interface, not just text editor?
thnx Endre

This message has been edited. Last edited by: Kerry,

No....

Instead you might use USE

Since the more'd file needs to have the same columns as the source, use the GUI to create the initial report and all the styling, then flip to the text editor and add the MORE syntax for the additional files.

Endre,

Nem lehet est meg csinalne.

Robert

RSquared,

quote:

Nem lehet est meg csinalne.

Could you please include a translation of the above? I'm just curious what it means in plain English....

I haven't seen MORE work in ReportCaster yet, but haven't tried it in 7.6.6 yet. Something to keep in mind or try out.

I don't see why MORE shouldn't work via ReportCaster. the part of WebFOCUS that processes the FEX is the same engine whether it is from live or ReportCaster.

I'll have to try that again Mickey, I thought it didn't work in 5.2.4 - perhaps I found that error while I was dreaming, I hate it when I wake up in the middle of the night and I'm working! I will test it out.

Thank you,

GamP,

Endre is hungarian, so I told him that basically 'this can't be done', or no can do etc.....

Carol, Mickey

MORE does work in ReportCaster, but you need to help it a bit.

After the MORE commands I give an extra TABLE request on the combined HOLD file something like

TABLE FILE HOLD1
PRINT *
ON TABLE HOLD AS HOLDCOMB
MORE
FILE HOLD2
MORE
FILE HOLD3
END
-RUN
TABLE FILE HOLDCOMB
PRINT *
ON TABLE HOLD AS HOLDFINAL FORMAT FOCUS INDEX Key
END
-RUN
TABLE FILE HOLDFINAL
create the PDF report that needs to be processed by RC
END

Thank you Frank. Perhaps I didn't help it along, I'll give that a try.

I'm not crazy!I knew I read this somewhere and we had problems in our company with MORE in an old release. It's helpful to know that it works now, so thank you!
http://techsupport.informationbuilders.com/sps/12652070.html

Endre - sorry for hijacking your post. Good luck!

This message has been edited. Last edited by: Carol Dobson,

And thanks for the explanation. It's always good to learn something in a new language. Only thing left now for us to find out is how to pronounce it ....

quote:

Nem lehet est meg csinalne

GamP

Let me try to help you.

The 'e' in the first 4 words are pronounced as the 'e' in enjoy, which should make pronouncing them easy. The last word , which is probably mis-spelled, is hard. the first 3 letters are like 'tchi / chi' like tai chi, the next 3 are is like 'naal' and the last 2 are like 'knee'.

I hope this helps. This could make you one of the very few non-Hungarians who can pronounce a hungarian phrase.

Actually, agents running RC requests do act differently -- the action stops after the first TABLE or GRAPH that produces a formatted report.

I vaguely recall a problem reported a while back with RC -- my recollection is the agent prepaturely lowered the boom right after running HOLD ... MORE, because there is no HOLD phrase in the second leg.

Interesting. Thanks for the bit of information.

hmmm
i have absolutely no problems using MORE up the gazzink in RC, from 436 and on up to 766, (skipping of course the infamous 53).
Wherever i have formatted .htm pages in the middle somewhere, i just hold them, named, until i'm ready to display. i have RC jobs producing 20+ formatted .htm, and dumping them all out at the end, using -HTMLFORM BEGIN and delivering thru caster.
MORE from the gui is another story... no clue.

Although it seems that you have some ways of making MORE work in Report Caster as of the following doco it is NOT supported.

ReportCaster End User's Manual
Version 7 Release 6.1 and Higher
DN4500788.0708

See page 200: Limitations for Using WebFOCUS Features

wow
this works fine, i just ran it
765 unix, emailed it to my self

-* File test_more.fex
APP PATH ibisamp
TABLE FILE CAR
PRINT *
ON TABLE HOLD AS HCAR FORMAT ALPHA
MORE
FILE CAR
IF COUNTRY IS 'ENGLAND'
MORE
FILE CAR
IF COUNTRY IS 'ITALY'
END
-RUN
TABLE FILE HCAR
PRINT *
END

i read what you pointed us to , Pip, and it says plain as day that MORE is not supported.
I think that's a mistake. don't you?

Wait..i figure it out.
they mean that this wont work:

TABLE FILE CAR
PRINT *
ON TABLE  PCHOLD  FORMAT HTMTABLE
MORE
FILE CAR
IF COUNTRY IS 'ENGLAND'
MORE
FILE CAR
IF COUNTRY IS 'ITALY'
END

That, works live, but does not work in Caster.
ok fine, i don't think a developer would actually *do* that in the first place.

This message has been edited. Last edited by: susannah,

Correct, RC acts only on the very last TABLE, that's where it puts its magic, not on any of the table requests that are being executed earlier. It's comparable to a pre-processing procedure, where you can do wahtever is needed to create the ultimate file that will be used for the end-report.

In short, after further investigation, MORE is not in GUI, yet.
-----
Looking at implementations where MORE has/had been utilized, I see that most of the time, the final result is a target file, not a report. People using the MORE functions in .fex procedures (ok, call them reports) to generate data rather than report, like a basic ETL process. I'm still an advocate to use Data Migrator for this type of requirements and use WebFOCUS to present information. Not that WebFOCUS would not do both. Data Migrator has the MORE aka "append" in GUI.
-----
and how people found out that I’m from Hungary, I still don't know.
--
Endre