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

baggypants

Members
  • Posts

    213
  • Joined

  • Last visited

 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 baggypants

  1. If it's a single select list then use $P{parameter} $X{} is specificaly for multi select lists.
  2. If the data column is in the DB as a Timestamp then this is perfectly expected behaviour. When I have to use timestamp data I edit the query to somthing like WHERE Timestamp_data BETWEEN $P{startday} AND ($P{endday} + 1 day)
  3. Have you copied across all the child resources a report might be linking to? Images, chart themes etc...
  4. There is a good post about fonts and jasperserver here http://mdahlman.wordpress.com/2010/04/16/fonts-in-jasperserver-3-7/
  5. The default HTML view for jasperserver does not allow overlapping elements, objects which are underneath something else are not rendered, You could try patching 3.7.1 to use the XHTML render instead, information here http://jasperforge.org/projects/jasperserver/tracker/view.php?id=4433
  6. Drag the field to the Summary band and it will ask you if you wan't to SUM. Otherwise right click on the Variables submenu of the Report Inspector window and click "NEW"
  7. baggypants

    3.7.5

    I'm loving the Parameter creation panel in the SQL window. Touch of Genius.
  8. Here is a good blog post about fonts in Jasperserver http://mdahlman.wordpress.com/2010/05/28/jaspersoft-v3-7-font-extensions/
  9. It dosn't appear to exist, either in sourceforge or as a tag in the source tree for ireport classic or ireport-nb. Please check if the requirement is either a different version or for JasperReports which is a different thing.
  10. Are you sure your not getting confused with the report engine Jasper reports? http://sourceforge.net/projects/jasperreports/files/archive/jasperreports/JasperReports%203.0.1/
  11. How is it not a stand alone app currently? The only prerequisite is Java
  12. I've done this by creating two parameters The first one $P{COMAPANY} takes the input from the user (if any) The second one $P{COMPANY_SCRIPT} manipulates the first one e.g. Default Value Expression is ($P{COMPANY}.equals( null ) ? "" : "AND COMPANIES.CODE =" + $P{COMPANY} ) Then I pass that parameter back to the Query WHERE TRANS_CARDS."CASH_LOAD" IS NOT Null$P{COMPANY_SCRIPT} Post Edited by baggypants at 07/14/2010 10:33
  13. Right Click the very top item in the Report Inspector and choose Add Report Group Or click on the space above the Title band or below the Summary band then right click in there for the same thing
  14. Hyperlinks, with target:Blank to open in a new window?
  15. On mine the Publish Report and Run Report unit change their availablility depending on what item is currently selected in the Repository. e.g. if I select a folder then the Publish button comes available, If I choose a report unit then the Run button is active. Although they don't work for me either. I normally right click and choose an action from the context menu.
  16. Have three columns with the concatenated cell being the first one and then hide it somehow.
  17. I've not had a problem, and I can open your jrxml file fine and look a the query fine. I've reported a few other Null Pointer exceptions that people don't seem to get either. Best work around is to revert to an eariler version, I reccomend 3.7.1 as 3.7.2 had a Nullpointer exception on compatibility file saving for me.
  18. Recently I've noticed iReport has started saving files with only Unix line feeds and not MS ones. Is there a setting to get it to use MS line feeds again? It's getting harder to do quick edits on machines I don't want to have to install iReport or Notepad++ on.
  19. I did something like this by interveaving the series into one column using UNION queries in the SQL SELECT TIMECOLUMN, DATA1 AS DATA, 'SERIES1' AS SERIESFROM TABLEUNIONSELECT TIMECOLUMN, DATA2 AS DATA, 'SERIES2' AS SERIES FROM TABLE2UNIONSELECT TIMECOLUMN, DATA3 AS DATA, 'SERIES3' AS SERIESFROM TABLE3ORDER BYSERIES Now this still won't help you as it still has a fixed number of series. But if you can get your data to be arranged into just three columns, Data, Time and Series (Lable as well if you want) then you've cracked it. Post Edited by baggypants at 06/15/2010 09:52 Post Edited by baggypants at 06/15/2010 09:53
  20. Create another group which is Column1||Column2 and set that above column1 and then hide it?
  21. Hello, welcome to the forum, please note we are not a huge community so you may have to do a bit of searching on your own to find stuff. This forum is for iReport the report writing software for JasperReports which is the report engine for JasperServer There is a dedicated forum for JasperServer Here: http://jasperforge.org/plugins/espforum/browse.php?group_id=112&forumid=102 If you want to run Oracle as the underlying DB try this thread http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=75345
  22. I don't know about ireport 3.0 I've never used it. In ireport 3.7.1 I had to convert the mm to pixels as thats the only page measure it used and I had endless fun having to remove all the header, footer and summary sections and then change the page margins to allow a sensible detail band size, but it has worked. If your printing on sheets of lables and not a roll and if 3.0 supports it then you may want to alter the columns instead.
  23. Have you tried putting quotes around the parameter. i.e. select * from rbapmst_tb where APMST_DLR_NO = '$P{dlrNo}' Post Edited by baggypants at 05/27/2010 22:52
  24. How does it look if you output the JasperServer report as a PDF? If it look the same as the ireport then the issue is likely to be the blue background is hidden behind the elements which are white. The HTML output of JasperServer does not show items that are behind other items.
  25. Certainly don't expect images in a CSV file, CSV stands for Comma Separated Values (or something like that) it is a text only format which doesn't support any image embedding at all. XLS format theoreticaly alows graphs to be embedded in them but I think they are a specific MS format unsupported by the exporter. You might get their text descriptions saved if you hide the descriptions behind the images using a static text field. in pdf and HTML thiese would be invisible but in CSV and XLS you would see them as the images dont get exported.
×
×
  • Create New...