 |
|||||
|
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
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. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| column headings | Login/Join |
| Member |
I have a question on how to suppress column headings on the first page of a report. Using suggestions already in Focal Point has allowed me to format subheading but the column titles still appear above over everything on the first page. DEFINE FILE ABC BYHEAD1/I1 = 1; COLTITLE/I1 = 2; END TABLE FILE ABC PRINT &ACCOUNT DEPT AMOUNT BY BYHEAD1 NOPRINT BY COLTITLE NOPRINT ON BYHEAD1 SUBHEAD " &STORE <+0> <+0> &PERSON1" ON COLTITLE SUBHEAD "ACCOUNT<+0>DEPT<+0>AMOUNT" . . . ON TABLE SET STYLE * . . . TYPE=SUBHEAD,BY=BYHEAD1,HEADALIGN=BODY,SIZE=10,OBJECT=TEXT,ITEM=3,JUSTIFY=RIGHT,$ TYPE=SUBHEAD,BY=COLTITLE,HEADALIGN=BODY,JUSTIFY=LEFT,$ TYPE=SUBHEAD,BY=COLTITLE,HEADALIGN=BODY,ITEM=3,JUSTIFY=RIGHT,$ Thanks for any help. | ||
|
| Virtuoso |
If you do not want a column heading use as ' ' DEPT AS ' ' AMOUNT AS ' '
| |||||
|
| Virtuoso |
Maybe you can do this by use of the WHEN statement.
| |||||||
|
| Virtuoso |
look in the former FP "heading NOT on first page" of 18 apr 2006. They suggest the use of WHEN in combination of the coloring heading WHITE.
| |||||||
|
| Member |
Thanks but WHEN doesn't seem to work with column headings. When I put ' ' by the print fields that does suppress the column headings but I want them on all other pages, just not on the first one. I can suppress a page heading using . . . COMPUTE HEADER/A30 = IF TABPAGENO EQ 1 THEN ' ' ELSE 'PAGE HEADING . . . but I need the column headings suppressed on page1. | |||
|
| Virtuoso |
You could use a WHEN for a subhead using a counter and another variable - say FPAGE. If the counter GT 50 (however many rows will fit on page 1) then FPAGE=1, else 0. Sort by FPAGE and print subhead when FPAGE GT 0. This may or may not work depending on other content of your report, but if it's just a list-type columnar report, this should work. Column titles have no relationship to Page numbers, so there isn't a way to turn off column titles on only one page. But items that relate to page heading, subheadings, etc. would work. 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 | |||
|
| Platinum Member |
I'm not sure what your intent is for the first page of your report. I assume it's something like a title page. Or maybe you're listing paramter values used to select data for the report. You might try producing that first page in a completely separate report (separate TABLE FILE), using '' as your column title(s). Produce the rest of the report with another TABLE FILE, and then compound them. If you don't know how to produce a compound report, search focal point on that subject. You'll get plenty of help. dwf | |||
|
| Member |
thanks to everyone for their suggestions. I couldn't get the counter for page headings to work but using dwf's suggestion for compound reports I was able to create a table containing only header information, ran that report and then the next report containing the actual data. | |||
|
| Guru |
Are you wanting a onetime HEADING to appear on the report instead of a Page HEADING? Use: ON TABLE PAGE-BREAK AND SUBHEAD ttfn, kp Access to most releases from R52x, on multiple platforms. | |||
|
| Virtuoso |
How about the use of a report heading. Put the info you need into that heading (a free format report) and after the report heading a page-break. I never used this in WF but did something similar in an Access Report.
| |||||||
|
| Virtuoso |
We use Frank's suggestion frequently - kind of gives you a "Cover Page" with relevant information, before you get into the actual content of the report. Syntax is ON TABLE PAGE-BREAK AND SUBHEAD "heading" As with all headings, the lines can contain variables and fields, spot markers, etc. which can be positioned and styled with the stylesheets. Just saves having to run two reports-- 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 | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |