Recently we upgraded to WebFocus 7.7 and found out that the MORE command doesn't work through ReportCaster when try to burst a report. We get an error THE ON FIELD IS NOT THE FIRST BY FIELD. IBI says MORE is not supported from version 7.1.xxx onwards. But, I see a lot of Focal Point posts with a reference to MORE. We are looking at using other alternatives like USE or FILEDEF...APPEND, but it's lot of rework. Any suggestions? Thanks.
-***********************************************
-* Universal concatenation using MORE Command
-************************************************
TABLE FILE CAR
PRINT
CAR
MODEL
SEATS
DEALER_COST
BY COUNTRY
IF COUNTRY EQ FRANCE
ON TABLE HOLD AS HOLD1
END
-RUN
TABLE FILE CAR
PRINT
CAR
MODEL
SEATS
DEALER_COST
BY COUNTRY
IF COUNTRY EQ ENGLAND
ON TABLE HOLD AS HOLD2
END
-RUN
TABLE FILE CAR
PRINT
CAR
MODEL
SEATS
DEALER_COST
BY COUNTRY
IF COUNTRY EQ ITALY
ON TABLE HOLD AS HOLD3
END
-RUN
TABLE FILE CAR
PRINT
CAR
MODEL
SEATS
DEALER_COST
BY COUNTRY
IF COUNTRY EQ JAPAN
ON TABLE HOLD AS HOLD4
END
-RUN
TABLE FILE HOLD1
PRINT *
ON TABLE HOLD AS HOLDMORE
MORE
FILE HOLD2
MORE
FILE HOLD3
MORE
FILE HOLD4
END
-RUN
TABLE FILE HOLDMORE
PRINT
CAR
MODEL
SEATS
DEALER_COST
BY COUNTRY
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLE *
UNITS=IN, PAGESIZE='Letter', SQUEEZE=ON, $
TYPE=REPORT, LEFTGAP=0.1, FONT='ARIAL UNICODE MS', SIZE=7, GRID=OFF, TOPGAP=0.001, BOTTOMGAP=0.01, RIGHTGAP=0.1,$
TYPE=REPORT, COLUMN=N1, SQUEEZE=1, $
TYPE=REPORT, COLUMN=N2, SQUEEZE=1, $
TYPE=REPORT, COLUMN=N3, SQUEEZE=1, $
TYPE=REPORT, COLUMN=N4, SQUEEZE=1, $
TYPE=REPORT, COLUMN=N5, SQUEEZE=1, $
ENDSTYLE
END
This message has been edited. Last edited by: Kerry,
7.6.9, XP
October 20, 2010, 03:35 PM
Prarie
So IBI said it was no longer Supported? So every program with MORE will no longer work? Really?
October 20, 2010, 05:11 PM
Waz
I still use it, in 7.6.
CT how did you get this information, it is of great concern.
I would hope that the statement is more like "MORE is not supported with bursting", and opposed to "MORE is not supported".
If anyone from IBI is reading this, can we have a comment ?
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
October 21, 2010, 12:07 AM
Mika Keranen
Same thing here, using it all the time and for example with the current customer, we're creating reporting files by using MORE and bursting reports from these tables, no worries there. The example CT posted should work ok with Report Caster and bursting on COUNTRY values.
Regards, Mika
WebFOCUS 7.6.x PMF 5.2.x
October 21, 2010, 12:20 AM
Waz
The plot thickens...
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
October 21, 2010, 09:20 AM
Tom Flynn
CT,
There is "no way" MORE is not supported. Modify your above code example as below. Alpha columns need quotes and BYDISPLAY = ON is also needed:
-***********************************************
-* Universal concatenation using MORE Command
-************************************************
SET BYDISPLAY=ON
-RUN
TABLE FILE CAR
PRINT
CAR
MODEL
SEATS
DEALER_COST
BY COUNTRY
IF COUNTRY EQ 'FRANCE'
ON TABLE HOLD AS HOLD1
END
-RUN
TABLE FILE CAR
PRINT
CAR
MODEL
SEATS
DEALER_COST
BY COUNTRY
IF COUNTRY EQ 'ENGLAND'
ON TABLE HOLD AS HOLD2
END
-RUN
TABLE FILE CAR
PRINT
CAR
MODEL
SEATS
DEALER_COST
BY COUNTRY
IF COUNTRY EQ 'ITALY'
ON TABLE HOLD AS HOLD3
END
-RUN
TABLE FILE CAR
PRINT
CAR
MODEL
SEATS
DEALER_COST
BY COUNTRY
IF COUNTRY EQ 'JAPAN'
ON TABLE HOLD AS HOLD4
END
-RUN
TABLE FILE HOLD1
PRINT *
ON TABLE HOLD AS HOLDMORE
MORE
FILE HOLD2
MORE
FILE HOLD3
MORE
FILE HOLD4
END
-RUN
TABLE FILE HOLDMORE
PRINT
CAR
MODEL
SEATS
DEALER_COST
BY COUNTRY
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLE *
UNITS=IN, PAGESIZE='Letter', SQUEEZE=ON, $
TYPE=REPORT, LEFTGAP=0.1, FONT='ARIAL UNICODE MS', SIZE=7, GRID=OFF, TOPGAP=0.001, BOTTOMGAP=0.01, RIGHTGAP=0.1,$
TYPE=REPORT, COLUMN=N1, SQUEEZE=1, $
TYPE=REPORT, COLUMN=N2, SQUEEZE=1, $
TYPE=REPORT, COLUMN=N3, SQUEEZE=1, $
TYPE=REPORT, COLUMN=N4, SQUEEZE=1, $
TYPE=REPORT, COLUMN=N5, SQUEEZE=1, $
ENDSTYLE
END
-RUN
Thanks for all the responses. The problem is when we burst the report through ReportCaster. It works fine if we don't busrt .
When we opened a case with IBI, we were told that:
quote:
MORE with BURST is not currently supported in RC and is documented in the RC 7.1 best practice guide. The 7.6.11 rc best practice guide does not include this verbage. The PM has said this need to be added back in.
Burst with MORE works sometimes. It is the times it does not work that is the reason why it is not currently supported and is now an NFR.
I just tried Tom's suggestion to add SET BYDISPLAY=ON in the CAR example and it worked!!! I will try it with one of our reports. Tom, thanks for the brilliant solution. This message has been edited. Last edited by: CT,
7.6.9, XP
October 21, 2010, 11:01 AM
njsden
The confusion may be due lack of clarity in the documentation. In the Limitations for Using WebFOCUS Features section of the Best Practices: Considerations When Using ReportCaster 5.3 document, it says:
quote:
Due to ReportCaster’s complex internal processing, there are limitations for using WebFOCUS features and commands. The following features are not supported in scheduled procedures: • PCSEND –WebFOCUS reporting feature to store report sections in different files. • Multiple TABLE or GRAPH requests with HTML format –Internally,these are multiple HTML documents.Only the result of the first TABLE or GRAPH request (without a HOLD or SAVE command) will be distributed. In order to distribute a graph, you must use the GIF, JPG, PNG, or SVG format. • MORE – This command is used to concatenate data sources. ...
The exact same wording appears in the Best Practices document corresponding to versions 7.1, 7.6.x and 7.7.
That leads one to believe that MORE cannot be used when scheduling reports through ReportCaster but reality has shown otherwise.
So, what exactly is not supported? I hope IBI would provide more insights into that.
In the Release 7.1 Best Practices guide it is stated that the MORE command is not supported with ReportCaster.
This remained true throughout Release 7.6 and is still true in Release 7.7.
Customers may have found that they can use the MORE command with ReportCaster in certain instances but it has not been supported.
Support for the MORE command is a New Feature Request.
WebFOCUS All Releases
October 22, 2010, 08:46 PM
Brian Suter
We are investigating this. We should not have this limitation. No promises... but it is getting cycles that are not in the final 7702 testing cycles (which is most of the teams).
This message has been edited. Last edited by: CT,