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] Free form reports

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Free form reports
 Login/Join
 
Enigma006
Master
posted
Hi

I am new to free form reporting in webfocus though I have done lots of other kind of reports.
Can some one guide me through development of free form reports or post sample code with car file.

I am trying to develop a report that should be something like this.

  

Field1: Data1    Field2: Data2  Field3: Data3
Field4: Data4              Field5: Data5
Field6: Data6

Field7:
Data7

Field8:
Data8

Field9:              Field10: Data10
Data9                Field11: Data11
                     Field12: Data12
                     Field13: Data13


Its basically like an invoice or a bill.
Please provide me suggestions.

Thanks

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


8.1.05
HTML,PDF,EXL2K, Active, All
 
Posts: 484 | Registered: February 03, 2009Report This Post
Waz
Expert
posted Hide Post
What format will the output be ?


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
Enigma006
Master
posted Hide Post
quote:
Originally posted by Waz:
What format will the output be ?


Hi Waz..it will be in Excel or PDF mostly with chances of HTML.


8.1.05
HTML,PDF,EXL2K, Active, All
 
Posts: 484 | Registered: February 03, 2009Report This Post
Waz
Expert
posted Hide Post
For PDF you could use OBJECT=STRING.

DEFINE FILE CAR
 Blank/A1 WITH COUNTRY = ' ' ;
END
TABLE FILE CAR
PRINT Blank AS ''
WHERE RECORDLIMIT EQ 1
ON TABLE SET PAGE NOPAGE
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLESHEET *
TYPE=REPORT, OBJECT=BOX   , NAME='BOX001', POSITION=(0.200 0.400),DIMENSION=(1.10 3.00),BORDER-COLOR=RED, BORDER=HEAVY,BACKCOLOR=RGB(212 212 212),$
TYPE=REPORT, OBJECT=STRING, NAME='text1', TEXT='Text1', POSITION=(0.200 0.400), MARKUP=OFF, WRAP=ON, DIMENSION=(4.234 0.528), font='ARIAL', color=RGB(0 0 0),  size=10, $
TYPE=REPORT, OBJECT=STRING, NAME='text2', TEXT='Text2', POSITION=(0.200 1.400), MARKUP=OFF, WRAP=ON, DIMENSION=(4.234 0.528), font='ARIAL', color=RGB(0 0 0),  size=10, $
TYPE=REPORT, OBJECT=STRING, NAME='text3', TEXT='Text Line 3', POSITION=(2.200 2.400), MARKUP=OFF, WRAP=ON, DIMENSION=(4.234 0.528), font='ARIAL', color=RGB(0 0 0),  size=10, $
ENDSTYLE
END


Each output type may need to be done separately.


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
<FreSte>
posted
Or you could use something like this:
(add SUBHEAD/SUBFOOT's for more detail) 


TABLE FILE CAR
HEADING
"<+0>Country<+0>: <COUNTRY <+0>Car<+0>: <CAR"
"<+0> <+0>Other text<+0>: Some other stuff <SEATS"
" "
" "
FOOTING
" "

BY COUNTRY NOPRINT
ON COUNTRY PAGE-BREAK

BY CAR NOPRINT
BY MODEL NOPRINT

ON TABLE SET LINES 99999
ON TABLE SET TITLES OFF
ON TABLE SET PAGE NOPAGE
ON TABLE SET HTMLCSS ON

ON TABLE SET STYLE *
TYPE=REPORT     ,UNITS=PTS   ,FONT='VERDANA', SIZE=8        ,$
TYPE=REPORT     ,BORDER=0    ,BORDER-COLOR=RGB(210 210 210) ,$

TYPE=HEADING, LINE=1 ,OBJECT=TEXT  ,ITEM=1, STYLE=BOLD ,$
TYPE=HEADING, LINE=1 ,OBJECT=FIELD ,ITEM=1, WIDTH=80   ,$
TYPE=HEADING, LINE=1 ,OBJECT=TEXT  ,ITEM=4, STYLE=BOLD ,$
TYPE=HEADING, LINE=1 ,OBJECT=FIELD ,ITEM=2, WIDTH=80   ,$

TYPE=HEADING, LINE=2 ,OBJECT=TEXT  ,ITEM=1, WIDTH=131   ,$

ENDSTYLE
END
 
Report This Post
Enigma006
Master
posted Hide Post
Hi Freste

This method is working good for me as I started to use it. But this looks like HTML format.
Is it a different way for Excel?
quote:
Originally posted by FreSte:
Or you could use something like this:
(add SUBHEAD/SUBFOOT's for more detail) 


TABLE FILE CAR
HEADING
"<+0>Country<+0>: <COUNTRY <+0>Car<+0>: <CAR"
"<+0> <+0>Other text<+0>: Some other stuff <SEATS"
" "
" "
FOOTING
" "

BY COUNTRY NOPRINT
ON COUNTRY PAGE-BREAK

BY CAR NOPRINT
BY MODEL NOPRINT

ON TABLE SET LINES 99999
ON TABLE SET TITLES OFF
ON TABLE SET PAGE NOPAGE
ON TABLE SET HTMLCSS ON

ON TABLE SET STYLE *
TYPE=REPORT     ,UNITS=PTS   ,FONT='VERDANA', SIZE=8        ,$
TYPE=REPORT     ,BORDER=0    ,BORDER-COLOR=RGB(210 210 210) ,$

TYPE=HEADING, LINE=1 ,OBJECT=TEXT  ,ITEM=1, STYLE=BOLD ,$
TYPE=HEADING, LINE=1 ,OBJECT=FIELD ,ITEM=1, WIDTH=80   ,$
TYPE=HEADING, LINE=1 ,OBJECT=TEXT  ,ITEM=4, STYLE=BOLD ,$
TYPE=HEADING, LINE=1 ,OBJECT=FIELD ,ITEM=2, WIDTH=80   ,$

TYPE=HEADING, LINE=2 ,OBJECT=TEXT  ,ITEM=1, WIDTH=131   ,$

ENDSTYLE
END


8.1.05
HTML,PDF,EXL2K, Active, All
 
Posts: 484 | Registered: February 03, 2009Report This Post
Enigma006
Master
posted Hide Post
Waz, any ways for Excel?
quote:
Originally posted by Waz:
For PDF you could use OBJECT=STRING.

DEFINE FILE CAR
 Blank/A1 WITH COUNTRY = ' ' ;
END
TABLE FILE CAR
PRINT Blank AS ''
WHERE RECORDLIMIT EQ 1
ON TABLE SET PAGE NOPAGE
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLESHEET *
TYPE=REPORT, OBJECT=BOX   , NAME='BOX001', POSITION=(0.200 0.400),DIMENSION=(1.10 3.00),BORDER-COLOR=RED, BORDER=HEAVY,BACKCOLOR=RGB(212 212 212),$
TYPE=REPORT, OBJECT=STRING, NAME='text1', TEXT='Text1', POSITION=(0.200 0.400), MARKUP=OFF, WRAP=ON, DIMENSION=(4.234 0.528), font='ARIAL', color=RGB(0 0 0),  size=10, $
TYPE=REPORT, OBJECT=STRING, NAME='text2', TEXT='Text2', POSITION=(0.200 1.400), MARKUP=OFF, WRAP=ON, DIMENSION=(4.234 0.528), font='ARIAL', color=RGB(0 0 0),  size=10, $
TYPE=REPORT, OBJECT=STRING, NAME='text3', TEXT='Text Line 3', POSITION=(2.200 2.400), MARKUP=OFF, WRAP=ON, DIMENSION=(4.234 0.528), font='ARIAL', color=RGB(0 0 0),  size=10, $
ENDSTYLE
END


Each output type may need to be done separately.


8.1.05
HTML,PDF,EXL2K, Active, All
 
Posts: 484 | Registered: February 03, 2009Report This Post
Waz
Expert
posted Hide Post
If you can get it working for HTML, then you can return the reprot as Excel.

Hold the HTML report as a name, then...

SET HTMLFORMTYPE=XLS
-HTMLFORM {name}


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
Enigma006
Master
posted Hide Post
Hi Freste

This method is workig good for me.
I am trying to WRAP a big text field which is in the heading. I am able to wrap a normal field in PRINT but in heading, same techniques does not work. When I print this in PDF, only some text is getting displayed and other text is just gone. I want that to go to next line.

Can you let me know any technique.

Thank you


8.1.05
HTML,PDF,EXL2K, Active, All
 
Posts: 484 | Registered: February 03, 2009Report This Post
Dgraff
Gold member
posted Hide Post
Another method is to do it entirely as a heading and turn the alignment grid on. I had to use this when trying to match a given format for a state reporting requirement. It worked in all three output formats but Excel and PDF for sure.


Duane

WebFOCUS 8.0.7
DS 8.0.7 AS 8.0.7
Windows
Output: Excel, HTML, PDF, AHTML,Mobile
In Focus 1982
 
Posts: 83 | Location: Princeton NJ | Registered: October 26, 2007Report This Post
Enigma006
Master
posted Hide Post
Hi Dgraff

I already this option before posting here. It did not work for me or I did something wrong?!
quote:
Originally posted by Dgraff:
Another method is to do it entirely as a heading and turn the alignment grid on. I had to use this when trying to match a given format for a state reporting requirement. It worked in all three output formats but Excel and PDF for sure.


8.1.05
HTML,PDF,EXL2K, Active, All
 
Posts: 484 | Registered: February 03, 2009Report This Post
<FreSte>
posted
I once also had a problem formatting long text in PDF. Maybe this post can help you any further.

-Fred
 
Report This Post
Enigma006
Master
posted Hide Post
Hi Freste
everythign is working good and I am able to get the report well except one issue. Smiler

When I have 2 fields in a line, when one field length increases (number of characters), the other text and fields in same line are moving towards right and if it decreases, they are moving towards left. Can we make them fixed without movement?

Thank you..


8.1.05
HTML,PDF,EXL2K, Active, All
 
Posts: 484 | Registered: February 03, 2009Report This Post
ABT
Master
posted Hide Post
Would this not be as simple as Defining the field the data would be in? Is your data Variable length?
- ABT


------------------------------------
WF Environment:
------------------------------------
Server/Client, ReportCaster, Dev Studio: 7.6.11
Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist
OS: Windows Server 2003
Application/Web Server: Tomcat 5.5.25
Java: JDK 1.6.0_03
Authentication: LDAP, MRREALM Driver
Output: PDF, EXL2K, HTM

------------------------------------
Databases:
------------------------------------
Oracle 10g
DB2 (AS/400)
MSSQL Server 2005
Access/FoxPro
 
Posts: 561 | Registered: February 03, 2010Report This Post
Waz
Expert
posted Hide Post
This is where you will have the most problems.

This can be handled in the stylesheet, but you will have different code for different formats.

You will also need to decide if the first field gets too long, do you truncate it, or wrap it.


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
Enigma006
Master
posted Hide Post
quote:
Originally posted by ABT:
Would this not be as simple as Defining the field the data would be in? Is your data Variable length?
- ABT


yes its variable. number is D20.2 format, so it could be of any length..


8.1.05
HTML,PDF,EXL2K, Active, All
 
Posts: 484 | Registered: February 03, 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     [CLOSED] Free form reports

Copyright © 1996-2020 Information Builders