| Make report. [message #529582] |
Wed, 02 November 2011 01:14  |
|
|
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 1031 times)
|
|
|
|
|
|
| Re: Make report. [message #529619 is a reply to message #529588] |
Wed, 02 November 2011 03:32  |
|
|
Littlefoot wrote on Wed, 02 November 2011 02:03I'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 #529630 is a reply to message #529624] |
Wed, 02 November 2011 04:21 |
|
|
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 1020 times)
[Updated on: Wed, 02 November 2011 04:23] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: Make report. [message #529850 is a reply to message #529644] |
Thu, 03 November 2011 06:32 |
|
|
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 1058 times)
[Updated on: Thu, 03 November 2011 06:36] Report message to a moderator |
|
|
|
|
|
| Re: Make report. [message #530000 is a reply to message #529852] |
Thu, 03 November 2011 22:59 |
|
|
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 1055 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 |
 |
Littlefoot
Messages: 21823
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?).
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
