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
Status: CONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
bugdoc with report (136.32 KB, application/vnd.sun.xml.base)
2011-02-19 14:11 UTC, r4zoli 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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
correctly.
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.