Issue 117023 - RPT: Report wizard not recognizes text and boolean field in all cases
Summary: RPT: Report wizard not recognizes text and boolean field in all cases
Alias: None
Product: Base
Classification: Application
Component: ReportBuilder (show other issues)
Version: DEV300m100
Hardware: All Windows 7
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2011-02-19 14:04 UTC by r4zoli
Modified: 2013-01-29 21:47 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

bugdoc with report (136.32 KB, application/vnd.sun.xml.base)
2011-02-19 14:11 UTC, r4zoli
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description r4zoli 2011-02-19 14:04:43 UTC
Report wizard recognizes text and boolean fields as number fields, when report
based on query in which the "Run SQL command directly" option activated.

You can change formatting in design view to correct value.

If you run on query without native SQL , table, or view, the report created
Comment 1 r4zoli 2011-02-19 14:11:13 UTC
Created attachment 75878 [details]
bugdoc with report
Comment 2 r4zoli 2011-02-19 14:14:16 UTC
All field (excluding picture) recognized as number general, but some showed
correctly (text), some wrongly (date, date/time, boolean).
See attached example file, report Query1_SQL34.