Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE-OPENED] Universal Concatenation using MORE

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CASE-OPENED] Universal Concatenation using MORE
 Login/Join
 
CT
Gold member
posted
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
 
Posts: 60 | Location: Cary, NC | Registered: February 19, 2008Report This Post
Prarie
Virtuoso
posted Hide Post
So IBI said it was no longer Supported?
So every program with MORE will no longer work?
Really?
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Waz
Expert
posted Hide Post
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.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Mika Keranen
Gold member
posted Hide Post
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
 
Posts: 58 | Location: Sydney, Australia | Registered: April 22, 2005Report This Post
Waz
Expert
posted Hide Post
The plot thickens...



Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Tom Flynn
Expert
posted Hide Post
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


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
CT
Gold member
posted Hide Post
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. Good One

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


7.6.9, XP
 
Posts: 60 | Location: Cary, NC | Registered: February 19, 2008Report This Post
njsden
Virtuoso
posted Hide Post
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.


Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
Gerry
Silver Member
posted Hide Post
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
 
Posts: 45 | Location: NYC | Registered: September 21, 2007Report This Post
Brian Suter
Platinum Member
posted Hide Post
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).


Brian Suter
VP WebFOCUS Product Development
 
Posts: 200 | Location: NYC | Registered: January 02, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE-OPENED] Universal Concatenation using MORE

Copyright © 1996-2020 Information Builders