| Author |
Topic |
|
Fvnh
Starting Member
6 Posts |
 Posted - 2003-10-22 : 04:02:26
|
| This next problem.I have made a short report on a matrix printer.It all works fine except that I need a page skip at the end of the report otherwise another job will start to print on the same page.I have tried to use BREAK ON REPORT SKIP PAGE but this doesn't seem to work.How can I solve this problem? |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-10-22 : 04:18:47
|
| Your report... in what it? Access? |
 |
|
|
Fvnh
Starting Member
6 Posts |
Posted - 2003-10-22 : 04:35:08
|
quote:
Originally posted by Stoad
Your report... in what it? Access?
No sql language |
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-10-22 : 05:16:00
|
| Sorry... seems I never did this thing. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-10-22 : 07:00:06
|
| What are you talking about? There is no such thing as reports in SQL . SQL is for manipulating and returning DATA from tables in databases, not presenting data like for a report. It has no mechanisms to deal with "page breaks" or headers or footers or anything like that.Where does this "BREAK ON REPORT SKIP PAGE" option exist that you are mentioning?- Jeff |
|
|
|
Fvnh
Starting Member
6 Posts |
Posted - 2003-10-22 : 08:38:43
|
SQLPLUS zekers?quote:
Originally posted by jsmith8858
What are you talking about? There is no such thing as reports in SQL . SQL is for manipulating and returning DATA from tables in databases, not presenting data like for a report. It has no mechanisms to deal with "page breaks" or headers or footers or anything like that.Where does this "BREAK ON REPORT SKIP PAGE" option exist that you are mentioning?- Jeff
|
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-10-22 : 08:49:44
|
| this is a sql-server (T-SQL) forum, with some Access as well. Does SQLPLUS exist for SQL-Server? It seems to be an Oracle thing.- Jeff |
|
|
|
Fvnh
Starting Member
6 Posts |
Posted - 2003-10-22 : 08:53:52
|
Oops, wrong forum?Indeed for Oracle environment.Where can I put this question?quote:
Originally posted by jsmith8858
this is a sql-server (T-SQL) forum, with some Access as well. Does SQLPLUS exist for SQL-Server? It seems to be an Oracle thing.- Jeff
|
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-10-22 : 08:57:01
|
| dbforums.com has good Oracle people I think. We just do SQL Server here.Damian |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-10-22 : 12:00:42
|
You have to set the pagesize before you run..how else will it know how big your page is?Look at:http://www.cosc.canterbury.ac.nz/docs/oracle/server.817/server.817/a82950/ch8.htm#1011976quote:
[SKI[P]] PAGE Skips the number of lines that are defined to be a page before printing the row where the break occurred. The number of lines per page can be set via the PAGESIZE clause of the SET command. Note that PAGESIZE only changes the number of lines that SQL*Plus considers to be a page. Therefore, SKIP PAGE may not always cause a physical page break, unless you have also specified NEWPAGE 0. Note also that if there is a break after the last row of data to be printed in a report, SQL*Plus will not skip the page.
I gotta get Oracle re-installed...Brett8-) |
|
|
|
|
Skip page at end of report