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     [CLOSED]How to print on the last line of a group within Report Painter

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED]How to print on the last line of a group within Report Painter
 Login/Join
 
Gold member
posted
Hi,

Some columns of my sales report need to be print only on the last line of a group (before the next break). The report has to break by profit center and by accounting period week#. So each profit center has 5 lines to print for March period. One of the specific columns is CYCUMSLC should be pinted on the last line (week#5) that you can visualize in the code below.


 
-SET &ECHO ='ALL';
...
DEFINE FILE V_SLSWKRPT
APCDESC/A3=DECODE PROFITCENT (401 'QUE' 001 'MTL' 150 'BOO' 200 'DES' 300 'ALM' 500 'HUO' 100 'BAR' 600 'MUE' 999 'GRP');
BYSEQ/D2.0=DECODE PROFITCENT (401   01  001  02   150  03   200  04   300  05   500  06   100  07   600  08   999  09);
END

TABLE FILE V_SLSWKRPT
SUM

-* THIS_YEAR_CURRENT_PERIOD

     CURSALES/P12C  WITHIN PERIODWK
AS 'RÉEL(R),ACTUEL'
...
-* CUMULATIVE YEARS

     COMPUTE [COLOR:RED]cycumsls[/COLOR]/D14 = IF APCDESC EQ LAST APCDESC THEN CYCUMSLC + ( CYCUMSLS / MIN.NBRWDYMT * MIN.NBRWDYWK ) ELSE CYCUMSLS / MIN.NBRWDYMT * MIN.NBRWDYWK;
AS '&CURYR,RÉEL'
...
BY BYSEQ NOPRINT
BY APCDESC AS 'Centre,Profit'
BY NBRWDYMT AS 'J/M'
BY [COLOR:RED]periodwk[/COLOR] AS 'Sem.'
BY NBRWDYWK AS 'J/S'
ON APCDESC SKIP-LINE

HEADING
"&CONFIDENT<+0>En date du &FFDATEDMYY"
...
FOOTING
"</1 &NOTE_1</1"
"&EOR"

ON TABLE SET SHOWBLANKS ON
ON TABLE SET NODATA 'n/d'
ON TABLE SET EMPTYCELLS OFF
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
     UNITS=IN,
     FONT='TAHOMA',
     SIZE=10,
     TITLETEXT='&EXLABEL',
...
 



How can I do this?
Thanks.

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


Marikaki

WF 7.7.03m, MRE, BI Dashboard, DevStudio, Report Caster, Windows 7, I.E. 8/9, Apache Tomcat 6.0, Derby Output formats: Excel2K, PDF, HTML, AHTML

 
Posts: 96 | Location: Montreal, Quebec, Canada | Registered: January 20, 2010Report This Post
Expert
posted Hide Post
Are you able to give an example using one of the sample files, it will be easier to understand.


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
Gold member
posted Hide Post
Hi Waz,

As additionnal information, the file used by the report is a cluster file. So the sample I'm sending is the model of 3 files concerned by the cluster.

Thanks.

 
REGION	PFT.CTR	SELL.BR	PER.YEAR	PERIOD	PER.WK	CPSLSCUM
ONT	100	1	2010	3	1	200,000.00
ONT	100	1	2010	3	2	400,000.00
ONT	100	1	2010	3	3	0.00
ONT	100	1	2010	3	4	0.00
ONT	100	1	2010	3	5	0.00
ONT	100	2	2010	3	1	100,000.00
ONT	100	2	2010	3	2	300,000.00
ONT	100	2	2010	3	3	0.00
ONT	100	2	2010	3	4	0.00
ONT	100	2	2010	3	5	0.00
ONT	100	3	2010	3	1	200,000.00
ONT	100	3	2010	3	2	400,000.00
ONT	100	3	2010	3	3	0.00
ONT	100	3	2010	3	4	0.00
ONT	100	3	2010	3	5	0.00
ONT	100	4	2010	3	1	100,000.00
ONT	100	4	2010	3	2	300,000.00
ONT	100	4	2010	3	3	0.00
ONT	100	4	2010	3	4	0.00
…						

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


Marikaki

WF 7.7.03m, MRE, BI Dashboard, DevStudio, Report Caster, Windows 7, I.E. 8/9, Apache Tomcat 6.0, Derby Output formats: Excel2K, PDF, HTML, AHTML

 
Posts: 96 | Location: Montreal, Quebec, Canada | Registered: January 20, 2010Report This Post
Expert
posted Hide Post
So this is what you are currently getting ?

If so, what are you expecting, what goes into line 5 ?


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
Gold member
posted Hide Post
Waz,

I did not send you the complete cluster I did. I provide the most important table which gives you a good idea.

The table contains all the data I need to report. What I want is do not print CYCUMSLC field from line 1 to 4. Print on line 5 and I don't know how to control it.

Please see report sample:

 *** CONFIDENTIEL		En date du 16 Mars 2010												
VENTES ACTUELLES - BUDGET - VISÉE														
Période de  Mars 2010														

				Années cumulées fin Février 2010										
"Centre
Profit"	"
J/M"	"
Sem."	"
J/S"	"2010
RÉEL"	"
MRG"	"
BUDGET"	"MRG
BUD"	"R10/
B10"	"2009
RÉEL"	"
MRG"	"10/
9"	"2008
RÉEL"	"
MRG"	"9/
8"

ALM	23	1	5	682,820										
		2	5	1,365,639										
		3	5	2,048,459										
		4	5	2,731,278										
		5	3	3,140,970										

HUO	23	1	5	491,755										
		2	5	983,510										
		3	5	1,475,265										
		4	5	1,967,020										
		5	3	2,262,073										

 


If the report does not show properly, please tell me how to send you a good copy of it.

Thanks


Marikaki

WF 7.7.03m, MRE, BI Dashboard, DevStudio, Report Caster, Windows 7, I.E. 8/9, Apache Tomcat 6.0, Derby Output formats: Excel2K, PDF, HTML, AHTML

 
Posts: 96 | Location: Montreal, Quebec, Canada | Registered: January 20, 2010Report This Post
Gold member
posted Hide Post
Waz,

column 1: Profit center
column 2: #workable days in the month
column 3: period week (accounting period)
column 4: #workable days in the week
column 5: cumulative sales (CYCUMSLC)

I need to print the sales on period week 5 only ($3,140,970) .

Thank you.


Marikaki

WF 7.7.03m, MRE, BI Dashboard, DevStudio, Report Caster, Windows 7, I.E. 8/9, Apache Tomcat 6.0, Derby Output formats: Excel2K, PDF, HTML, AHTML

 
Posts: 96 | Location: Montreal, Quebec, Canada | Registered: January 20, 2010Report This Post
Gold member
posted Hide Post
Again Waz,

Don't try to match the sample of the table with the report. I didn't take care of providing the same profit center information. If you need it, feel free to ask me.

Plus: on the sample report, each profit center has week #5 sales to print.

Tks.


Marikaki

WF 7.7.03m, MRE, BI Dashboard, DevStudio, Report Caster, Windows 7, I.E. 8/9, Apache Tomcat 6.0, Derby Output formats: Excel2K, PDF, HTML, AHTML

 
Posts: 96 | Location: Montreal, Quebec, Canada | Registered: January 20, 2010Report This Post
Expert
posted Hide Post
Have NODATA set to null. Create a DEFINE for your column. Set it to zero if the line number isn't 5. It should print as a blank for everything but line 5.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Gold member
posted Hide Post
Hi Ginny,

You gave me the logic I needed to manage it. I'm not yet finished with it.

1. When you say set NODATA to null do you mean
quote:
NULL
characters? If it's a value, please show me.

2. In my question I specified line 5 which is the representation of period week #5 in March 2010. In a future month it could be 4 period weeks in the month. Again I am green in reporting with webfocus. Do you believe that I need a hold file to get the max period week in the current accounting period prior to begin the report? If you can help me, I will appreciate your precious help.

Thank you.


Marikaki

WF 7.7.03m, MRE, BI Dashboard, DevStudio, Report Caster, Windows 7, I.E. 8/9, Apache Tomcat 6.0, Derby Output formats: Excel2K, PDF, HTML, AHTML

 
Posts: 96 | Location: Montreal, Quebec, Canada | Registered: January 20, 2010Report This Post
Expert
posted Hide Post
SET NODATA=''

Waz above suggested that you use a demo file to try to explain your issue. You might look at CENTURYSALES as it has dates. Maybe you could use that file to get data that looks like what you want, explain it again in a post with the code, and then we can try to solve your problem that way.

I for one do not completely understand what you want to do as the examples and the requests keep changing.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Gold member
posted Hide Post
Thanks Ginny for NODATA.

When I set 0 into my column it shows a 0 and not a null value. How the DEFINE shoud look?

For the rest, I understand to provide a separate request with an example. Thank you.


Marikaki

WF 7.7.03m, MRE, BI Dashboard, DevStudio, Report Caster, Windows 7, I.E. 8/9, Apache Tomcat 6.0, Derby Output formats: Excel2K, PDF, HTML, AHTML

 
Posts: 96 | Location: Montreal, Quebec, Canada | Registered: January 20, 2010Report This Post
Expert
posted Hide Post
I'm sorry but I steered you a little bit wrong. NODATA only works for 'missing' data. Here is an example:
SET NODATA=''
TABLE FILE CAR
SUM SALES
COMPUTE NEWSALES MISSING ON/I9=IF SALES EQ 0 THEN MISSING ELSE SALES;
BY COUNTRY
END


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Gold member
posted Hide Post
Thanks Ginny. It works fine now. Smiler


Marikaki

WF 7.7.03m, MRE, BI Dashboard, DevStudio, Report Caster, Windows 7, I.E. 8/9, Apache Tomcat 6.0, Derby Output formats: Excel2K, PDF, HTML, AHTML

 
Posts: 96 | Location: Montreal, Quebec, Canada | Registered: January 20, 2010Report 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     [CLOSED]How to print on the last line of a group within Report Painter

Copyright © 1996-2020 Information Builders