Relatorio dynamic columns & dict fields in reports

[Jonathan Levy]

Is there a way to make a spreadsheet report with a variable number of columns (like the rows can be variable)?

My customers use Tryton to keep records for usage of airplanes, and they have preferences as to what aspects of usage they want to keep track of.  E.g., some want to track fuel burned; some don't.  I've implemented these discretionary details through a dict field, and would like to present the information in a suitable manner on a report.  The goal would be for the report to check if the customer's configuration has him/her tracking the optional field (e.g., fuel burn) and, if so, have the report include that column, retrieving the relevant data from the dict field.  Is this possible?

I would also appreciate any other tips on how to deal with dict fields in reports.  (I'm using Tryton 3.0.)

Thank you, in advance, for any advice you can provide.

[Cédric Krier]

On 2016-01-19 11:39, Jonathan Levy wrote:
> Is there a way to make a spreadsheet report with a variable number of
> columns (like the rows can be variable)?

There is in relatorio examples/columns.odt
It is on odt but normally it should work on ods.

> My customers use Tryton to keep records for usage of airplanes, and they
> have preferences as to what aspects of usage they want to keep track of.
> E.g., some want to track fuel burned; some don't. I've implemented these
> discretionary details through a dict field, and would like to present the
> information in a suitable manner on a report. The goal would be for the
> report to check if the customer's configuration has him/her tracking the
> optional field (e.g., fuel burn) and, if so, have the report include that
> column, retrieving the relevant data from the dict field. Is this possible?
>
> I would also appreciate any other tips on how to deal with dict fields in
> reports. (I'm using Tryton 3.0.)
>
> Thank you, in advance, for any advice you can provide.

Did you considered to use predefined CSV exports?

--
Cédric Krier - B2CK SPRL
Email/Jabber: cedric...@b2ck.com
Tel: +32 472 54 46 59
Website: http://www.b2ck.com/

[Jonathan Levy]

On Tuesday, January 19, 2016 at 5:50:06 PM UTC-5, Cédric Krier wrote:

There is in relatorio examples/columns.odt
It is on odt but normally it should work on ods.

Thank you, it does work with ods, although people should be aware that it runs into problems dealing with merged cells.