I am using WebFOCUS to output faculty contracts. The report should create one contract for each faculty member, which lists all the courses they will be teaching. I am trying to output the report in PDF which will be printed. The problem is the contract is multiple pages of mostly static text, which contains the terms and conditions, surrounding the courses which are pulled from the DB. I have tried putting this text into the header and footer, but the PDF output is truncated, and after I put the full amount of text in the footer the report starts returning a separate contract for each faculty member for each course taught. If I trim most of the text from the footer it starts listing all the courses for each faculty member correctly. I have not been able to find a resolution for this issue. Does anybody have any ideas on how to accomplish this using WebFOCUS? Any help will be appreciated. Thanks.

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

What is the size of this Text Field?

JW,

It sounds like the length of header/footer is the issue. Are your using a on table subfoot or a on footer? Ie. table footer versus page footer. Have your tried using a subfoot on a by field?

Fernando

The length of the text in the header is around 1700 characters, and the footer is around 7200 characters. I am using a page header and footer. I also tried using a subfoot with a by field, but it seemed to have the same text length limitations. If I trim the footer down to around 1200 or so characters everything works fine. Thanks for the responses.

Not sure on limitations, but I 'assume' you are doing a page break on each faculty member, and the report detail is only the listing of courses being 'taught'.

If above is so, header would contain specifics such as name and so on and footer the fixed information with a ON facultyperson do the page-break and footers.

No fun trying to get to work with the potential of many courses.

That is exactly how I am trying to get the report to work. I cannot find a solution, or an alternative strategy, to get the report to run correctly.

A thought, if you counted the courses and then create 'lines of text' for each course, then used conditional subfooting with some 'noprint detail item' so your report was all heading and footing.

Are you pulling your information from a particular student system or a 'home grown' application?

Leah, thanks for looking at this. We are pulling the information from a MS SQL 2005 DB that is driven by Datatel.

Let me make sure I understand your suggestion. In the subfoot create a line of text for all the courses returned. In the text have a field value that would allow us to do some conditional testing and display it based on the results.

Is the above process correct?

quote:

Let me make sure I understand your suggestion. In the subfoot create a line of text for all the courses returned. In the text have a field value that would allow us to do some conditional testing and display it based on the results.

I would count the courses, have a text line for each course, then use the count as the when to determine each subfoot. I've had to do some creative for student profiles to create text lines. If you have number fields needed, then FTOA is a great help.

Hope this makes more sense.

This is how we have created a very similar type of report. We actually use coordinated compound PDF reports. The first report contains everything in the heading, second the detail (i.e. courses taught), and third everything in the footing. Each report contains the same criteria and same sort fields. In your case, the employee name/id or whatever the key is for the faculty member would be the primary sort. The first two reports would use the NOBREAK option. When the report is run the three reports are "concatenated" together for each person and they appear in the correct order, and look like a single report.

Hope this makes sense - it is a little complicated, but i think it will get you exactly what you need. Let me know if you have additional questions.

Thanks for the responses. I am in the process of rewriting the report trying both methods. I will update when I have more information.

I opened a tech support case #40072548 to have IBI look into the issue. After some communication we did a streaming session and they were able to resolve my issue. We were advised that the header/subhead and footer/subfoot do not have a set character limit, that it is dependent on the memory available. In order to get our report to format correctly we used one fex, with all the text information in the subhead and subfoot. We had tried this previously and it caused the problems mentioned above. We then set PRINTPLUS=ON, which fixed all the issues we were having and the report was output correctly. Here is some of the information that we received about PRINTPLUS from Tech Support. Thanks for all the responses.



PRINTPLUS includes enhancements to display alternatives offered by WebFOCUS.
For example, you can place a FOOTING after a SUBFOOT in your report. PRINTPLUS
provides the flexibility to produce the exact report you desire.

The PRINTPLUS parameter must be set to ON to use the following TABLE
capabilities:

PAGE-BREAK is handled internally to provide the correct spacing of pages. For
example, if a new report page is started and an instruction to skip a line at
the top of the new page is encountered, WebFOCUS knows to suppress the blank
line and start at the top of the page.

NOSPLIT is handled internally. (Use NOSPLIT to force a break at a specific
spot.)

You can perform RECAPs in cases where pre-specified conditions are met.

A Report SUBFOOT now prints above the footing instead of below it.

Data displays correctly in subfoots when IF/WHERE TOTAL or BY HIGHEST is used.

BY field actions are linked with BY field options so they appear on the same
page. The footing no longer splits on two pages.

Footings and Subfoots always appear on a page with at least one data item, and
will never split between two pages.

Printing beyond the length of the page no longer occurs.

Splitting of fields linked by OVER onto separate pages no longer occurs.

There is no reserved space for conditional output. The output page is fully
used.

The order of sort fields is no longer relevant.

hi , I am trying to add a terms and conditions to my report as well. I need some assistance , can anyone give me an example with the CAR file on how to do this.

thnx

I don't know how this is related to the thread on which you've posted, but use ON TABLE SUBFOOT.

I don't know if this will be of any help to you:

SET PAGE = NOLEAD
SET PRINTPLUS = ON

DEFINE FILE CAR
DUMMY_TEXT/A1800 =
'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore' |
'et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ' |
'ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu ' |
'fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt ' |
'mollit anim id est laborum. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor ' |
'incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris ' |
'nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum ' |
'dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia ' |
'deserunt mollit anim id est laborum. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod ' |
'tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco ' |
'laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse ' |
'cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia ' |
'deserunt mollit anim id est laborum. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod ' |
'tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco ' |
'laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse ' |
'cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia ' |
'deserunt mollit anim id est laborum.';
END
TABLE FILE CAR
SUM
SALES/D6            AS ''
BY COUNTRY          AS ''
BY CAR              AS ''
BY MODEL            AS ''

ON COUNTRY PAGE-BREAK SUBHEAD
"Country <+0>Car <+0>Model <+0>Sales"
ON COUNTRY SUBFOOT
" "
"1 <DUMMY_TEXT"
"2 <DUMMY_TEXT"
"3 <DUMMY_TEXT"
"4 <DUMMY_TEXT"
"5 <DUMMY_TEXT"
"6 <DUMMY_TEXT"
"7 <DUMMY_TEXT"
" "
ON TABLE PCHOLD FORMAT PDF

ON TABLE SET STYLE *
UNITS=IN, PAGESIZE='LETTER', ORIENTATION=PORTRAIT, SQUEEZE=ON,
LEFTMARGIN=0.5, RIGHTMARGIN=0.5, TOPMARGIN=0.5, BOTTOMMARGIN=0.5, $

TYPE=REPORT, GRID=OFF, FONT=ARIAL, SIZE=9, TOPGAP=0.01, BOTTOMGAP=0.02, $

TYPE=SUBHEAD, STYLE=UNDERLINE+BOLD, BOTTOMGAP=0.1, $
TYPE=SUBHEAD, ITEM=1, POSITION=COUNTRY, $
TYPE=SUBHEAD, ITEM=2, POSITION=CAR,     $
TYPE=SUBHEAD, ITEM=3, POSITION=MODEL,   $
TYPE=SUBHEAD, ITEM=4, POSITION=SALES,   JUSTIFY=RIGHT, $

TYPE=SUBFOOT, ITEM=2, WRAP=7.25, $
ENDSTYLE
END

Thank you for this Francis.

Kind Regards