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--duplicate POST]Indenting columns in an Excel Report

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED--duplicate POST]Indenting columns in an Excel Report
 Login/Join
 
Guru
posted
I created a report that opens up in Excel. It is a report that uses the OVER statement that generates about 12 category lines over one another on the Excel report. I need to indent some of those rows a couple of spaces. Does anyone know how I would do that. I tried using the IN statement but it did not work. Thanks.


Windows 7
WF 761

This message has been edited. Last edited by: Michele Brooks,


WF 8205, Windows 10
Oracle DBMS
EXL07/PDF Output
 
Posts: 244 | Registered: August 27, 2012Report This Post
Guru
posted Hide Post
I have noticed that over messes up the spacing a little. If nobody provides a solution, I would use across instead of over:

 
TABLE FILE CAR
ACROSS COUNTRY AS ''
ACROSS CAR AS ''
...
 


In the stylesheet you might be able to justify some of the columns center/left and the others right to meet your needs.


WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs
 
Posts: 402 | Location: Upland, IN | Registered: June 08, 2012Report This Post
Expert
posted Hide Post
Hi Michele, Could you provide a sample of this using TABLE FILE CAR? That would help us to more easily resolve this for you.
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Guru
posted Hide Post
I need RCost and Sales indented 3 spaces. Thanks.

SET ASNAMES = ON
DEFINE FILE CAR
TODAYS_DATE/YYMD = '&YYMD';
SORT_YR/YY = TODAYS_DATE;
MTH_NAME/A10 = IF DEALER_COST GE 0 AND DEALER_COST LE 5000 THEN 'January' ELSE
IF DEALER_COST GE 5001 AND DEALER_COST LE 5099 THEN 'February' ELSE
IF DEALER_COST GE 5010 THEN 'March' ELSE ' ';
-*AYEAR/A4 = '2013';
AYEAR/A4 = EDIT(SORT_YR,'9999');
MTH_SORT/A2= DECODE MTH_NAME (
'January' '01'
'February' '02'
'March' '03'
ELSE ' ');
END
TABLE FILE CAR
SUM DEALER_COST AS 'DCOST1'
RETAIL_COST AS 'RCOST1'
SALES AS 'SALES1'
BY SORT_YR
BY AYEAR
BY MTH_SORT
BY MTH_NAME
ON TABLE HOLD AS HOLD1 FORMAT ALPHA
END
DEFINE FILE CAR
TODAYS_DATE/YYMD = '&YYMD';
SORT_YR/YY = TODAYS_DATE;
MTH_NAME/A10 = 'Total';
AYEAR/A4 = EDIT(SORT_YR,'9999');
MTH_SORT/A2 = '13';
END
TABLE FILE CAR
SUM DEALER_COST AS 'DCOST2'
RETAIL_COST AS 'RCOST2'
SALES AS 'SALES2'
BY SORT_YR
BY AYEAR
BY MTH_SORT
BY MTH_NAME
ON TABLE HOLD AS HOLD2 FORMAT ALPHA
END
MATCH FILE HOLD1
SUM DCOST1
RCOST1
SALES1
BY SORT_YR
BY AYEAR
BY MTH_SORT
BY MTH_NAME
RUN
FILE HOLD2
SUM DCOST2
RCOST2
SALES2
BY SORT_YR
BY AYEAR
BY MTH_SORT
BY MTH_NAME
AFTER MATCH HOLD AS HOLD3 OLD-OR-NEW
END
DEFINE FILE HOLD3
DCOST/D12.2CM = DCOST1 + DCOST2;
RCOST/D12.2CM = RCOST1 + RCOST2;
SALES/I9C = SALES1 + SALES2;
TITLE_NAME/A15 = 'Dealer Cost';
SORT_YR/A4 = IF AYEAR NE '9999' THEN AYEAR ELSE '';
END
TABLE FILE HOLD3
SUM DCOST AS 'Dcost' OVER
RCOST AS 'RCost' OVER
SALES AS 'Sales'
BY TITLE_NAME NOPRINT
ACROSS AYEAR NOPRINT
ACROSS SORT_YR AS ''
ACROSS MTH_SORT NOPRINT
ACROSS MTH_NAME AS ''
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
END


WF 8205, Windows 10
Oracle DBMS
EXL07/PDF Output
 
Posts: 244 | Registered: August 27, 2012Report This Post
Master
posted Hide Post
I do this all the time. Try using:

SET SHOWBLANKS=ON

or

ON TABLE SET SHOWBLANKS ON

ON Preserves leading blanks internal blanks in HTML and EXL2K report output. Also preserves trailing blanks in heading, subheading, footing, and subfooting lines that use the default heading or footing alignment


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 975 | Location: Oklahoma City | Registered: October 27, 2006Report This Post
Guru
posted Hide Post
quote:
ON TABLE SET SHOWBLANKS ON


I tried your suggestion both ways and the SHOWBLANKS did not work.


WF 8205, Windows 10
Oracle DBMS
EXL07/PDF Output
 
Posts: 244 | Registered: August 27, 2012Report This Post
Master
posted Hide Post
I'm on 7.6.11 and I have maybe a dozen EXL2K report of all kinds: compound, compound with EXL2K TEMPLATE, reports using OVER and FML (or EML or whatever it is call now) and just plain Jane EXL2K, and it works exactly as is stated in the documentation in all of them. Maybe it is a bug in 7.1.7.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 975 | Location: Oklahoma City | Registered: October 27, 2006Report This Post
Guru
posted Hide Post
It still works in 7.7.03. Perhaps Michele didn't know what it was for:
 
DEFINE FILE CAR
sales/A9='   ' | EDIT(CAR.BODY.SALES);
END
TABLE FILE CAR
SUM 
     CAR.CARREC.MODEL AS '' OVER 
     CAR.BODY.sales AS ''
ACROSS CAR.COMP.CAR
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET SHOWBLANKS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
ENDSTYLE
END
 


You should be able to adapt this to your scenario.


WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs
 
Posts: 402 | Location: Upland, IN | Registered: June 08, 2012Report This Post
Guru
posted Hide Post
I am using a macro template to generate this report and whenever I use SHOWBLANKS, the macro template will not work. Thanks.


WF 8205, Windows 10
Oracle DBMS
EXL07/PDF Output
 
Posts: 244 | Registered: August 27, 2012Report This Post
Silver Member
posted Hide Post
SET BLANKINDENT = ON

and have a space in your AS name like ' Title'


Prod/Dev: WebFOCUS 8.0.06 on Windows Server 2008/Tomcat , WebFOCUS DevStudio 8.0.06 on Windows 7
 
Posts: 31 | Registered: April 22, 2013Report This Post
Guru
posted Hide Post
quote:
SET BLANKINDENT = ON

Thank you for your suggestion, but it did not work. Nothing was indented,


WF 8205, Windows 10
Oracle DBMS
EXL07/PDF Output
 
Posts: 244 | Registered: August 27, 2012Report This Post
Guru
posted Hide Post
Hi Michele,

Some days before, i faced a scenario of positioning the datas within a CELL in EXCEL and got it resolved.

It may helps you out.

http://forums.informationbuild...957006136#1957006136

Thanks,
Rifaz


-Rifaz

WebFOCUS 7.7.x and 8.x
 
Posts: 406 | Location: India | Registered: June 13, 2013Report This Post
Guru
posted Hide Post
Thank you for your response, but I did not explain my problem correctly. I do not need to indent the data values in the report. I need to indent the ASNAMES. For example:

If the ASNAME is

Green Grocer

I need it to appear indented as
Green Grocer

Leaving two blank spaces in front of Green Grocer does not work when using OVER. My apologies for not posting my problem correctly. I already tried SHOWBLANKS and CLASS=indent in the stylesheet. Neither works. Thanks.


WF 8205, Windows 10
Oracle DBMS
EXL07/PDF Output
 
Posts: 244 | Registered: August 27, 2012Report This Post
Guru
posted Hide Post
[Closed] I figured out another way. Centering the Top line column heading worked for what I wanted to do. I thank everyone for their responses.


WF 8205, Windows 10
Oracle DBMS
EXL07/PDF Output
 
Posts: 244 | Registered: August 27, 2012Report 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--duplicate POST]Indenting columns in an Excel Report

Copyright © 1996-2020 Information Builders