Ask Your Question

How do I create spreadsheet layouts in Base report builder? [closed]

asked 2013-09-12 18:26:38 +0100

Libre Lyrae gravatar image

updated 2020-07-30 00:23:38 +0100

Alex Kemp gravatar image

I went to create Report using design view and changed the Report Output format to ODF spreadsheet but I cannot get the spreadsheet to fill with values, all it does is list employee names for me but will not list any of the values tied to those names even though I put those fields under "Details" along with the employee name fields.

The query this is based on looks for a date parameter input - this seems to be what is also preventing me from creating the query as a view which I could then drag and drop into a spreadsheet (please correct me if I am wrong - when I do this and I look at my view table the field names are there but the data is blank). I would rather have the report do the spreadsheet but I am willing to try any angle...

Am I missing something? Or is this another one of those things that just doesn't work in Report Builder even though it looks like it is an available option?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-07-30 00:23:49.685263


I had a similar result (mostly blank cells in the spreadsheet--only dates filled in) until I updated to LO version Then most cells were filled in. Except cells containing zero "0" came out blank instead.

w_whalley gravatar imagew_whalley ( 2013-09-13 22:06:27 +0100 )edit

Thanks, that's good to know. Unfortunately I have not yet been able to use 4.1x because I keep getting errors where they will not process certain reports... the only fix I have found for this is to use which works fine, in that it processes all of my reports at least. It still has some issues though :o)

Libre Lyrae gravatar imageLibre Lyrae ( 2013-09-13 22:13:53 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-09-13 17:30:21 +0100

Libre Lyrae gravatar image

An update and answer - sort of.

So while I had no success getting it to work from design for some reason, what I ended up doing was using an already made report, in edit mode go to File and change the Report Output Format from writer to spreadsheet. It worked just fine when I did that, after a bit of adjusting. If you have never worked in spreadsheet format for reports one good thing to know right from the start is that empty space of any kind is read as another cell on the spreadsheet so you will want to make sure all of your labels and fields are all aligned tight to each other. Once I fixed the spacing my spreadsheet report layout worked great!

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-09-12 18:26:38 +0100

Seen: 1,341 times

Last updated: Sep 13 '13