Home » Developer & Programmer » Reports & Discoverer » Grid format in tabular report.
Grid format in tabular report. [message #134713] Fri, 26 August 2005 06:42 Go to next message
priyravi
Messages: 41
Registered: July 2005
Member
Hi all,
I have created tabular report like

A B C D E
a1 b1 c1 d1 e1
d2 e2
_______________________
a2 b2 c2 d1 e1
d2 e2
e3
----------------------
c3 d1 e1 and so on.
the problem is lines are not getting displayed while viewing in web. of couse, it is not shown in paper layout also. but when i view the same in web layout through reports builder lines are displayed properly. I cannot draw lines in layout editor also,sine records may grow. i left some space in layout editor and drew line to view the exact report with lines. but, if records grow further ...it will not be displayed properly.
Hope to get solution from experts to sort out this issue.
this is quite urgent.
Help me.

Thanks,
Priya
Re: Grid format in tabular report. [message #135153 is a reply to message #134713] Tue, 30 August 2005 03:14 Go to previous messageGo to next message
priyravi
Messages: 41
Registered: July 2005
Member
Still in expectation of answer...
Re: Grid format in tabular report. [message #135167 is a reply to message #135153] Tue, 30 August 2005 04:14 Go to previous messageGo to next message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

hi,
You don't need to draw the lines, you can assign the repeating frame's line color to black(in Layout Model) to get the required result. This way you don't need to bother, how many records you get. Every record you get will be surrounded by the lines.

Regards.
Re: Grid format in tabular report. [message #135180 is a reply to message #135167] Tue, 30 August 2005 05:48 Go to previous messageGo to next message
priyravi
Messages: 41
Registered: July 2005
Member
that z right..but the thing is for each field depending on the number of records, separate border is shown. hope u can understand my point.

suppose, if

1 a1 b1 c1
b2 c2
b3
2 a2 b1 c1
c2

here if I make fields border is black it is displaying like.

1 a1 b1 c1
--- b2 c2
b3
---- -> I want the line here only for whole record...dnt require line under 1.
2 a2 b1 c1
c2


got my point??
Re: Grid format in tabular report. [message #135188 is a reply to message #135180] Tue, 30 August 2005 06:40 Go to previous messageGo to next message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

hi,
I suggested this result.
|-------------|
| 1 a1 b1 c1  |-->row1
|-------------|
| b2 c2       |-->row2
|-------------|
| b3          |-->row3
|-------------|
| 2 a2 b1 c1  |-->row4
|-------------|
| c2          |-->row5
|-------------|

Do you want this type of output?
|-------------|
| 1 a1 b1 c1  |-->row1
| b2 c2       |-->row2
| b3          |-->row3
|-------------|
| 2 a2 b1 c1  |-->row4
| c2          |-->row5
|-------------|

If yes then do you have only a single query in your report?Can you send a snapshot of your layout model?

Regards.
Re: Grid format in tabular report. [message #135317 is a reply to message #135188] Tue, 30 August 2005 23:28 Go to previous messageGo to next message
priyravi
Messages: 41
Registered: July 2005
Member
Ya...I require the flg o/p.

|-------------|
| 1 a1 b1 c1 |-->row1
| b2 c2 -->row2
| b3 |-->row3
|-------------|
| 2 a2 b1 c1 |-->row4
| c2 |-->row5
|-------------|

I have only single query..like select col1,col2,col3 from tablename; In table, records will be like

|-------------|
| 1 a1 b1 c1 |-->row1
| b2 c2 -->row2
| b3 |-->row3
|-------------|
| 2 a2 b1 c1 |-->row4
| c2 |-->row5
|-------------| exactly same as my desired output.

Any clues??
Re: Grid format in tabular report. [message #135388 is a reply to message #135317] Wed, 31 August 2005 07:19 Go to previous message
priyravi
Messages: 41
Registered: July 2005
Member
Hi ,
I have solved the problem.
I drew vertical lines in between the fields and set the property : Line stretch with frame --> repeating group name.

Hence, vertical lines are coming properly.
For horizontal lines, I set the parent frame's border to blue colour[any colour which distinguish records]. Now, my report is working fine.

Thanks for your response.

Regards,
Priya
Previous Topic: Error when calling variable in lexical parameter
Next Topic: interview question
Goto Forum:
  


Current Time: Sun Jun 23 15:06:57 CDT 2024