TexasStingray,

It's just that I'm a little tired of reading the veiled religious message in your signature and would rather see nothing at all or which version/platform you work on.

Cheers,

If you are only going to create HTML output you can use defined fields that contain < br > for the literals in the heading. This will cause each line of the heading be displayed as three lines in the browse.

DEFINE FILE CAR
H_ORIGIN /A30 WITH COUNTRY ='<br> ORIGIN <br> &|nbsp';
H_COMP /A30 WITH CAR ='<br> COMP <br> &|nbsp';
H_CARREC /A30 WITH MODEL ='<br> CARREC <br> &|nbsp';
H_WARRANT /A30 WITH WARRANTY ='<br> WARRANT <br> &|nbsp';
H_EQIP /A30 WITH STANDARD ='<br> EQIP <br> &|nbsp';

END
-RUN
TABLE FILE CAR
PRINT
COUNTRY
CAR
MODEL
WARRANTY
STANDARD
HEADING
"<H_ORIGIN<H_COMP"
" <H_CARREC<H_WARRANT<H_EQIP"
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
$
TYPE=REPORT, GRID = ON,$
TYPE=HEADING, HEADALIGN = BODY, STYLE= BOLD, $
TYPE=HEADING, LINE = 1, ITEM = 1, COLSPAN=1,$
TYPE=HEADING, LINE = 1, ITEM = 2, COLSPAN=4,$

TYPE=HEADING, LINE = 2, ITEM = 1, COLSPAN=1,$
TYPE=HEADING, LINE = 2, ITEM = 2, COLSPAN=2,$
TYPE=HEADING, LINE = 2, ITEM = 3, COLSPAN=1,$
TYPE=HEADING, LINE = 2, ITEM = 4, COLSPAN=1,$

END

Close, but no cigar, yet... Perhaps someone can expand from this. The !IBI.AMP.XXX; gets evaluated once the H001 file gets evaluated within the -HTMLFORM commands. An empty TD gets generated in the HEADING lines which ends up misaligning the heading so I added a dummy report column.

Not pretty, but you have row span.

-SET &ECHO=ALL;

-SET &HEAD1 = '</TD><TD ROWSPAN=2><B>ORIGIN</B></TD><TD COLSPAN=4><B>COMP</B></TD>';
-SET &HEAD2 = '</TD><TD COLSPAN=2><B>CARREC</B></TD><TD><B>WARRANT</B></TD><TD><B>EQIP</B></TD>';

TABLE FILE CAR
PRINT
COMPUTE DUMMY1/A1 = ''; AS ''
COUNTRY
CAR
MODEL
WARRANTY
STANDARD

HEADING
"!IBI.AMP.HEAD1;"
"!IBI.AMP.HEAD2;"

ON TABLE HOLD AS H001 FORMAT HTML

ON TABLE SET STYLE *
TYPE=REPORT, GRID = ON, $
TYPE=HEADING, HEADALIGN = BODY, $
END
-RUN

-HTMLFORM BEGIN
!IBI.FIL.H001;
-HTMLFORM END

Is it possible to do the same thing as above in excel and without using HTMLFORM and without the blank column at the begining?

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

Have you looked into EXL2K/EXL07 TEMPLATE?

quote:

Excel templates enable users to create WebFOCUS reports with any new or existing Excel workbook residing on the WebFOCUS Reporting Server. WebFOCUS can integrate with complex Excel workbooks containing macros, graphs, or Visual Basic applications with the use of Excel templates. Users also have access to more advanced Excel functionality including filters, subtotals, page and print settings, and advanced report styling.

I have used excel templates before, but I wasn't sure about one thing needed for this report. Can an excel temple handle BYTOC functionality, for example there is a workbook with multiple sheets but one of the sheets can spawn into multiple depending on data.

Good question, for which I don't have an answer. I'd give it a try.

I've done rowspan in Excel with a formatting macro.

I've also created reports with filtered sub-totals and distinct count filtered sub-totals.

I've also used formatting macros to insert cell comments.

I also taken workbooks that users have created their own graphs and charts, saved that has a template file, then load fresh data and they have updated charts and graphs. Also created workbooks that when the user opens the workbook, it runs a fex and refreshes the data in the report.

I haven't found anything yet that my users have requested that I can't do with WebFOCUS and Excel macros. I'll use WebFOCUS to collect and format the report as much as WebFOCUS can do and finish the job with excel macros.

getit, BYTOC is not compatible macro enabled templates. But you can get around that by looping through your code for each BYTOC value. For example, say you have a 5 regions, 1 through 5. Loop through the actual report code put Region 1 on Sheet 1, Region 2 on Sheet 2, etc. If the completed report only contains data for Region 2 (Sheet 2) then your macro can delete the empty sheets leaving a report with just 1 sheet holding the data for Region 2.

Another way to handle this is with excel filtered subtotals using excels subtotal function. The user gets all the data but if they are only interested in Region 2, they filter the report on region 2 and the subtotal recalculate for region 2.