Jump to content
Changes to the Jaspersoft community edition download ×

crusty_collins

Members
 View Profile  See their activity

  • Posts

    31

  • 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 crusty_collins

  1. crusty_collins
    I have never done this but there is a return variables tab in the properties of the sub report. High leve I think you have to setup variables in both reports and set the caculation type to system.
  2. crusty_collins
    Use the print when statement
  3. crusty_collins
    Make sure you are not assigning $P{von} to $F{some value} under the parameter settings. Post Edited by Chris Collins at 01/30/09 22:30
  4. crusty_collins
    For number 3 this may work Not Tested new Boolean($F{amount}.intValue() > 1000 || $F{amount}.intValue() < 10 : "true" ? "false")
  5. crusty_collins
    Not sure if this is it but you must have the $P{name} setup in the master and sub report. If I am creating a variablel parameter I set the value with a statement like the one below. Code:($F{varname}.equals("ups")?"Today's Ups":$F{varname}.equals("avg")?"Today's Avg ":"NOTHING")
  6. crusty_collins
    Use SELECT 1 It should work to fire off the report
  7. crusty_collins
    I see what you are saying. I think you will need to do this in the query with some case statements. Checkout this site for help with that http://www.artfulsoftware.com/infotree/queries.php?&bw=1280 Or you could do a variable with an if statement where you use the value ($F{hour1}?$F{hour1} :$F{hour2}?"$F{hour2} etc :"") But , really what you want to do is change the db to use relational db. the code below is what I would do. and then your query would be like this which would give you what you want. select h.hour,c.name from data_table join hour_table as h on h.ref = c.hour_ref Code: Post Edited by Chris Collins at 01/27/09 17:56
  8. crusty_collins
    Be specific about what you are running and what the problem is.
  9. crusty_collins
    Edit the report properties edit->report properties. click on the more tab set the print order to horiz
  10. crusty_collins
    I usually do this. select name,date,value from table where date = curdate() • Draw a chart of type line in the summary band • Edit the properties of the chart Click on the chart tab Click on edit chart properties Click on the chart data tab. Click on details tab. Click on add. • For series expression use $F{name} • for category expression use $F{date} • for value expression use $F{value} • Run the report Post Edited by Chris Collins at 01/23/09 20:21
  11. crusty_collins
    Seemed to be the preset size of a4. A letter size works fine.
  12. crusty_collins
    You need to be specific in your title, and question. ALWAYS check the docs and search the forums before asking a question
  13. crusty_collins
    You will have a write your own datasource if you want that.
  14. crusty_collins
    Google java date subtraction.
  15. crusty_collins
    I have never gotten that to work.
  16. crusty_collins
    You may need to cast the field as date type. In the past I used CAST(date_format(date , '%Y-%m-%d' ) as DATETIME) as date but that is MySql
  17. crusty_collins
    I have had success setting the "print if first whole band" to true in my first sub report
  18. crusty_collins
    I usually use a simple query to at least get the details band to print so my subreports will get called. " select 1 " should get you going
  19. crusty_collins
    set the label expression new String("something " + $F{value}.toString())
  20. crusty_collins
    What you are asking should be easy by setting up the column in the report settings. Post Edited by Chris Collins at 01/20/09 21:20
  21. crusty_collins
    do this in your query.. not tested and There are much better ways to do it but this is simple and readable. (SELECT site,"1" as n FROM site_table LIMIT 1,1)union(SELECT site,"2" as n FROM site_table LIMIT 2,1)union(SELECT site,"3" as n FROM site_table LIMIT 3,1)etc[/code]or build your own data source but that is a big topic. Post Edited by Chris Collins at 01/20/09 21:14 Post Edited by Chris Collins at 01/20/09 21:15
  22. crusty_collins
    So, I have this simple query which will return two rows and one column I keep getting the above error on the compile of the report but unlike normal errors it does not tell me where this token is. I have been useing this query for a couple of years on several reports so I must have done something. Has anyone seen this before? Code:select type FROM node_ref_table where type = 'OPRA' or type = 'IDN_RDF'group by type
  23. crusty_collins
    Maybe this will help... Use a print when function and make sure your fields are named the same. select a,b,c,"nothing" as d from db select a,b,"n" as c,"nothing" as d from db Then do a print when expression new Boolean($F{c}.equals("n") ? "False" : "True")
  24. crusty_collins
    It is to the point I can not answer or post.... and it is not my machine it happens on linux and xp
  25. crusty_collins
    Then I think the settings are saved in the following c:/documents and settings/username/.ireport/config.xml Make sure it is writeable. notice the (dot) in front of ireport Post Edited by Chris Collins at 12/17/08 21:57
×
×
  • Create New...

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

Products

Explore