How do I create spreadsheet layouts in Base report builder?

[LibreLyrae]

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?

[w_whalley]

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

[LibreLyrae]

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 4.0.0.3 which works fine, in that it processes all of my reports at least. It still has some issues though :o)

[LibreLyrae]

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!