HTML Table in heading

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

Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007

Ignored post by Darin Lee posted

Platinum Member

posted

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

prod:7.6.9, win2k3 mre, caster, bid, devstudio 7.6.9

Posts: 242 | Location: Minneapolis | Registered: February 16, 2006

Ignored post by Norb Eckert posted

Darin Lee

Virtuoso

posted

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

Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007

Ignored post by Darin Lee posted

Platinum Member

posted

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

prod:7.6.9, win2k3 mre, caster, bid, devstudio 7.6.9

Posts: 242 | Location: Minneapolis | Registered: February 16, 2006

Ignored post by Norb Eckert posted

Tony A

Expert

posted

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

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, 2004

Ignored post by Tony A posted

Platinum Member

posted

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

prod:7.6.9, win2k3 mre, caster, bid, devstudio 7.6.9

Posts: 242 | Location: Minneapolis | Registered: February 16, 2006

Ignored post by Norb Eckert posted

mgrackin

Virtuoso

posted

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

Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011

Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003

Ignored post by mgrackin posted

Darin Lee

Virtuoso

posted

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

Regards,

Darin

Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007

Ignored post by Darin Lee posted

Platinum Member

posted

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

prod:7.6.9, win2k3 mre, caster, bid, devstudio 7.6.9

Posts: 242 | Location: Minneapolis | Registered: February 16, 2006

Ignored post by Norb Eckert posted

susannah

Expert

posted

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.

In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID

Posts: 3811 | Location: Manhattan | Registered: October 28, 2003

Ignored post by susannah posted

mgrackin

Virtuoso

posted

Norb,

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

Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011

Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003

Ignored post by mgrackin posted

Platinum Member

posted

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

prod:7.6.9, win2k3 mre, caster, bid, devstudio 7.6.9

Posts: 242 | Location: Minneapolis | Registered: February 16, 2006

Ignored post by Norb Eckert posted

Trav

Platinum Member

posted

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

Posts: 230 | Location: Wichita, KS | Registered: May 27, 2005

Ignored post by Trav posted