[Libreoffice-bugs] [Bug 139315] New: report wizard displays dat field as number in some cases

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=139315

            Bug ID: 139315
           Summary: report wizard displays dat field as number in some
                    cases
           Product: LibreOffice
           Version: 6.4.7.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: herman.viaene at edpnet.be

Using embedded Firebird 3.0
Define a table EMP with columns
empid autovalue
name varchar
address varchar
startdate date
Now I want startdate to have as default value current_date. The way I prefer to
do this, is to run the SQL command "alter table emp alter column startdate set
default current_date. This works OK.
Now create a query where the condition for startdate is "> current_date - 365".
To make it work, define the query as "run sql directly".
Now create a report on this query using the wizard, just a straight list of all
the fields from the query. The startdate on running the report comes out as a
number. Changing the report properties to refer to the query i.s.o. the sql
statement the report wizard inserted, does not make a difference.
Create from the query a view, and run again the report wizard, this time on the
view, and the startdate comes out as a date, which is the logical thing to be
expected.
Thee report wizard should have done this properly based on the query.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201230/103f85d0/attachment.htm>