asked on 1/26/2009

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 Database Enterprise Software Java App Servers

Last Comment

Pra4444

1/27/2009

MarkusId

1/26/2009

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.

Pra4444

1/26/2009

ASKER

Mark,

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

Thanks

MarkusId

1/26/2009

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.

Pra4444

1/26/2009

ASKER

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.

Pra4444

1/26/2009

ASKER

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

1/26/2009

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?

Pra4444

1/26/2009

ASKER

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

1/27/2009

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Pra4444

1/27/2009

ASKER

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.

Pra4444

1/27/2009

ASKER

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.