Jump to content
We've recently updated our Privacy Statement, available here ×

Thomas Zimmer

Members
 View Profile  See their activity

  • Posts

    196

  • Joined

  • Last visited

  • Days Won

    13

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Everything posted by Thomas Zimmer

  1. Thomas Zimmer
    I cannot see, why the example above should be a new chart type? Is it because of the background image? If you do not have very much time, I would disadvice from implementing extension to the core engine... Cheers, Thomas http://www.thomaszimmer.net P.S.: for your convenience, I added a sample report based on the sample database in iReport with chart and background. Use that as a subrpoert. What you have to do is to light up the background image.
  2. Thomas Zimmer
    I did not understand finally what you are planning to do with the content in iReport (the string list), but apart from that from my point of view you already have done everything correctly; It is not mandatory to use a variable in the report to access the results of your java class. In all expressions in the report you may access all public methods of your scriptlet directly. Of course, you can write the result into that variable in the scriptlet, too, then use the variable in the report, but you don´t have to. A main point would be, at which time the result is calculated in the scriptlet class and and which time you access these values in the report execution process. If you want to print the list of strings from your scriptlet row-wise in your report, it would be a good idea to build a list datasource of them, then use this datasource with alist, table, crosstab, subreport, whatever. Hope this helps. Cheers, Thomas http://www.thomaszimmer.net
  3. Thomas Zimmer
    Pls. show a sample what you are exactly planning to show. Thanks.
  4. Thomas Zimmer
    Would be to easy, but I ask anyway: Is there a line break (n) in "EP"? Are there other settings (Print When detail overflows, Stretch with overflow, ... ) for this field than the other fileds in the line? Differs the font size or style? Could you pls. post the report? Cheers, Thomas http://www.thomaszimmer.net
  5. Thomas Zimmer
    I would link the lists together to generate one single list (datasource). Then use sorting by name and graduation. Group by name. Then, always three records belong togehter, showing the grades of one student in a detail band. Use the group header to have the titles "Under Graduation1:", ... Cheers, Thomas http://www.thomaszimmer.net
  6. Thomas Zimmer
    Have a look at the components on the Talend Exchange Website from Jan Lolling: http://www.talendforge.org/exchange/index.php?page=&product=tos&nav=1,2,1#tos_577 With these components (used with Jaspersoft ETL) you should be able to build an iteration flow over your customer-ids and run the report with the ids as parameters. You can store the reports in JS´ repository or on the file system. Additionally you could use the Jaspersoft ETL´s components to email the report results to your customers. I only participated a webinar last week concerning the components and did not use them by myself, but they look great Cheers, Thomas http://www.thomaszimmer.net
  7. Thomas Zimmer
    Perhaps it would be an idea to pass the subreport expressions and datasources dynamically as parameters of your main report (parameter subreport1-8 and ds1-8, where you can set the ordering by yourself). It should also be possible to define expressions with if-else structures using a sequence input parameter. Like that, you can define which content (of subreport) is printed where in the main report. What you cannot do is to have dynamic postions of your subreports, these are static. Cheers, Thomas http://www.thomaszimmer.net
  8. Thomas Zimmer
    You can do this by setting the global jasperreports.properties (file should be located at <js-install>/tomcat/webapps/WEB-INF/classes/jasperreports.properties or similar). Have a look at the config reference: http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.csv.field.delimiter Cheers, Thomas http://www.thomaszimmer.net
  9. Thomas Zimmer
    That´s the expected behaviour. See the difference in the two following images: Left image: 9 columns in resulting xls/csv Right image: 4 columns Whereby it doesn´t matter in which bands the elements are placed... Cheers, Thomas http://www.thomaszimmer.net
  10. Thomas Zimmer
    Have a look here: http://community.jaspersoft.com/wiki/getting-started-rest-web-service-api At the end of the page you will find a sample app, what does specifically that. I pimped that example a bit for executing and downloading a report. Have a look at this post: http://community.jaspersoft.com/questions/815042/run-report-using-restv2-and-java Cheers, Thomas http://www.thomaszimmer.net
  11. Thomas Zimmer
    No, jasperreports connot write dbf files directly. Options are: 1) Wirte xls files, use a converter to generate dbf from the output. I found some free ones by internet search 2) Write your own exporter. As I see, the format specification is open Cheers, Thomas http://www.thomaszimmer.net
  12. Thomas Zimmer
    Possibly I do not understand rightly... Why do you use line breaks "n" in your text field expressions? Isn´t it possible to have single expressions in a detail? Then you could set the height of the text field to 23px statically and draw the border around the fields, instead of trying to create a "background grid"
  13. Thomas Zimmer
    As far I can see, it depends on the output format you select. In xls it works, as pdf or internal preview unfortunately not. So, if your question about "on the server" means jasperserver, the reply is "no". That does not work. You will find many posts asking the same question if you use the search words "combine horizontal and vertical subreport" But if you have your own application generating the report, you could generate the single, different-oriented subreports one by one, and then put them all together using the iText library or the JR PDFExporter. Have a look here: http://ngjweb.wordpress.com/2011/12/09/fix-jasper-report-multi-oriented-pages/ or here: http://community.jaspersoft.com/questions/513721/landscape-and-portrait-layout-same-report Cheers, Thomas http://www.thomaszimmer.net
  14. Thomas Zimmer
    This issue was addressed several times: http://community.jaspersoft.com/jasperreports-library/issues/4594 , http://community.jaspersoft.com/questions/530836/ignore-pagination-and-virtualizers However, I can not see a solution in the discussions. Did you try to use band filters? With them, you could achive the same xls-view without pagination: http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.{format}.exclude.origin.{suffix}.{arbitrary_name} and http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.{format}.exclude.origin.keep.first.{suffix}.{arbitrary_name} But I do not know how it works in conjunction with file virtualizer (but i don't think that should make problems) Cheers, Thomas http://www.thomaszimmer.net
  15. Thomas Zimmer
    The explanation you posted is very old, version 3.0. The import/export sripts are now placed in <jasperserver-install>/buildomatic/ Doesn't your OS have a file search? Cheers, Thomas http://www.thomaszimmer.net
  16. Thomas Zimmer
    The SimpleFileResolver uses a java.util.List which is not serializeable. Looking at the source, I assume the simplest way to get around would be to implement your own FileResolver (implement the net.sf.jasperreports.engine.util.FileResolverInterface, copy from SimpleFileResolver and use an ArrayList instead of List) Cheers, Thomas http://www.thomaszimmer.net
  17. Thomas Zimmer
    Did you try to create a simple query with the query designer in iReport?
  18. Thomas Zimmer
    Do a repository export on machine A and an import on B. You will find the import/export scripts under <jasperserver-install>/buildomatic/... > A and B should be the same versions of JS (not CE and Professional...) > You will have to use the overwrite flag on import potentially > The import doesn´t delete data on B which you don´t want to have anymore Would it be possibly to simply create a DB backup an A and get that to B? Cheers, Thomas http://www.thomaszimmer.net
  19. Thomas Zimmer
    You don´t need to use column or row totals of a crosstab (deselect). Simply set the column with Header... as row group, the year column as column group, and the data you want to display as measure. Then the crosstab should nearly exactly show what you want. For general, IMHO a multi-column layout of a jasperreport is NOT intended to build a table-layout output. It´s more to show up data in a daily newspaper stype. However, if you know your data exactly, you could manipulate your dataset to have the headers as data; then have 3 records (headers) in the first column, one year and two data records in the next column, and so on. But I cannot imagine that´s a good approach. Cheers, Thomas http://www.thomaszimmer.net P.S.: And if it´s your intention to have a report with four columns and only three static years, don´t use a column layout at all; simply get records with all the information for the three years in it and design a one column report with all tehe information in a single detail band. Crosstabs are only good, if you want to show data in a variable amount of columns.
  20. Thomas Zimmer
    Did you perhaps run the test twice? It creates a folder on the jasperserver, which won´t be deleted automatically. So, before re-running, you have to delete by yourself the folder. If not, did you check the login credentials? Maybe you changed username and/or password on jasperserver? You would have to change this in the sample package too, there is a class with constants including username and password somewhere. Cheers, Thomas http://www.thomaszimmer.net
  21. Thomas Zimmer
    Have a look at the jasperreports source package. There are a bunch of examples, especially an example with two different ways to execute subreports: http://jasperreports.sourceforge.net/sample.reference/subreport/ For general, you either have to pass a ready compiled subreport (object) e.g. in a parameter to your masterreport, or you will have to pass a valid subreport expression. This could for example be $P{SUBREPORT_DIR} + "mysubreport.jasper", where $P{SUBREPORT_DIR} has to be a valid path, accessible from your webapplication. Cheers, Thomas http://www.thomaszimmer.net
  22. Thomas Zimmer
    I don´t know exactly how to do with MS Dyn... but the different databases use diferent text enclosuring. I think you could try to use the query designer in iReport to createa simple sql, then look how the tablenames are enclosed (i would assume " or ') Cheers, Thomas http://www.thomaszimmer.net
  23. Thomas Zimmer
    Have a look at this: http://community.jaspersoft.com//questions/815695/how-hide-field-print-preview You can use csv, xls, pdf and others instead of graphics2d in the example above. The elements you want to exclude must have the key <whatever4afilterUneed> You are also able to filter whole bands in a certain output format: http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.{format}.exclude.origin.{suffix}.{arbitrary_name} Cheers, Thomas http://www.thomaszimmer.net
  24. Thomas Zimmer
    It is not possible to vertical align a text in a text filed over multiple details. For a bunch of good reasons. What you could do, is group the report by your column a, place a stretching text field. Then you could use a subreport, table or list to show the lines belonging to that group. Possibly using a crosstab would be a solution, too. Cheers, Thomas http://www.thomaszimmer.net
  25. Thomas Zimmer
    Do not use a "background grid". Simply set "Padding and borders" to your text fileds by right-clicking. To stretch all text fileds in a row in common when one of them is stretched, set value "Stretch type = Relative to ..." Cheers, Thomas http://www.thomaszimmer.net
×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore