yaroslav

help...

Good day. I'm a PHP developer and in my application I use SOAP for generation the reports. But now I have a few sites with the same functionality except data in database. And I'd like to set up some parameter in JRXML file like DATASOURCE_LOCATION. But as I now it's not possible. I spend some time on searching topics but no result /tools/fckeditor/editor/images/smiley/msn/sad_smile.gif. As I understand I need create some implementation of interface ReportDataSourceService and then delegate JdbcDataSource. But I'm not sure. Please help me to understand which classes needs to be implemented for my functionality. Thanks.

That's a great news. Thanks a lot!

Hello, I'm work with jasper server via webservice from PHP script. If I use JDBC everything works fine. But now I want set parameter in report. something like that: $a = array( array('name' => 'Mark', 'age' => 28), array('name' => 'Artur', 'age' => 15) ); And then display like a grid in report Name | Age ------------------------ Mark | 28 Artur | 15 ------------------------ Is it possible? Plese some examples or links where I can find it. Thanks.

Thank you well

I'm using jasperserver 3.5 but file jasperreports-3.5.0.jar not found in apache-tomcat\\common\\lib\\ Maybe present other way to upgrade jasperreports?

Restarting server don't solve the problem :( . Maybe present other solutions for resolve this situation? some patches?

Can you describe more detail how can I create report units that cross-reference to main file. Thanks

Is it possible to predefine the datasource and set it later in parameter? I have a few databases and I want run one report unit on different databases. I use PHP and SOAP to execute report unit. Post Edited by yaroslav at 09/03/2009 19:02

I need this functionality too :( Are you planning to implement this?

anish Wrote: hi all... can some one help me in the following lines... ------- Now all you need to do is send it to the back. Under the Format Menu choose the Send to Back option, and your done. ----- where is the format menu in jasper assistant... ?? plz help . Thanks in advance I have the same problem. Can't find the Send to Back option. Please help. Ireport 3.1.0

Solved. $V{COLUMN_COUNT} contain current row index

Something like $V{INC} = new Integer($V{INC}.intValue() + 1) but this does not work The left-hand side of an assignment must be a variable

Good day. I want to set autoincrement column. Any ideas how to do it?

You must install the PEAR Soap package http://pear.php.net/package/SOAP Post Edited by Yaroslav Zenin at 11/18/08 13:23

On each request you got the response xml, something like Code:<outputResult><returnCode>0</returnCode><returnMessage></returnMessage> <!-- here is your error message if returnCode != 0</outputResult> Post Edited by Yaroslav Zenin at 11/14/08 16:44

Thank you, so much!

Ok, I'm tring explain all step by step. 1. Create new report template in iReport <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD JasperReport//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="report name" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> <subDataset name="dataset1"/> <queryString> <![CDATA[select 1+1 as result]]> </queryString> <field name="result" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <background> <band/> </background> <summary> <band height="42"> <textField hyperlinkType="None"> <reportElement x="67" y="8" width="100" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{result}]]></textFieldExpression> </textField> </band> </summary> </jasperReport> 2. Send SOAP request All work fine. I got the pdf report with result “2”. But I want send dynamic query. On then clear queryString tag in iReport <queryString> <![CDATA[]]> </queryString> And try to add query <request operationName="runReport" locale="en"> <argument name="USE_DIME_ATTACHMENTS"> <![CDATA[1]]> </argument> <argument name="RUN_OUTPUT_FORMAT"> <![CDATA[PDF]] > </argument> <resourceDescriptor name="" wsType="reportUnit" uriString="/reports/samples/testquery" isNew="false"> <resourceDescriptor name="query" wsType="query" uriString="/reports/samples/TEST_QUERY_FILES/testquery" isNew="false"> <resourceProperty name="PROP_RESOURCE_TYPE"> <value> com.jaspersoft.jasperserver.api.metadata.common.domain.Query </value> </resourceProperty> <resourceProperty name="PROP_QUERY"> <value> SELECT 2+2 as result </value> </resourceProperty> <resourceProperty name="PROP_QUERY_LANGUAGE"> <value> sql </value> </resourceProperty> <label> query </label> <description> query </description> </resourceDescriptor> <label> Students list </label> </resourceDescriptor> </request> Then I got result <operationResult version="2.0.1"> <returnCode><![CDATA[0]]></returnCode> </operationResult> All success but I got empty report No “4” :( SELECT 2+2 as result And I don’t know how to send SQL query via SOAP. Where is the problem?

Thanks for your reply, Sherman. I'm use PHP and send request via PEAR SOAP library. I create jrxml file in iReport. If I put here sql query all work fine. But I want send sql query in SOAP request.And this does not working.How to write correct request? <resourceProperty name="PROP_QUERY"> <value>SELECT 2+2 as result</value></resourceProperty>[/code]This part does not work. See also my first message. Sorry for my terrible english.

I have the same problem too :(

Good day. I'm try to send query via SOAP but not success. Could somebody give simple request example please. Here is my request <request operationName="runReport" locale="en"> <argument name="USE_DIME_ATTACHMENTS"><![CDATA[1]]></argument> <argument name="RUN_OUTPUT_FORMAT"><![CDATA[PDF]]></argument> <resourceDescriptor name="" wsType="reportUnit" uriString="/reports/samples/testing" isNew="false"> <resourceDescriptor name="query" wsType="query" uriString="/reports/samples/testing_files/query" isNew="false"> <resourceProperty name="PROP_QUERY"> <value>SELECT 2+2 as result</value> </resourceProperty> <resourceProperty name="PROP_QUERY_LANGUAGE"> <value>sql</value> </resourceProperty> <label>query</label> <description>query</description> </resourceDescriptor> <resourceProperty name="PROP_QUERY_VALUE_COLUMN"> <value>request</value> </resourceProperty> <label>testing</label> </resourceDescriptor></request>[/code]