Uploaded image for project: 'Pentaho Reporting and Pentaho Report Designer'
  1. Pentaho Reporting and Pentaho Report Designer
  2. PRD-430

Report Wizard is not importing date fields into the Report Designer

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Fixed
    • Affects Version/s: Pentaho 1.6 GA
    • Fix Version/s: 1.7.0.GA
    • Component/s: Report Design WIzard
    • Labels:
      None
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Operating System/s:
      Windows XP

      Description

      I started the Report Designer Wizard and used this query from MySql:

      select Date(Now()) as "Date"

      If you preview the report inside the Report Designer Wizard it will show the date field but with the incorrect format (its not suppose to show the time, only MM-DD-YYY).

      After you finish using the report wizard the Report Designer fails to take the new date field. Here is the error message:

      java.lang.RuntimeException: Unsupported datasource encountered while importing textelement: org.jfree.report.filter.DateFormatFilter@82ffe6
      at org.pentaho.reportdesigner.crm.report.reportimporter.JFreeReportImporter.addElement(JFreeReportImporter.java:548)
      at org.pentaho.reportdesigner.crm.report.reportimporter.JFreeReportImporter.addElements(JFreeReportImporter.java:428)
      at org.pentaho.reportdesigner.crm.report.reportimporter.JFreeReportImporter.importStandardBands(JFreeReportImporter.java:174)
      at org.pentaho.reportdesigner.crm.report.reportimporter.JFreeReportImporter.<init>(JFreeReportImporter.java:144)
      at org.pentaho.reportdesigner.crm.report.commands.PentahoWizardCommand.finishFired(PentahoWizardCommand.java:196)
      at org.pentaho.jfreereport.wizard.WizardManager.finish(WizardManager.java:224)
      at org.pentaho.jfreereport.wizard.ui.WizardPanel.widgetSelected(WizardPanel.java:324)
      at org.pentaho.jfreereport.wizard.ui.step.ReportSetupPanel.widgetSelected(ReportSetupPanel.java:820)
      at org.pentaho.jfreereport.wizard.ui.swt.PentahoSWTButton.fireSelection(PentahoSWTButton.java:518)
      at org.pentaho.jfreereport.wizard.ui.swt.PentahoSWTButton.mouseUp(PentahoSWTButton.java:500)
      at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:137)
      at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
      at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:940)
      at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:964)
      at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:949)
      at org.eclipse.swt.widgets.Control.sendMouseEvent(Control.java:2362)
      at org.eclipse.swt.widgets.Control.processEvent(Control.java:4434)
      at org.eclipse.swt.widgets.Composite.processEvent(Composite.java:1374)
      at org.eclipse.swt.internal.swing.Utils$1.mouseReleased(Utils.java:137)
      at java.awt.Component.processMouseEvent(Unknown Source)
      at javax.swing.JComponent.processMouseEvent(Unknown Source)
      at java.awt.Component.processEvent(Unknown Source)
      at java.awt.Container.processEvent(Unknown Source)
      at org.eclipse.swt.internal.swing.CCompositeImplementation$1.processEvent(CComposite.java:121)
      at java.awt.Component.dispatchEventImpl(Unknown Source)
      at java.awt.Container.dispatchEventImpl(Unknown Source)
      at java.awt.Component.dispatchEvent(Unknown Source)
      at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
      at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
      at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
      at java.awt.Container.dispatchEventImpl(Unknown Source)
      at java.awt.Window.dispatchEventImpl(Unknown Source)
      at java.awt.Component.dispatchEvent(Unknown Source)
      at java.awt.EventQueue.dispatchEvent(Unknown Source)
      at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
      at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
      at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
      at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
      at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
      at java.awt.EventDispatchThread.run(Unknown Source)

        Attachments

          Activity

            People

            Assignee:
            gdavid Golda Thomas
            Reporter:
            pcruz Pablo Cruz (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Due:
              Created:
              Updated:
              Resolved: