clarson

Why do most of my reports ignore the parameter order while a few return a sql error? I am using iReport 3.5.0 Professional. If it matters, I am using Oracle for all queries. It seems to happen more when I use the same parameter in a query more than once. However, this doesnt seem to be always true. Any ideas? Thanks, Cam

Where do we get iReport Professional? Is this new? How do we get the professional version? -Cam

I just completed the same steps as before with the following differences. I received the same result. I was hoping this would have been fixed by using the same version of iReport as JasperServer. 1. Created the jrxml from iReport 3.5.0 (downloaded 5/8/2009) 2. Deployed to JasperServer Pro 3.5.0 (new install)

Aliasvector, Try changing your parameter from $P{orderfield} to $P!{orderfield} -Cam

I have found the issue. The JRXML is malformed. If you remove the tags that have pieSeries and redeploy the report, it will work. This seems to be a HUGE bug in iReport 3.5.0

Here is a simple java string that I use. ( $F{CLASS_ID}.equals($P{class_id}) ? null : $F{CLASS_ID} ) ( condition ? true : false ) -Cam

Try changing the image expression from "C:Holdcab.jpg" to "C:\Holdcab.jpg" -Cam

Jasper Server Pro 3.0.0 iReport 3.5.0 Error: com.jaspersoft.jasperserver.api.JSExceptionWrapper: org.xml.sax.SAXParseException: Element type "pieSeries" must be declared. When I create a report in iReport 3.5.0 and deploy to Jasper Server 3.0.0 I get the above error. To resolve, I have to remove the tags <pieSeries> and </pieSeries>, save and upload to the server. I am using the Jasper Plugin. How do I resolve this issue? Thanks, Cam Code: <pie3DChart> <chart isShowLegend="false"> <reportElement x="0" y="0" width="555" height="181"/> <chartTitle/> <chartSubtitle/> <chartLegend/> </chart> <pieDataset> <pieSeries> <keyExpression><![CDATA[$F{TRAN_DT}]]></keyExpression> <valueExpression><![CDATA[$F{GROSS_SALES_AMT}]]></valueExpression> </pieSeries> </pieDataset> <pie3DPlot isCircular="true"> <plot/> </pie3DPlot> </pie3DChart>

I have just upgraded from 3.1.4 to 3.5.0. I am using Jasper Server 3.0.0. I now get this error when I open a report using the Jasper Plugin. Error loading the report template: org.xml.sax.SAXParseException: cvc-complex-type.3.2.2: Attribute 'theme' is not allowed to appear in element 'chart'. I can take the original file that is stored locally and it opens fine. The report runs fine on the server. The report was created and uploaded to Jasper Server 3.0.0 using iReport 3.5.0. -Cam

I am looking for an answer to this question also. I have been unsuccessful in getting an answer.

Hi, I have 2 reports. When you click the hyperlink in the main report, it opens the 2nd report with passing the appropriate parameters. How do I get it to go to a specific anchor on the 2nd report? The second report is a list that spans more than one screen of text. I want the second report to jump to a specific anchor. I can get this to work on the same report using the link type "local anchor". I have tried to change the link type to "remote anchor" but that doesnt seem to work. Thanks, Cam

Hi, Is it possible for a Parameter with a data type of query to pass its value to another parameter with the data type of query? EXAMPLE: I want to have a parameter that has a drop down list of all department groups. After they select the department group, that value gets passed to the second query parameter that limits the list of departments available for selection. From here, the department value gets passed to the report for execution. Is this possible using the already built in functionality? Can this be done w/ extra code on my side that will help facilitate this request? Thanks, Cam

Hi, Is it possible for a Parameter with a data type of query to pass its value to another parameter with the data type of query? EXAMPLE: I want to have a parameter that has a drop down list of all department groups. After they select the department group, that value gets passed to the second query parameter that limits the list of departments available for selection. From here, the department value gets passed to the report for execution. Is this possible using the already built in functionality? Can this be done w/ extra code on my side that will help facilitate this request? Thanks, Cam