Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE-OPENED] Universal Concatenation using MORE
Go
New
Search
Notify
Tools
Reply
  
[CASE-OPENED] Universal Concatenation using MORE
 Login/Join
 
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, 2008Reply With QuoteReport This Post
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, 2005Reply With QuoteReport This Post
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.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6068 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
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, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
The plot thickens...



Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6068 | Location: Land of the Darug people, Terra Australis Incognita | Registered: October 31, 2006Reply With QuoteReport This Post
Virtuoso
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 7.7.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1942 | Location: Parker, CO | Registered: January 31, 2006Reply With QuoteReport This Post
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, 2008Reply With QuoteReport This Post
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, 2005Reply With QuoteReport This Post
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, 2007Reply With QuoteReport This Post
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, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

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

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.