[Solved] Consecutive entries from adjacent columns

[jaleks]

[SOLVED] OS is Ubuntu 7.10, OOo is 2.3.1,Deb, JRE is 1.6.0_03, Report Builder is 1.0.1
Should I address this to another place?
How do I print on consecutive lines if: Column A is building, Column B is room and Column B changes room number. Adjusting height of Detail section of Report Builder, by dragging and dropping its bottom line or
adjusting height by numbers in right column, does not allow second entry of Column B to be on next line down when Column B is indented with respect to Column A. Moving label blocks to top of Detail
section, then indenting data blocks and setting them touching each other, does not correct the problem. The second entry from Column A occurs close enough to last room entry. It is only the entries of rooms in same
building that are spaced too far vertically to use. The desired result is :
Building 1 what actually happens is: Building 1
Room A Room A
Room B
Building 2 Room B
Room A Building 2
Room B Room A

Room B

[jaleks]

[Solved] Just not quiet the way I would like it but it is usable. Will keep working on it though.

[DrewJensen]

Hi,

You know I had a hard time understanding just what you where trying to get at - I'm glad you got it solved, but if you are still not sure it is what you want, maybe put up how you solved it and it might help to understand what you really are trying for and maybe have another way to go at it.

[jaleks]

Drew, thanks for the response. I've taken some screen shots and will try to get them to you
as an attachment. The first, "Screenshot 1" shows the position of the boxes labeled Building and Room
side by side. This is the way I can use the report but not the preferred way. The "Screenshot 2" shows
the positions of the two boxes as I would like the report to show. The "Screenshot 3" shows the result
of using Screenshot 2. Notice the wide separation between A1 and A2 and also between B1 and B2.
I would prefer to have A1 and A2 be on "consecutive" lines, not skipping lines. So far, everything I've tried
has resulted in the effect of Screenshot 3. There are many more rows and columns involved but the solution
to these four items will solve the remainder. I know it has something to do with the "label" of the Building
entry. Neither inclusion as print (yes/no) nor adjusting height in the control panel, or by dragging and dropping
the bottom line of the detail section will give me the result for which I hope. Using Screenshot 1 position, I can get it to print with room entries on consecutive lines. However, if I save it as a template, the next time
I open it, it opens as in screenshot 3. For now I can handle it the way it is but if there is a solution and I am
missing it, I sure would like to know.
Thank you for your interest in this problem and its solution.

[jaleks]

[Solved] Over come by events.

[DrewJensen]

Ok I am totally confused I guess - and after spending the better part of today in the Report Builder, who wouldn't be. ( not this problem - Invoices...arrrgh )

Don't laugh but - any chance you have a scanner and if so, can you dtaw a picture of what you want and scan it in...

You have Buildings and Rooms - but three text boxes and the example shows three values...

Do you want

Code: Select all

Building_1
    Room_A          Number
    Room_b          Number
Building_2
    Room_A          Number
    Room_B          Number

Or an I just getting this wrong - because if so then you can use a group header for that - But I think I am just missing the point of what you want.

[jaleks]

Thanks Drew for the response. I solved my problem by first putting the empty data boxes for the columns in the
detail portion of the report, then putting their labels in the report header portion. Then I put new empty data boxes
for the columns in the report header, adjusted them to smallest possible and still find them, placed them at the
0.00 point on the Y axis, and their labels in the position I wanted them to appear (offset) to the empty data boxes
I had placed in the detail portion. I reduced their labels in the detail portion to the smallest possible and
place them at the 0.00 on their Y axis. I had to eliminate page header/footer and report footer. Then it was
just a matter of adjusting the height of the various boxes, labels, and the detail and report header sections
until it prints as I want it. Since, I have also set up a 7 column section in a similar method so I can transcribe
about 375 pages of 50 records each and then let the owner put his over 100 year old book in proper storage.
(His book is about 24 inches by 12 inches and about 4 inches thick and very fragile). Now, if I can learn to
write a macro .... Thanks for the interest and the help.