| get specific values in reports [message #88059] |
Fri, 01 February 2002 06:24  |
kmsav
Messages: 3
Registered: January 2002
|
Junior Member |
|
|
I need help with report design. I have a report that uses a repeating frame to enter values from TABLEx. The problem that I run into is that the users want 5 lines all of the time. So, if TABLEx has 3 values, 2 blank lines should follow after it. If there are 5 values in TABLEx, it should just have the 5 values filled into the lines.
so it would look like this:
DAVIS
JONES
ANDERSON
________
________
or
DAVIS
JONES
ANDERSON
PAULSON
GEORGE
Any ideas?
|
|
|
|
| Re: get specific values in reports [message #88060 is a reply to message #88059] |
Fri, 01 February 2002 12:37  |
sokeh
Messages: 77
Registered: August 2000
|
Member |
|
|
are you trying to find out how to add blank lines (_____) or how to return only 5 rows?
If it is about replacing blanks with lines, you can do it two ways.
1, by using nvl(column_name,'______'); or
2, by going to the property pallette and under 'Valued if null', enter blank line ______
and it should do it.
If it is about restricting it to only 5 rows, then write a sql and use the rownum pseudo code to restrict rows returned to 5.
I am sure someone might know another, perhaps better way. These have worked for me in the past.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
