Pentaho Community Forums - Other Reporting Engines http://forums.pentaho.com/ Discussions around using other reporting engines in the platform en Fri, 24 May 2013 12:13:49 GMT vBulletin 60 http://forums.pentaho.com/images/misc/rss.png Pentaho Community Forums - Other Reporting Engines http://forums.pentaho.com/ <![CDATA[[ISSUE] JasperReport Execute Error]]> http://forums.pentaho.com/showthread.php?141967-ISSUE-JasperReport-Execute-Error&goto=newpost Fri, 03 May 2013 12:32:21 GMT Hi guys! I am trying to excute an JasperReport into Pentaho (biserve-ce-4.5.0). I have created the xaction file with Pentaho Design Studio. LIke... Hi guys!
I am trying to excute an JasperReport into Pentaho (biserve-ce-4.5.0). I have created the xaction file with Pentaho Design Studio. LIke this:

Code:
<?xml version="1.0" encoding="UTF-8"?><action-sequence>
  <name>Riepilogo Attivita Frontiera</name>
  <title>prova Frontiera</title>
  <version>1</version>
  <logging-level>debug</logging-level>
  <documentation>
    <author>James Dixon and Barry Klawans</author> 
    <description>%description</description> 
    <icon>jasper-reports-test-2.png</icon> 
    <help/> 
    <result-type>report</result-type>
  </documentation>


  <inputs>
    <output-type type="string">
      <default-value>html</default-value> 
      <sources>
        <request>type</request>
      </sources>
    </output-type> 
    <endYear type="string">
      <sources>
        <request>endYear</request>
      </sources> 
      <default-value>2012</default-value>
    </endYear> 
    <startYear type="string">
      <sources>
        <request>startYear</request>
      </sources> 
      <default-value>1999</default-value>
    </startYear> 
    <endMonth type="string">
      <sources>
        <request>endMonth</request>
      </sources> 
      <default-value>1</default-value>
    </endMonth> 
    <startMonth type="string">
      <sources>
        <request>startMonth</request>
      </sources> 
      <default-value>1</default-value>
    </startMonth> 
    <officeID type="integer">
      <sources>
        <request>officeID</request>
      </sources> 
      <default-value>10113</default-value>
    </officeID> 
    <ufficioEscluso type="integer">
      <sources>
        <request>ufficioEscluso</request>
      </sources> 
      <default-value>10361</default-value>
    </ufficioEscluso>
  </inputs>


  <outputs/>


  <resources>
    <report-definition>
      <solution-file>
        <location>RiepilogoAttivitaFrontiera.jrxml</location> 
        <mime-type>text/plain</mime-type>
      </solution-file>
    </report-definition>
  </resources>
 
  <actions>
    <action-definition>
      <component-name>JasperReportsComponent</component-name>
      <action-type>report</action-type>
      <action-inputs>
        <endYear type="string"/> 
        <startYear type="string"/> 
        <endMonth type="string"/> 
        <startMonth type="string"/> 
        <officeID type="integer"/> 
        <ufficioEscluso type="integer"/> 
        <output-type type="string"/>
      </action-inputs>
      <action-resources>
        <report-definition type="resource"/>
      </action-resources>
      <component-definition>
        <jndi>ORCL_CONN</jndi>
      </component-definition>
    </action-definition>
 
  </actions>
</action-sequence>
but when I try to launch the report on Pentaho I get the error reported in the log (attachement).
Please HELP ME!!!
Attached Files
]]> Other Reporting Engines master http://forums.pentaho.com/showthread.php?141967-ISSUE-JasperReport-Execute-Error JasperReportsComponent / exporting JasperReports into .ppt or .pptx http://forums.pentaho.com/showthread.php?141553-JasperReportsComponent-exporting-JasperReports-into-ppt-or-pptx&goto=newpost Fri, 26 Apr 2013 08:44:55 GMT Hello! I have lack of knowledge in this topic, but where i work, i got the task, that i need to report a jasperreport file (jrxml) into PPT format... Hello!

I have lack of knowledge in this topic, but where i work, i got the task, that i need to report a jasperreport file (jrxml) into PPT format via Pentaho. As i searched the problem in google, i found that Pentaho is prepared for exporting jasperreports into HTML or PDF. So i downloaded latest JasperReportsComponent.java file, and tried to add PPT into it.

(in theory, JasperReportsComponent can export in PPT via net.sf.jasperreports.engine.export.ooxml.JRPptExporter package)

My problem is, that i do not find the location, where i could place my JAR file, comiled from modified JasperReportsComponent.java.

Or other question, how could i achive that i can export a jasperreport into .ppt or .pptx format in pentaho?

Thanks

#############
##Re-editing my post, wish it will be more understanding now:
#############

I am using Pentaho, and i want to present JasperReport reports, made in iReport, in it. Everything works fine due to pentaho has a component called JasperReportsComponent which can parse ireports (.jasper) into pdf and html format. My problem is, that i need to parse ireports into ppt, or pptx format, i inspected, that a little bit of modification is needed in JasperReportsComponent.java, and then, it is capable of parsing jasperreports to ppt, or pptx via net.sf.jasperreports.engine.export.ooxml.JRPptExporter package. So i modified the freely downloadable JasperReportsComponent.java file, but i ran into the problem, that i dont know how to integrate it into pentaho :(

Background story: now, if i make a report in iReport, i generate a Jrxml file, AND a .jasper from it, i save them into a pentaho folder, and bind this .jasper file to the JasperReportsComponent component in an .xaction file like this:

<resources>
<report-definition>
<solution-file>
<location>myreport.jasper</location>
<mime-type>text/plain</mime-type>
</solution-file>
</report-definition>
</resources>

Above is the code sample where i load my .jasper file like a resource, and here is where i bind this to the component:

<action-definition>
<component-name>JasperReportsComponent</component-name>
<action-type>Jasper</action-type>
<action-inputs>
<output-type type="string" mapping="output_format"/>
</action-inputs>
<action-resources>
<report-definition type="resource"/>
</action-resources>
<component-definition>
<jndi><=!=[=C=D=A=T=A=[database]=]=></jndi>
</component-definition>
</action-definition>

And after this, in Pentaho, i can "open" the .xaction file, i can choose pdf, or html from a dropdown list, and the JasperReportsComponent parse my .jasper file into the choosen format.
You can see, that this way i cant produce a ppt, or pptx from my .jasper, becouse pentaho's component is not prepared for parsing into ppt.
So my question is, where do pentaho store resource files of JasperReportsComponent, and how could i replace it with my own edited JasperReportsComponent.java file?!
Thanks for any advice. ]]> Other Reporting Engines Jim-Y http://forums.pentaho.com/showthread.php?141553-JasperReportsComponent-exporting-JasperReports-into-ppt-or-pptx