| Suppress Information on a new page [message #97710] |
Mon, 25 November 2002 13:45  |
Jen
Messages: 23
Registered: June 2001
|
Junior Member |
|
|
|
I have a sql plus script which specifies nodup on some column names. Let's say I'm using a department number for one of the columns. I have 40 records worth of information for department 001 and my pagesize is set to 35. Whenever the new page starts, the first record on the new page (the 36th record of dept. 001) does not suppress the department number even though it is a duplicate. How can I make this 36th record of the same dept. number not print the department number when the information is continued on another page? I know I could simply change the pagesize to 40, but the amount of records will change all the time. There might be 100 records for a specific department.
|
|
|
|
|
|
| Re: Suppress Information on a new page [message #97718 is a reply to message #97713] |
Wed, 27 November 2002 08:28  |
Jen
Messages: 23
Registered: June 2001
|
Junior Member |
|
|
|
That seems to work, the only thing is I lose the TTITLE values as well as the column headings when I set the pagesize to 0. I thought if I did a SET TTITLE ON and SET HEADING ON that these values would still display on the report even though the pagesize is set to zero, but they don't.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
