| Report question - help [message #366860] |
Wed, 29 November 2000 03:52  |
Martin Johansson
Messages: 11
Registered: October 2000
|
Junior Member |
|
|
I have a repeating frame that prints rows from the database. How can I get the frame to always print a certain number of rows, even if there are not so many rows in the database?? If there are not so many rows in the db I want to print blank rows.
/Martin
|
|
|
|
| Re: Report question - help [message #366868 is a reply to message #366860] |
Tue, 05 December 2000 15:17  |
Madhav Kasojjala
Messages: 42
Registered: November 2000
|
Member |
|
|
Hi Martin,
Look at this.
Suppose you have
a
query like this:
select "x" a, "y" b
from table_x TX
WHERE some_conditions;
and you need at least 10 rows always to be shown
on Report output no matter what above query output is then
modify the query like this:
select "x" a, "y" b
from table_x TX
WHERE some_conditions
UNION ALL
select " " a, " " b
from table_x TX
WHERE rownum < 11-(select count(*)
from table_x TX
WHERE some_conditions
);
This will produce in worst
case like some_conditions is 1=2
then 10 blank rows!!!
Hope this helps.
Mail me if you have any doubts
G.Luck
Madhav
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
