Control the space between the Records [message #262766] |
Tue, 28 August 2007 04:33 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
muthaharora
Messages: 11 Registered: August 2007
|
Junior Member |
|
|
Dear All,
In my report output there are many records which has about 15 fields.My issue is, The space between the records is not in a sequential manner.
Example: If 5 records are there and let <space> indicate the space between each records row wise then my output is like this:
RECORD 1
RECORD 2
<space>
<space>
<space>
RECORD 3
<space>
RECORD 4
<space>
<space>
RECORD 5
Could any one please tell how to control this.
Thanks and Regards
Muthahar
|
|
|
|
Re: Control the space between the Records [message #262843 is a reply to message #262825] |
Tue, 28 August 2007 06:28 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
muthaharora
Messages: 11 Registered: August 2007
|
Junior Member |
|
|
My issue was that i am getting single space between some records, no space and more than 3 space between the records displayed in a page.
Thank you for your reply, but when i changed that property only two records are displayed per page.
What i needed is to have only a single space between each of the records, and also to display only 15 records per page. Could you please guide me more.
Thanks
Muthahar
|
|
|
Re: Control the space between the Records [message #262882 is a reply to message #262843] |
Tue, 28 August 2007 07:33 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Can you execute the same query in SQL*Plus (or SQL Developer or TOAD or ...)? How does output look like there? Are those <spaces> still present?
Can you identify what is a <space>? Is it, perhaps, a record with NULL values in all columns you display? This is what I have in mind:
SQL> CREATE TABLE test (id NUMBER, name VARCHAR2(20));
Table created.
SQL> INSERT ALL
2 INTO test VALUES (1, 'little')
3 INTO test VALUES (2, NULL)
4 INTO test VALUES (3, 'foot')
5 INTO test VALUES (4, NULL)
6 INTO test VALUES (5, NULL)
7 INTO test VALUES (6, 'test')
8 SELECT * FROM dual;
6 rows created.
SQL> SET NULL '<space>'
SQL> SELECT name FROM test;
NAME
--------------------
little
<space>
foot
<space>
<space>
test
6 rows selected.
SQL> If that's the case, kick out those records completely! Include another condition into the WHERE clause to eliminate those records; or, possibly, write a FORMAT TRIGGER which would check existence of every field and return FALSE if all of them are NULL (doing so, record will not be displayed).
|
|
|
Re: Control the space between the Records [message #262887 is a reply to message #262882] |
Tue, 28 August 2007 07:47 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
muthaharora
Messages: 11 Registered: August 2007
|
Junior Member |
|
|
I am very very sorry for not making my question clear, my question is only respect to the output of reports.The report is generated and in the output i am getting the records, i want that there be a single line spacing between the records displayed in the output after running a report.
I got inoformation that i have to change the property of repeating frames, but i am not clear.
please let me know regarding this.
Thanks
Muthahar
|
|
|
|
|
Re: Control the space between the Records [message #262943 is a reply to message #262918] |
Tue, 28 August 2007 10:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
I've already told you what I think about it. Obviously, it was wrong. To give you another opinion, please, provide CREATE TABLE and INSERT INTO sample data statements, and attach RDF of your report so that someone might look at it.
|
|
|