Home » Developer & Programmer » Reports & Discoverer » Make report. (Oracle Report 10g.)
Make report. [message #529582] Wed, 02 November 2011 01:14 Go to next message
dophuong_cs
Messages: 92
Registered: May 2011
Location: Viet Nam
Member

Hi all,
I have a problem about report builder. I would make a report same picture under, but i can't design layout like template when used repeating frame for field product_code and field slip_no, but those field not display same template.
I hope members maybe help me about report this.
How do i do?
  • Attachment: report.JPG
    (Size: 64.51KB, Downloaded 211 times)
Re: Make report. [message #529588 is a reply to message #529582] Wed, 02 November 2011 02:03 Go to previous messageGo to next message
Littlefoot
Messages: 21580
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm not sure I understood what you said. You showed us what kind of an output you'd like to get. Could you post a screenshot of the current output (so that we would see the difference and, hopefully, suggest an approach)?
Re: Make report. [message #529619 is a reply to message #529588] Wed, 02 November 2011 03:32 Go to previous messageGo to next message
dophuong_cs
Messages: 92
Registered: May 2011
Location: Viet Nam
Member

Littlefoot wrote on Wed, 02 November 2011 02:03
I'm not sure I understood what you said. You showed us what kind of an output you'd like to get. Could you post a screenshot of the current output (so that we would see the difference and, hopefully, suggest an approach)?


I tried but unsuccessful same picture, row 21 same picture in my report not display same picture and that row display under row 20.
Now, i want to row 21 display same report template in picture.
How do i do?
Re: Make report. [message #529624 is a reply to message #529619] Wed, 02 November 2011 04:00 Go to previous messageGo to next message
Littlefoot
Messages: 21580
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I see ...

Here's one option:
  • horizontally enlarge the outmost frame so that it would be capable of holding data sets in two "columns"
  • vertically, enlarge it so that it is capable of holding 20 records vertically. Set its "Vertical elasticity" to "Fixed"
  • set repeating frame's "Print Direction" property to "Down/Across"
  • set repeating frame's "Maximum Records per Page" to 40
  • run the report
This is the result; I hope that this is what you are looking for.

/forum/fa/9522/0/

  • Attachment: rep_21.png
    (Size: 20.91KB, Downloaded 427 times)
Re: Make report. [message #529630 is a reply to message #529624] Wed, 02 November 2011 04:21 Go to previous messageGo to next message
dophuong_cs
Messages: 92
Registered: May 2011
Location: Viet Nam
Member

Yes, i looking for same your report already post, but i set some property same You said as:
- set repeating frame's "Print Direction" property to "Down/Across"
- set repeating frame's "Maximum Records per Page" to 40
--
I run but unsuccessful.This is result.


[EDITED by LF: removed unnecessary quote of the whole previous message]
  • Attachment: result.JPG
    (Size: 9.36KB, Downloaded 203 times)

[Updated on: Wed, 02 November 2011 04:23] by Moderator

Report message to a moderator

Re: Make report. [message #529632 is a reply to message #529630] Wed, 02 November 2011 04:23 Go to previous messageGo to next message
Littlefoot
Messages: 21580
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Eh? There's no result at all, only the title.
Re: Make report. [message #529634 is a reply to message #529632] Wed, 02 November 2011 04:26 Go to previous messageGo to next message
dophuong_cs
Messages: 92
Registered: May 2011
Location: Viet Nam
Member

Littlefoot wrote on Wed, 02 November 2011 04:23
Eh? There's no result at all, only the title.

This is result.
  • Attachment: result.JPG
    (Size: 83.84KB, Downloaded 259 times)

[Updated on: Wed, 02 November 2011 04:30]

Report message to a moderator

Re: Make report. [message #529644 is a reply to message #529634] Wed, 02 November 2011 04:50 Go to previous messageGo to next message
Littlefoot
Messages: 21580
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is not the same as your first screenshot.

The rightmost (empty) column is too wide and the report can never fit two parallel triples (STT + SLIP_NO + PALLET_DATE).
Re: Make report. [message #529850 is a reply to message #529644] Thu, 03 November 2011 06:32 Go to previous messageGo to next message
dophuong_cs
Messages: 92
Registered: May 2011
Location: Viet Nam
Member

I already successful with support from you. But i want to display all 40 rows in my report and only 4 rows first have data then fill data to 4 rows that, remain 36 rows last empty. Because do same you support me,if report have 3 rows then report only display 3 rows,so not correct template.Now, i want to display same picture under.
How do i do?
  • Attachment: report.JPG
    (Size: 64.51KB, Downloaded 265 times)

[Updated on: Thu, 03 November 2011 06:36]

Report message to a moderator

Re: Make report. [message #529852 is a reply to message #529850] Thu, 03 November 2011 06:44 Go to previous messageGo to next message
Littlefoot
Messages: 21580
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You attached the same screenshot as in the initial post, so I can't see what you actually mean.

Anyway: if there are only 4 records, obviously you can't display 40 of them as 36 records simply don't exist. So what's the problem?
Re: Make report. [message #530000 is a reply to message #529852] Thu, 03 November 2011 22:59 Go to previous messageGo to next message
dophuong_cs
Messages: 92
Registered: May 2011
Location: Viet Nam
Member

This is result you can see picture under, my report have 3rows had data but i want to display 40rows for all report and only fill data to 3rows firstly and rows remain display empty but still have rows, same picture under.
Now, how do i do?
  • Attachment: 3rows.JPG
    (Size: 60.84KB, Downloaded 251 times)

[Updated on: Thu, 03 November 2011 23:12]

Report message to a moderator

Re: Make report. [message #530014 is a reply to message #530000] Fri, 04 November 2011 01:55 Go to previous messageGo to next message
Littlefoot
Messages: 21580
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I see; basically, you always want to "draw" the whole table, but fill only existing records.

As far as I can tell, it isn't an easy task in Reports. There's no problem in displaying field's (row's) border lines, but - it is done only for displayed records (in your case, 3 of them). Now, thinking aloud. In order to create empty table cells, you'd have to UNION your query with a dummy one that would be used as a row generator and create up to 40 dummy records. These records should be easily distinguished (such as "ID = -999", "NAME = '$XXX$'" or similar non-existing values. Why? So that you could use conditional formatting and paint these values "white" (i.e. background color - if a paper is white, that would be white color). Report would then display these records, but they would be virtually invisible.

I have no idea whether it is actually a feasible solution. Maybe someone else has a far better idea; I can't think of anything else (I suppose pre-printed paper is not an option?).
Re: Make report. [message #530142 is a reply to message #530014] Fri, 04 November 2011 20:32 Go to previous messageGo to next message
dophuong_cs
Messages: 92
Registered: May 2011
Location: Viet Nam
Member

Hi, as you said,thus don't have solution for my report.
I want to You maybe help me about solution for this problem.
Re: Make report. [message #530151 is a reply to message #530142] Sat, 05 November 2011 03:08 Go to previous message
Littlefoot
Messages: 21580
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As I said, I don't have any other idea.
Previous Topic: Symbol in Oracle Reports
Next Topic: convert mmatrix report in to xls
Goto Forum:
  


Current Time: Tue Aug 11 08:48:15 CDT 2020