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     [SOLVED] Space between Title and Data

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Space between Title and Data
 Login/Join
 
Guru
posted
Is there away to have one or two empty rows between the Title and Data?

|--------| |--------| |--------|
| Title | | Title | | Title |
|--------| |--------| |--------|
- Empty Row 1
- Empty Row 2
Data Data Data Data

But I dont want to add title as part of Heading?

Is there a way to do this ? In HTML and PDF.

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


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Report This Post
Master
posted Hide Post
Ram, You need to insert that many rows into the hold file. Either use -WRITE in case of ALPHA hold file or Use MATCH command or SQL Translator to insert into FOCUS File.

DEFINE FILE CAR
DUMMY_1/A1='2';
END
TABLE FILE CAR
PRINT
CAR
COUNTRY
BY DUMMY_1
ON TABLE HOLD AS HLD_1 FORMAT ALPHA
END
DEFINE FILE CAR
DUMMY_1/A1='1';
END
TABLE FILE CAR
SUM
COMPUTE SALES1/D20=SALES;
BY DUMMY_1
BY COUNTRY
WHERE COUNTRY EQ 'ENGLAND' OR 'ITALY'
ON TABLE HOLD AS HLD_2 FORMAT ALPHA
END

MATCH FILE HLD_1
PRINT
CAR
COUNTRY
BY DUMMY_1
RUN
FILE HLD_2
PRINT
SALES1
BY DUMMY_1
AFTER MATCH HOLD OLD-OR-NEW
END
-RUN
TABLE FILE HOLD
PRINT
CAR AS 'Car'
COUNTRY AS 'Country'
BY DUMMY_1 NOPRINT
END
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Report This Post
Virtuoso
posted Hide Post
If it is just adding two extra empty lines at the start of the report, try adding ON TABLE SUBHEAD with two empty lines ("") underneath it.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Guru
posted Hide Post
Thanks Ram and Gamp.

Gamp.. My reqmt is to have empty spaces between Title and Data. Not the top of the report.

Ram... Your thing worked. But the report is already complex with lot of Joins and Matches.

Looking for some more opt and optimized way....

Roll Eyes


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Report This Post
Virtuoso
posted Hide Post
You can take Gamp Idea and make the titles you will have to align them with the data but here's the idea
TABLE FILE CAR
PRINT   
CAR AS ' '
SALES AS ' '
ON TABLE SUBHEAD
"CAR   SALES"
" 
"
END  


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Virtuoso
posted Hide Post
My mistake, should not be on TABLE but on a field. Like:
DEFINE FILE CAR
SPACE/A1=' ';
END
TABLE FILE CAR
PRINT CAR SALES
BY SPACE NOPRINT
ON SPACE SUBHEAD
" " 
" "
END


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Guru
posted Hide Post
Using Gamp's first idea, you can make the TITLE a header / sub header followed by 2 empty lines.


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
 
Posts: 398 | Registered: February 04, 2008Report This Post
Expert
posted Hide Post
The issue with this solution is that it will only work on the first page.

Perhaps this may help. It expands on GamP's suggestion.

DEFINE FILE TRADES
CNTR/I9 = LAST CNTR  + 1 ;
END
TABLE FILE TRADES
PRINT *
      TABPAGENO
BY CNTR NOPRINT
ON CNTR SUBHEAD
" " 
" "
WHEN TABPAGENO NE LAST TABPAGENO

WHERE RECORDLIMIT EQ 100
END


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
Guru
posted Hide Post
quote:
DEFINE FILE CAR
SPACE/A1=' ';
END
TABLE FILE CAR
PRINT CAR SALES
BY SPACE NOPRINT
ON SPACE SUBHEAD
" "
" "
END



Waz and Gamp.. That worked perfect. Thank you folks for your kind reply.


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Report This Post
Guru
posted Hide Post
Try this

TABLE FILE CAR
PRINT COUNTRY AS 'COUNTRY, , , '
END


WebFOCUS DS 8.0.06/08 DS/AS
WebFOCUS RS 8.0.08 (Linux/IBM i)
WebFOCUS Client 8.0.06 (Linux)
 
Posts: 319 | Location: Stockholm, Sweden | Registered: February 04, 2004Report This Post
Virtuoso
posted Hide Post
H,

That's a new on me. I think that is what they wanted.
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Platinum Member
posted Hide Post
I think this gives you what you're looking for and it's extremely simple coding. You will need stylesheet logic to place your heading properly.
  
DEFINE FILE CAR
BLANK/A1 = '';
END
TABLE FILE CAR
HEADING
"COUNTRY <+0> CAR <+0> SALES"
PRINT BLANK AS ''
OVER
BLANK AS ''
OVER
COUNTRY AS ''
CAR AS ''
SALES AS ''
BY COUNTRY NOPRINT
END
-EXIT


WF 7.7.05
HP-UX - Reporting Server, Windows 2008 - Client, MSSQL 2008, FOCUS Databases, Flat Files
HTML, Excel, PDF
 
Posts: 149 | Location: Dallas, TX | Registered: June 08, 2007Report This Post
Guru
posted Hide Post
In this case bordering will be quite a problem....

PRINT COUNTRY AS 'COUNTRY, , , '


Because, the entire title will be boxed.

I used Gamp's code

DEFINE FILE CAR
SPACE/A1=' ';
END
TABLE FILE CAR
PRINT CAR SALES
BY SPACE NOPRINT
ON SPACE SUBHEAD
" "
" "
END



and Styled Subhead to make all borders transparent. That made it perfect.


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Report 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     [SOLVED] Space between Title and Data

Copyright © 1996-2020 Information Builders