[SOLVED] report white one hader ond more then 50 row
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
February 02, 2010, 03:09 AM
Tony A
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
February 02, 2010, 03:36 AM
shmulik
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
February 02, 2010, 03:59 AM
Tony A
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
February 02, 2010, 04:33 AM
shmulik
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
February 02, 2010, 09:02 AM
rfbowley
SET LINES=9999
Robert F. Bowley Jr. Owner TaRa Solutions, LLC
In WebFOCUS since 2001
February 02, 2010, 09:05 AM
shmulik
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
February 02, 2010, 10:35 AM
Francis Mariani
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
February 02, 2010, 10:40 AM
Francis Mariani
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
February 03, 2010, 12:46 AM
shmulik
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
February 03, 2010, 06:38 AM
Dan Satchell
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
February 03, 2010, 12:18 PM
Francis Mariani
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
February 03, 2010, 12:21 PM
Francis Mariani
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
