I posted this request for help to comp.databases.oracle last week, but
didn't receive any responses. I'm hoping the tools group might yield
a suggestion or two. I know SQL*Plus isn't a very glamorous tool
these days, but I'd really appreciate any help you can provide.

I have an irritating little puzzle that I'd love suggestions for
solving. I am using Oracle 8.0.4, and have a SQL*Plus report that
gathers labor costs by project number for a given accounting period.
The project number appears in the TTITLE of the report, like this:

TTITLE LEFT 'PROJECT NUMBER: ' projno SKIP 1 - ...

And of course I have a COLUMN definition like this:

COLUMN project_no NEW_VALUE projno FORMAT A1 NOPRINT

This report BREAK's on the project number, and on the report, with a
page break between each project. And we COMPUTE the SUM of the labor
costs by both project number, and for the report.

The puzzle is this: The last page of the report doesn't contain any
detailed data, only the total labor costs for the report's accounting
period. But the TTITLE for this page still displays the project
number from the previous page.

Will I have to split the report total out into a separate query, with
separately defined TTITLE, or is there a way to control the project
number display (preferably leave it blank) for the last page of the
report?

Thanks for your help!!!

Lisa Tracy wrote:

Yes. You can't change the title mid-report.

And while SQL*Plus may not be glamorous ... it beats heck out of many
products on the market ... well except for writing reports. ;-)

I would suggest however that you dump 8.0.4. It is unsupported, will soon
will be ~12 versions behind the current release and will not enhance your
resume (except perhaps in the Netherlands).

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)