Rayen.Drissi

Hi, Problem is solved when I placed the static text and parameter in Column Header Band. But why the 2 items aren't displayed when it placed in Detail Band?? Best Regards.

Hi, I use iReport 4.6.0, tomcat 7. I want to forward parameters from URL (tomcat) to iReport (without using a DB connection). When I preview the report in iReport using parameter as a prompt and empty datasource (It's works), but when I use the tomcat url the parameter is not displayed (because the data source using in the url : http://localhost:8087/JasperReportsIntegration/report?_repName=report2&_repFormat=pdf&_dataSource=test&_outFilename=&_repLocale=de_DE&_repEncoding=UTF-8&p_id=30 So, how can I forward parameter to be used in iReport? Create parameter in iReport : Preview report in iReport : Preview report using tomcat url : Thanks in advance. Best Regards.

Thank you for your help. Already the stretch type =>'Relative to Tallest Object'. I created Frame and group selected elements for each row then the problem is solved. Here is the result : Jrxml : <frame> <reportElement uuid="70cb42df-4e8f-4cbc-8d8f-f86a4aef9e3d" positionType="Float" x="119" y="233" width="332" height="20" isPrintWhenDetailOverflows="true"/> </frame> <frame> <reportElement uuid="4ca6a014-3eca-4c16-ae4e-079216b1e010" positionType="Float" x="119" y="253" width="332" height="20" isPrintWhenDetailOverflows="true"/> </frame> <elementGroup> <textField isStretchWithOverflow="true"> <reportElement uuid="b6102d47-3114-4673-a241-4dddb0e556bd" style="table" positionType="Float" stretchType="RelativeToTallestObject" x="133" y="213" width="100" height="20"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA["1"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true"> <reportElement uuid="c22b46b5-e528-4bb5-ad1c-a5fca06faf38" style="table" positionType="Float" stretchType="RelativeToTallestObject" x="383" y="213" width="55" height="20"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA["value 1"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true"> <reportElement uuid="66833d4b-1a6b-4398-9431-ed3ef80ef7dc" style="table" positionType="Float" stretchType="RelativeToTallestObject" x="233" y="213" width="150" height="20"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA["azertyuiop aaaaaaaaaaaaaaazeeeeeeerrrrrrrrrrrrtttttttttttttttttttttpmmmmmmmmmmmmmlk"]]></textFieldExpression> </textField> </elementGroup> <frame> <reportElement uuid="bc738f1d-150b-4959-9bc5-6a00b7112969" positionType="Float" x="119" y="213" width="332" height="20" isPrintWhenDetailOverflows="true"/> </frame> <elementGroup> <textField isStretchWithOverflow="true"> <reportElement uuid="78d019fd-5e89-47f1-a895-9a4f0f754000" style="table" positionType="Float" stretchType="RelativeToTallestObject" x="133" y="233" width="100" height="20"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA["2"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true"> <reportElement uuid="5935ad61-77ec-4b05-84bf-6f72d3dcd0bd" style="table" positionType="Float" stretchType="RelativeToTallestObject" x="233" y="233" width="150" height="20"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA["DP-GI"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true"> <reportElement uuid="83d4865c-f1af-4361-b6fd-9575a9835c7f" style="table" positionType="Float" stretchType="RelativeToTallestObject" x="383" y="233" width="55" height="20"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA["value 2"]]></textFieldExpression> </textField> </elementGroup> <elementGroup> <textField isStretchWithOverflow="true"> <reportElement uuid="1a2694c6-974b-493a-b0a6-09b2be10f63a" style="table" positionType="Float" stretchType="RelativeToTallestObject" x="133" y="253" width="100" height="20"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA["3"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true"> <reportElement uuid="450e7cce-5a49-4bbc-b502-d86352c7c873" style="table" positionType="Float" stretchType="RelativeToTallestObject" x="233" y="253" width="150" height="20"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA["AS-GE"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true"> <reportElement uuid="d8e7b402-0081-46ca-bd1c-2c3ae992b957" style="table" positionType="Float" stretchType="RelativeToTallestObject" x="383" y="253" width="55" height="20"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA["value 3"]]></textFieldExpression> </textField> </elementGroup> Best Regards.

Hi, Thank you for your post. I set position type of all text fields to 'float' and checked 'stretch with overflow'. I got this result : Best Regards.

Hi, I have 9 text fields, I want to stretch all these text fields with data overflow. In my case, for the text field A I set position type to 'fix relative to the top' and I checked 'stretch with overflow', for the text fields B, C I set position type to 'float'. But I got bad design, so I want the text fields (left-right) be in the same position (aligned) with the text fields A,B and C. Thanks in advance. Best Regards.

Hi, I created 3 text fields to store 3 values return from query (for example select ename from EMP ==> return 3 values :King, Allain and Joe ). the 3 text fields contains the same value (King), I want to store value1 ==> text field1, ..., value3 ==> text field3. it's possible to do this using text fields? Note : I created manually a table using text fields and static text. Thanks in advance. Best Regards.

Problem solved : I created 2 styles : <style name="PenStyle1"> <!-- for the text field--> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> </box> </style> <style name="PenStyle2"><!-- for the static text--> <box> <topPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> </box> </style> [/code]

Hi, It's possible to eliminate border between text_filed and static text like this example? I want to get this result : Thanks in advance. Best Regards.

Hi, See this link (how to display blob image in iReport): http://ireport-tutorial.blogspot.com/2008/11/show-blob-image-in-ireport.html Best Regards.

Thank you :)

Hi, I want to create a table with 2 columns and 4 rows (fix). For the 2nd row, I need to split cells (get 4 columns). How can I do this? Thanks in advance. Best Regards.

Hi, Thank you for your post. I found that it's possible to import/export svg format in iReport. But I want to know, if it's possible to create svg chart using iReport? Best Regards.

Hi, It's possible to create a svg diagram with iReport? Like this examples : Thanks in advance. Best Regards.

Hi, You are right, thank you. How can I modify the position of labels expressions (in my case Total (must be at top position) and year (must be at left position))? Thanks in advance. Best Regards.

Hi, I created a chart (XY Lines) using iReport, when I previewed my report the chart is duplicated. How could I get one chart? How can I add label to the XY lines (for example X: Year and Y: Total)? ..insert your code here..<?xml version="1.0" encoding="UTF-8"?><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="exp1" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="f594260c-b66c-4e92-bc07-5a4f77173c3c"> <property name="ireport.zoom" value="1.0"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <parameter name="p_ant_id" class="java.lang.String"> <defaultValueExpression><![CDATA[10]]></defaultValueExpression> </parameter> <queryString> <![CDATA[select count(*) total,ID tech,extract( year from date_tech) "Year" from Technologieswhere ID in (2,4,19)Group by ID,extract( year from date_tech)order by extract( year from date_tech)]]> </queryString> <field name="TOTAL" class="java.math.BigDecimal"/> <field name="TECH" class="java.math.BigDecimal"/> <field name="Year" class="java.math.BigDecimal"/> <background> <band splitType="Stretch"/> </background> <title> <band height="79" splitType="Stretch"/> </title> <pageHeader> <band height="35" splitType="Stretch"/> </pageHeader> <columnHeader> <band height="61" splitType="Stretch"/> </columnHeader> <detail> <band height="125" splitType="Stretch"> <lineChart> <chart> <reportElement uuid="20d77680-22cc-42b2-b010-5a437fa0e822" x="406" y="0" width="200" height="125"/> <chartTitle/> <chartSubtitle/> <chartLegend/> </chart> <categoryDataset> <categorySeries> <seriesExpression><![CDATA[$F{TECH}]]></seriesExpression> <categoryExpression><![CDATA[$F{Year}]]></categoryExpression> <valueExpression><![CDATA[$F{TOTAL}]]></valueExpression> </categorySeries> </categoryDataset> <linePlot> <plot/> </linePlot> </lineChart> </band> </detail> <columnFooter> <band height="45" splitType="Stretch"/> </columnFooter> <pageFooter> <band height="54" splitType="Stretch"/> </pageFooter> <summary> <band height="42" splitType="Stretch"/> </summary></jasperReport> [/code] Thanks in advance. Best Regards.

Hi, Yes I used a param named 'p_id' in the report template. Best Regards.

Hi, I created a report with iReport Designer (text label + param), when I click on Preview and I put number, its will be displayed in the Report. Now, I want to forward the param using URL : http://localhost:8087/JasperReportsIntegration/report?_repName=report2&_repFormat=pdf&_dataSource=default&_outFilename=&_repLocale=de_DE&_repEncoding=UTF-8&p_id=123 Only the text label is displayed : Thanks in advance. Best Regards.

Hi, Yes I'm already working with JasperReports and I use iReport to create my reports.

Hi, I need to forward params (values of columns) from Oracle APEX to be used in iReport designer without using a query (in iReport like : select * from Emp where empno=$P{empno}). Its possible? Thanks in adavnce. Best Regards.

Hi, I installed iReport 4.6 and the problem is solved. Thanks.

Hi, I created a report named 'report1' using iReport Design 5.6.0, and its compiled successfully and two files are created '.jasper and .jrxml' (D:...Apache Software FoundationTomcat 7.0webappsJasperReportsIntegrationreports) and the report is displayed in iReport Design by clicking at the button 'preview'. I used this url to show the report : http://localhost:8087/JasperReportsIntegration/report?_repName=report1&_repFormat=pdf&_dataSource=test&_outFilename=&_repLocale=de_DE&_repEncoding=UTF-8 But I encountered an error : Note : I have a report 'test' download from opal-consulting website, and its shown correctly. I used JasperReportsIntegration 1.3.0.2 Thanks in advance.