Ask Your Question

Creating a 3-across report - same data in each! [closed]

asked 2013-09-29 17:20:58 +0200

Bogie gravatar image

updated 2013-10-01 16:50:26 +0200

manj_k gravatar image

I am trying to create a report that shows 3 records across. I selected the fields from the database three times and positioned them across the page. But when I view the Document, it shows the same data in each:

ex: I want

Fred Flintstone ..... Barney Rubble ...... Dino Saur

2 Pepple Rd. ........ 4 Pepple Rd .......... 18 Croc Way

what I get

Fred Flintstone ..... Fred Flinstone ...... Fred Flinstone

2 Pepple Rd. ........ 2 Pebble Rd. ......... 2 Pepple Rd.

(The periods were added for formatting - they do not display on report)

How do I get the next record to show instead of the first one repeating?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-02-19 10:35:54.381775

2 Answers

Sort by » oldest newest most voted

answered 2013-10-01 16:19:29 +0200

Bogie gravatar image

Forget it - I guess no one else knows how to, either! I created an EXCEL spreadsheet from the Base database and use Mail Merge in WORD to create the report using the spreadsheet. I guess LibreOffice Base is a very poor substitute for ACCESS!!

edit flag offensive delete link more


I actually gave your question some thought. I don't work much with Base, but I used to do a lot with Access, and I couldn't even work out how I would do it there. What is your Access solution? My only thoughts were that (1) it would need to be query based, and (2) it would help to know which of those fields was primary for pulling the related data (I assume "Name", but it would be better not to guess!).

David gravatar imageDavid ( 2013-10-02 08:58:27 +0200 )edit

I would love to know the answer to this question, too. It certainly can be none easily in the legacy REPORT WIZARD (LRW - now deprecated in LO), just one of the reasons I think the RB leaves a lot to be desired! Is there any way of re-enabling the LRW in recent versions of LO?

frofa gravatar imagefrofa ( 2014-01-05 21:48:24 +0200 )edit

answered 2014-02-14 12:01:41 +0200

oweng gravatar image

updated 2014-02-14 12:26:04 +0200

I think the example, as provided, is not typical for any definition of "multi-column" in the original AOO Report Designer specification. According to bug fdo#52944 the "multi-column reports" feature (i.e., phone book style of one column, then the next column) listed on the help page for the Report Builder appears to have never been implemented. As indicated in the bug, this feature comes from the specification (5.20, pp.42-43) for the old Report Designer.

edit flag offensive delete link more

Question Tools



Asked: 2013-09-29 17:20:58 +0200

Seen: 304 times

Last updated: Feb 14 '14