augarte

Hi, If you only post the query is very difficult to figure out what is happening... How many rows does this query return in the case data is appearing over 300 pages? Where is your data placed in your report? In which band?If you attach your jrxml file and tell us the number of rows the query is returning it will be easier to help you. Regards

Hi, If you want iReport in German you have to edit the iReport.conf file (in %IREPORT_DIR%/etc/) and add the option I have set in bold in the default_options: default_options="--branding ireport -J-Xms256m -J-Xmx512m -J-Dorg.netbeans.ProxyClassLoader.level=1000 -J-XX:MaxPermSize=512m" -J-Duser.language=de I have tried and as you can see in the attached file I have iReport in german. Hope this helps. Regards. P.D: Anyway, I see that some of the options of the menu are in German and some others are still in English so maybe is something that is still to fix. Post Edited by augarte at 06/21/2012 06:31

Hi, You need to set a latitude and longitude for the map, and then set a zoom. You can see in the attached example that I have created two parameters (float type) to set the coordinates of the map. In my case, I have used this webpage to obtain the coordinates of a point, having the addres: http://www.agenciacreativa.net/coordenadas_google_maps.php Hope this helps. P.D. I've also attached the image of the Google Maps Marker because I didn't find the way to mark the exact point with the iReport map component. You just have to modify the link to the image in the jrxml file.

Hi, I've never used this type of database connection but it seems that you need to type the driver name manually. Check the following link: /questions/533030/as400-jdbc Even if it does not appear in the drivers list, if you type manually the text mentioned in the link (com.ibm.as400.access.AS400JDBCDriver) it should work because you already added the class in the iReport classpath. Hope this helps.

Hi, I'm not sure but could be because the height of your 'Detail' band is so large (317 pixels). The height of the page is 595 pixels with 20 pixel vertical margins. That means that 2 Detail bands don't fit in one page and this could be the reason of displaying each row in one page. Try setting a smaller height to the 'Detail' band. Do you really need the big blank space between both data? I attach your jrxml with a smaller height. Hope this helps. Regards.

Hi, Check this: http://community.jaspersoft.com/questions/526232/ireport-313-no-report-inspector-window I think this will solve your problem. Regards.

The elements you place in the detail band are repeated as much times as iterations your datasource has. For example, if you have a Database datasource and you define a query that returns 5 rows, the content of the detail will be repeated 5 times. I guess this is what is happening to you in that case. Regards.

Hi, How is "Stretch With Overflow" property set for these textfields? If it is set to true it should stretch when the content of the textfields is bigger than the width.

If you want to use a database connection, the data you add in the report is defined in a query. This query can be dynamic because you can use parameters to have different results in each execution. Anyway, if you don't like the option of the database, you can use Xml DataSource, Java Bean datasource, and other ones... You can see all the different datasources in the attached image.

And why don't you insert the line inside the subreport? I mean, put the Title in the tile band and then you can put the content in the detail band inside a line. Something like the attached example (in the example everything is inserted as static text, in your case will be data retrieved from your database) HTH Regards

Hi, To define your query you can click in the icon that is marked with red colour in the attached image. This will open the report query (in the second image) and here you can define your query, if you click 'Automatically Retrieve Fields' it will create the fields automatically from the query, then you click in Ok and the fields will be ready to drag and drop to your report. Hope this helps. Regards

Hi, I've never had this problem with iReport, but it happened to me with another java applications. Maybe increasing the maximum memory asigned to the heap will solve your problem: http://wiki.caucho.com/-XX:MaxPermSize If you go to your iReport installation directory and open the ireport.conf file (inside etc folder), you'll see something similar to this: default_options="--branding ireport -J-Xms256m -J-Xmx512m -J-Dorg.netbeans.ProxyClassLoader.level=1000 -J-XX:MaxPermSize=512m" The las parameter sets the maximum memory, and maybe (it is not my case) you'll need to increase it. Try setting it to 1024m or even to 2048. Hope this helps. Regards. **Edit: I've also found the following link where says how to increase the memory. Here is talking about eclipse but I guess it is the same with iReport. http://www.jasperassistant.com/docs/guide/ch02s05.html Post Edited by augarte at 06/13/2012 14:29

Not sure if this will solve your problem but what I'd do is to include the title of each subreport inside the subreport. For example, add it in Title band. And then, when you add the subreport in the main report check this property: Print In First Whole Band Flag that determines whether the object gets printed in the first section of a new page or column that is not an overflow from a previous page or column. I've never used it but it seems that if the entire subreport doesn't fit in one page everything will be added in the next page... Hope this helps Regards

Hi, If I understood well, you need to do something similar to the attached report. As you can see in that example there are a lot of fields with float position and the height of each field is 1 pixel. If you select "stretch with overflow" option the field will be stretched depending on its value, but if it does not have a value, the blank space will only be 1 pixel so a human sight can not see it clearly. Don't know if this is your problem or I misunderstood it. If so, tell me what's the difference and will try to help you. HTH, Best regards!

Hi, To see the fields you have to define a query in the "Report Query" section. After doing that and retrieving the fields you'll see that the fields returned by your query are added. Here you have a tutorial, I guess you have a newer version of iReport but maybe this could help you defining your query: http://www.thainetbeans.com/sample/reportquery.htm Regards.

Hi, In your link says that Jasper is supported by Java 5, but if doesn't say that JasperReports 4.5.1 is supported by Java5. I've never used this version of JR but you can find some links where it says that both tools are not compatible: http://community.jaspersoft.com/questions/542164/jasperreports-451-using-jre-16-method-report-virtualization http://jasperforge.org/plugins/espnews/browse.php?group_id=102&news_id=306 Maybe you could try to donwload the sources of Jasper 4.5.1 and compile them with Java 5 but don't know if this will work. Hope this helps. Regards.

Yep that's it. The detail band is printed as much lines as your datasource has. Let me know if you have any problem ;-) Regards.

In which kind of applicaton will you run your Jasper Reports. If you can compile, fill and create the output of this reports from Java code you can always set the name you want to this documents. Check the following example: JasperReport Rep = JasperCompileManager.compileReport ("MyReport.jrxml"); /* Create the JasperPrint object with the template and the data */ JasperPrint Prn = JasperFillManager.fillReport (Rep, new HashMap (), MyDataSource); /* Export the report to pdf format */ JasperExportManager.exportReportToPdfFile (Prn, "Test.pdf"); Here you can see that I compile a jrxml file, then I fill it with my datasource and then generate and ouput (pdf) format. The name is "Test.pdf" in this case but you can get it from a dtabase or wherever it is defined. Do not hesitate asking if you have any doubt. Regards.

Hi, If you place the suberport in the Detail band of your master report it will be printed as much times as rows your DataSource has. For example, if you use a database conection and your query returns 10 rows, the subreport will be printed 10 times. Then you have to be carefull with the content, because maybe you are using parameters of fields that affect to the content of the subreport. Hope this helps. Regards.

Hi, I want to display the printing dialog when I print my jasper reports. Until now, I have used two methods for printing my reports: 1) JasperPrintManager: this one is very simple and easy to use. I just call to printReport method and it prints it. It has two parameters (jasperPrint and printDialog) so if I set the second parameter as 'true' it displays the Windows printing dialog (because I'm running Jasper on Windows) 2) JRPrintServiceExporter:This method allows us to specify more configurations for the printer. For example, which is very interesting in my case is that I'm able to specify a JasperPrint List (this is very usefull because in some cases I have more than one JasperPrint object). If I set 'displayPrintDialog' attribute as true, it displays a different dialog (I think it is Java based dialog). In this case also, as you can see in the attached screenshot, the "Properties" button (Propiedades), is disable and I don't know why. My problem is that I somehow want to combine properties of both methods. What I need is to print a list of JasperPrint objects but with the OS based Printing Dialog and not with the Java based one. So the options I have been checking are the following ones: Using JRPrintServiceExporter, display OS based printing dialog. I couldn't find nothing about that Print a List of JasperPrint objects with JasperPrintManager. What I've been doing is to iterate the JasperPrint list and call to printManager as number of times as JasperPrint objects the list has. The problem is that I want to display the printDialog for the first JasperPrint and keep the configuration the user has choosed for printing the rest of the list. I have tried to do it without sucess. ...Does anyone know what could I do solve my problem. I guess it is not easy to do what I want but if someone has a solution it'd be really helpfull. So thanks in advance for your attention. Kind regards. Aitor. P.D: I attach two screenshots with both printing dialogs (OS based and Java based). Just if someone does not understand what I want to say.

Hi, I've never tried it but the JasperViewer has an option to pass the Locale you want: JasperViewer(JasperPrint jasperPrint, boolean isExitOnClose, java.util.Locale locale) You can find it in the Javadoc: http://jasperreports.sourceforge.net/api/net/sf/jasperreports/view/JasperViewer.html So you may need to call the JasperViewer as follows: JasperViewer (YourJasperPrint, false, Locale.CHINA); Hope this helps, Regards.

Hi, I have a problem when I add double type fields to my reports. The connection I use is JDBC - MS SQLServer (2005). My problem is that if I add this field to my report and I preview, I see the value of the field as "4.8077013294799995E8". If I execute the same query I have defined in the jrxml in the Sql Server Studio, the value is "480770132,948". I tried to set a pattern with two decimal numbers but it is not working... does anybody know how can I solve this? Do I have to change the query or cab be fixed in iReport? Thanks in advance. Regards!

I guess the "Font name" for your field is 'book antiqua' but the "Pdf font name" is set to Arial. Anyway, in my case is not possible to select 'Book Antiqua' in "Pdf font name" so maybe you should consider using another font type. HTH. Regards.

Hi, Note that in the text properties, below the "Font Name", you have another property "Pdf Font Name". You have to set this as bold (for example 'Helvetica Bold') if you want tho show it as Bold in the PDF file. Hope this helps. Regards.

You say that JasperReportsx.x.jar file is available but where is it? Are you using any IDE to compile your project? How do you compile it? Have you added this jar to your compilation classpath? Regards.