HTML Table in heading

June 19, 2007, 11:48 AM

Norb Eckert

Hi All,

Does anyone know of a way to put a table into a heading that can be populated with header text in the cells?

I want to have multiple columns in the header and have the text be hyperlinks to do other things such as output options (Excel, PDF, AHTML) or hiding or showing columns etc. Currently I have to list each line of text and it's taking up a lot of screen real estate.

Thanks,

Norb

June 19, 2007, 11:56 AM

Darin Lee

Not quite sure what you're looking for. Are you talking about a HEADING in a report request? There isn't a way to do that. However, there is a way to align heading text into columns and assign hyperlinks to the text items. You can also assign most of that functionality to column titles. Sounds like what you are needing is Active Report functionality. Check it out on the website.

Regards,

Darin

In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat

June 19, 2007, 12:05 PM

Norb Eckert

Hi Darin,

Yep I'm talking about a heading in a report request. I can do the columns but I'd really like to do this in the header. Don't you think that something with HTMTABLE or something could be done?

Thanks,

Norb

June 19, 2007, 12:19 PM

Darin Lee

I doubt it. The only things that you can include in headings are something you can include in between the double quotes, including fieldnames, etc. I know you can include code that would display correctly in an HTML page like an HREF= or IMG=, so you might be able to include whatever HTML code would display the table correctly. It would have to previously exist somewhere

Regards,

Darin

June 19, 2007, 12:26 PM

Norb Eckert

Bummer!

O.K. I'll have to come up with something else. Maybe an HTML page in the HTML Layout tool where I create the header and then have an output frame. Just thinking out loud.

Thanks again.

Norb

June 19, 2007, 12:29 PM

Tony A

Norb,

Depending if you wanted any other output than HTML. For instance you could just use HTMTABLE output plugged into HTMLFORM -

TABLE FILE CAR
SUM COMPUTE SPC/A1='';
ACROSS COUNTRY
ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE NOLEAD
ON TABLE HOLD AS HEADER FORMAT HTMTABLE
END
-RUN
TABLE FILE CAR
SUM RCOST DCOST
BY COUNTRY
BY CAR
BY MODEL
ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE NOLEAD
ON TABLE HOLD AS BODY FORMAT HTMTABLE
END
-RUN
-HTMLFORM BEGIN
<html>
<head>
<title>Test</title>
!IBI.FIL.HEADER;
</head>
<body>
!IBI.FIL.BODY;
</body>
</html>
-HTMLFORM END

June 19, 2007, 12:51 PM

Norb Eckert

Hey! This is what I was kindof thinking. I've used the HTMTABLE in the body but didn't know how to push a separate header. I think this could work. I'll put a scope on it and see what I come up with.

Thanks muy mucho!

Norb

June 19, 2007, 01:32 PM

mgrackin

Norb,

Here's another sneaky why to do this which literally puts it in the HEADING of the report.

TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
ON TABLE HOLD AS 'HEADING' FORMAT HTMTABLE
END
-RUN
TABLE FILE CAR
HEADING
"!IBI.FIL.HEADING;"
PRINT SALES
BY COUNTRY
BY CAR
BY MODEL
BY BODYTYPE
ON TABLE HOLD AS 'FINAL' FORMAT HTML
END
-RUN
-HTMLFORM FINAL

June 19, 2007, 01:59 PM

Darin Lee

There you go! Whenever you think there's not a way to do it, someone know a way around the problem.

Regards,

Darin

June 19, 2007, 02:04 PM

Norb Eckert

Hi Mickey,

That's a great addition to the previous technique. I like this as it's a bit cleaner. And Mom always said that "Cleanliness is next to Godliness". Thanks.

BTW, haven't talked to you since Summit. Hope all is well.

See ya,

Norb

June 19, 2007, 02:34 PM

susannah

Norb,
there's always

-SET &MYHEADER = '<TABLE><TR><TD>LA DE DA</TD><TR><TABLE>' ;
then
TABLE FILE CAR
HEADING
" &MYHEADER "
END

You can't actually code the html tags directly into the HEADING, you have to do it via an &var,
which is probably what was tripping you up.

June 19, 2007, 03:57 PM

mgrackin

Norb,

Things are good. I have been busy so I have not had a chance to post much.

June 19, 2007, 04:55 PM

Norb Eckert

Thank you Susannah. This is good too. The neat thing is that several ways to skin this cat have been posted, of which I hadn't thought of any, and now I have a little bag of tricks available. Very Cool.

Wow - So many neat things to try. I feel like Tiny Tim at the end of Dicken's Christmas Carol.

Susannah, it was a pleasure to meet you at Summit as well.

See ya,

Norb

June 22, 2007, 11:19 AM

Trav

You might also consider using multi-drill downs. For exporting we often do this in the header too. I usually have one link called "Export" and it's a multi-drill with the various output types... Saves some space...

Production: 7.6.6 WF Server <=> 7.6.6 WF Client <=> 7.6.6 Dev Studio
Testing: <none>
Using MRE & BID. Connected to MS SQL Server 2005
Output Types: HTML, Excel, PDF

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