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] report white one hader ond more then 50 row

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] report white one hader ond more then 50 row
 Login/Join
 
shmulik
Member
posted
hi to all
im trying to send an htmltable to excel its work fine bu the max row of data is 50 and after that im getting the hader agine and the rest of the data how can i set the reoprt to be in one hader and more than 50 row??

the exsample code is :

TABLE FILE CAR
PRINT CAR MODEL SEATS
BY COUNTRY
 
ON TABLE HOLD AS SHORT  FORMAT HTMTABLE  
 
 
END
-RUN
SET HTMLFORMTYPE= XLS
-HTMLFORM BEGIN
<html>
<head>
<body leftmargin="0" rightmargin="0" topmargin="0" bottommargin="0" bgcolor="F3F3F3">
<table dir="rtl" border="2" align="RIGHT">
<tr>
 
<td >
!IBI.FIL.SHORT;
 
</td>
</tr>
</table>
 
</body>
</html>
 
-HTMLFORM END

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


WebFOCUS 7.1.6
Windows
Excel
 
Posts: 14 | Registered: January 28, 2010Report This Post
Tony A
Expert
posted Hide Post
SET LINES = 999999

Must be 999999 and not 99999 or 9999999 - check the documentation

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
shmulik
Member
posted Hide Post
tnx
set lines=999999 work great
but i have one more problem...
when i get the report in the excel the rest of the grid i disaper... i have onle the grid for the data how can i set the grid in all the excel page??
tnx


WebFOCUS 7.1.6
Windows
Excel
 
Posts: 14 | Registered: January 28, 2010Report This Post
Tony A
Expert
posted Hide Post
Check out the styling documentation. Also look through Mickey Grackins articles in the "developer centre" under "tips and techniques"

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
shmulik
Member
posted Hide Post
hii tony
i look all over styling documentation
and dident find noting about non grid report

it will be very helpful if you can give me a link or somthing

thet can help me

many tnk!!!


WebFOCUS 7.1.6
Windows
Excel
 
Posts: 14 | Registered: January 28, 2010Report This Post
rfbowley
Platinum Member
posted Hide Post
SET LINES=9999


Robert F. Bowley Jr.
Owner
TaRa Solutions, LLC

In WebFOCUS since 2001
 
Posts: 132 | Location: Gadsden, Al | Registered: July 22, 2005Report This Post
shmulik
Member
posted Hide Post
quote:
tnx
set lines=999999 work great
but i have one more problem...
when i get the report in the excel the rest of the grid i disaper... i have onle the grid for the data how can i set the grid in all the excel page??
tnx

tnx
set lines=999999 work great
but i have one more problem...
when i get the report in the excel the rest of the grid i disaper... i have onle the grid for the data how can i set the grid in all the excel page??
tnx


WebFOCUS 7.1.6
Windows
Excel
 
Posts: 14 | Registered: January 28, 2010Report This Post
Francis Mariani
Expert
posted Hide Post
shmulik, please edit your original post and place your code between code tags, like this:

[code]

TABLE FILE CAR
...


[/code]

The HTML within your HTMLFORM is not displayed as code because the forum software interprets it as HTML.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Francis Mariani
Expert
posted Hide Post
What do you mean by "When I get the report in Excel the rest of the grid disappears... I have only the grid for the data, how can I set the grid for the whole the Excel worksheet?"

Are you expecting Excel borders around every cell in the Excel worksheet?

Have you tried ON TABLE PCHOLD FORMAT EXL2K instead of SET HTMLFORMTYPE=XLS?


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
shmulik
Member
posted Hide Post
Tnk FOR THE REPLAY
IM USING HTMLFORMTYPE=XLS BECUASE I HAVE TO SET "DIR=RTL"

AND YES IM expecting Excel borders around every cell in the Excel worksheet BUT EVERY CELL IS WHITE NO BORDER

HOW CA I SOLVE THIS??

the code is
TABLE FILE CAR
SUM
     DEALER_COST
     RETAIL_COST
     SALES
BY COUNTRY NOPRINT
BY SEATS
HEADING
"SALES REPORT FOR COUNTRY <COUNTRY"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD FORMAT HTMTABLE AS AAA
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,

$
TYPE=REPORT,
     GRID=ON,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
     COLOR='BLACK',
     BACKCOLOR='NONE',

$
TYPE=HEADING,
     JUSTIFY=CENTER,
$
TYPE=REPORT,
     COLUMN=N6,
     WRAP=8.000000,
$
TYPE=REPORT,
     COLUMN=N7,
     WRAP=8.000000,
$
ENDSTYLE
END
-RUN
SET HTMLFORMTYPE= XLS
-HTMLFORM BEGIN
<html>
<body>
<table dir="rtl"  align="right">
<tr>
<td>
!IBI.FIL.AAA;
</td>
</tr>
</table>
</body>
</html>
-HTMLFORM END

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


WebFOCUS 7.1.6
Windows
Excel
 
Posts: 14 | Registered: January 28, 2010Report This Post
Dan Satchell
Virtuoso
posted Hide Post
You are generating an HTML report with grid lines and then dropping that report into Excel. So I doubt there is a way to create grid lines for the remaining empty cells in the spreadsheet with this method, except maybe with an Excel template.


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Report This Post
Francis Mariani
Expert
posted Hide Post
I think HEADALIGN=BODY may solve the problem.

Not very elegant, but here's one possible solution:

TABLE FILE CAR
SUM
COMPUTE HEADING1/A50 = 'SALES REPORT FOR COUNTRY ' | COUNTRY; NOPRINT
COMPUTE DUMMY1/A1 = ''; NOPRINT
     DEALER_COST
     RETAIL_COST
     SALES
BY COUNTRY NOPRINT
BY SEATS
HEADING
"<HEADING1 <DUMMY1 <DUMMY1 <DUMMY1"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD FORMAT HTMTABLE AS AAA
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,

$
TYPE=REPORT,
     GRID=ON,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
     COLOR='BLACK',
     BACKCOLOR='NONE',

$
TYPE=HEADING, HEADALIGN=BODY,
     JUSTIFY=CENTER,
$
TYPE=REPORT,
     COLUMN=N6,
     WRAP=8.000000,
$
TYPE=REPORT,
     COLUMN=N7,
     WRAP=8.000000,
$
ENDSTYLE
END
-RUN

SET HTMLFORMTYPE= XLS
-HTMLFORM BEGIN
<html>
<body>
<table dir="rtl"  align="right">
<tr>
<td>
!IBI.FIL.AAA;
</td>
</tr>
</table>
</body>
</html>
-HTMLFORM END


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Francis Mariani
Expert
posted Hide Post
On the hand, I don't think this solves your problem. You want Excel borders to appear on ALL cells, including those that are empty, non-report cells? As Dan states, I don't think this is possible without using an Excel template.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
shmulik
Member
posted Hide Post
[SOLVED]?


WebFOCUS 7.1.6
Windows
Excel
 
Posts: 14 | Registered: January 28, 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     [SOLVED] report white one hader ond more then 50 row

Copyright © 1996-2020 Information Builders