Avatar of Pra4444
Pra4444Flag for United States of America asked on

oracle reports 6i

Hi,

I have a simple report with our own built in template(created by somebody else). All i want to do is add a line after each row of data. I cant find a way to do that.

Can someone tell me how to do that??

Thanks.
Oracle DatabaseEnterprise SoftwareJava App Servers

Avatar of undefined
Last Comment
Pra4444

8/22/2022 - Mon
MarkusId

Hi,

I suppose you have a repeating frame around that line. All you have to do is to make the frame larger so you can put the fields you want to have after each line into that frame.
ASKER
Pra4444

Mark,

Could you explain a bit more clearly??
whats a repeating frame and how do i add the line??

Thanks
MarkusId

Hi,

Well, you have queries in the report. If you change to the layout view, the fields of each query are surrounded by a frame. If you change to the property sheet you can see to which query the frame belongs.

So, you figure out which query delievers the fields of the line you want to add another line. If you know the query, you also know the frame. Then you expand the frame (you might also be forced to expand the surrounding frames and change the layout of the following fields) and put your new fields into the same frame.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER
Pra4444

Right now, there are no horizontal lines in the report. All i want is a line after each row of my report, so that it is presentable and easily distinguishable between different rows.
ASKER
Pra4444

After reading your answer again, i have a feeling you didnt get what i want to do.
This is how my report looks now..Lets name the columns A, B, C, and D

A  B  C  D

1  2   3  5
4  5   6  7
1  1   1  1

All I want is a line after each row like this...

A  B  C  D

1  2   3  5
-------------
4  5   6  7
-------------
1  1   1  1
------------

So that I Can distinguish b/w rows.

Thanks for your help so far.
MarkusId

Hi,

If it's Oracle Reports 6i that's right what I explained. Just draw a line inside the frame of your output.

Maybe you could post your report-file, then I could have a look at it?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
Pra4444

cool..I got the line in..now..However, the line is not positioned exactly after each row.. bcos one of my columns is long, and that column is almost 3 lines, whereas the other columns are just one line. So the line strikes over that column.I tried increasing the length of the frame of my columns, but its not allowing me to do that.

Any thoughts??

ASKER CERTIFIED SOLUTION
MarkusId

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Pra4444

Mark,

I tried doing what you mentioned..I put a non-repeatable frame around the columns and inside the repeating frame..Still, i see texts from the columns go beyond the non-repeatable frame!!!

I cant seem to figure this thing out.

Thanks for your support so far.
ASKER
Pra4444

I think i figured it out. Had to set vertical elasticity to variable instead of fixed on the non-repeating frame!!

Thanks a lot Mark. You have been of great help.
Your help has saved me hundreds of hours of internet surfing.
fblack61