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

phantastes

Members
 View Profile  See their activity

  • Posts

    107

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

  1. phantastes
    Hi, Would anyone know how to achieve the following in iReport: Row Value 1 11111 2 22222 3 33333 4 44444 Group Total: 11111,22222,33333,44444 I need to take the value in each record and concatenate this value to the previous value, creating a comma separated list that will be displayed at the bottom of the group. Is this even possible. I'm guessing I need to handle this with a Variable somehow. Any ideas or suggestions are very welcome! Thank you
  2. phantastes
    Hi, It is possible to set the html id using net.sf.jasperreports.export.html.id. Is there any way to set the html class attribute in a similar way? Magnus
  3. phantastes
    Any ideas, pointers or speculations are very welcome!
  4. phantastes
    Hi Adi, Like I mentioned before: "I would recommend reading through one of the many SQL tutorials online. Just google "sql tutorial". Your question is related to basic SQL syntax and has nothing to do with iReport. Best of luck!
  5. phantastes
    Hi, I would recommend reading through one of the many SQL tutorials online. Just google "sql tutorial". In the case you mention you would need to join the two tables. Without knowing how the two table look like I cannot guarantee that this is the right solution, but if NID is the key it would look something like this: Code:SELECT ga.attachedfile, ga.nid, ga.filetype, gn.authorFROM GekkoATTACH gaINNER JOIN GekkoNOTE gn ON ga.nid = gn.nidWHERE ga.nid >= 970ORDER BY ga.nid ASC
  6. phantastes
    Hi, This should work: http://jtds.sourceforge.net/ Add the jar file to the classpath in iReport. Magnus
  7. phantastes
    Hi, As a way to create html reports with drill down functionality I've been looking into embedding a <script> into the html document. That script tag would call a javascript file. With the javascript I then want to add interactivity such as expanding and collapsing portions of the report. The problem I'm running into is that all <div> and <span> tags are set with position:absolute. Because of this I can only make a portion of the report visible/non-visible and not expanded/collapsed. Does anyone know how to solve this? Is there any way to create html reports where the position is not set to absolute? Thank you!
  8. phantastes
    Just a quick question, Are you sure that $V{uld_history_ULD_COUNT} is ever more than 1? If not on the report already then add $V{uld_history_ULD_COUNT} as a field, run the report and see what the value is. Let us know if this helps. Magnus
  9. phantastes
    Hi, To begin with I would make sure that all the text fields, etc are lined up (horizontally and vertically) and that there is no space between them. Let us know if this helps. Magnus
  10. phantastes
    Thank you Nathan! Would you be able to add the link to the JasperForge page where you found this? I don't seem to be able to locate it. Magnus
  11. phantastes
    I am looking for exactly the same kind of functionality. I need to embed an interactive html report in a webapp. If I have a list of, let's say, names: Roger David Bryan When I click one of these names then it should expand and show a list of data under it: Roger Client A B C Client A B C David Bryan giulio mention that "this can be performed in the same way as drilldown, pointing at the same report passing some parameters based on which you expand/collapse, using the print when expression, sections of your report.". I'm not sure exactly how this solution would work. Would each expanded list be a subreport that creates the html for that list, inside the html for the main report? I'll also take a look at the JasperServer sample you mention. But additional pointers would be very welcome! Magnus
  12. phantastes
    Thanks for the reply! It would not be an issue going with one of Jasper's Professional or Enterprise services/products. But I wanted to make sure that what we are trying to accomplish could be done with Jasper (any edtion). Using JSF could be one way to go but that introduces another level of complexity. How about the JasperServer functionality or is it JasperAnalysis I should be looking at? -Magnus
  13. phantastes
    Hi, What would be the best route to take in order to create interactive reports with drill down capabilites? As an example, lets say we have a list of names: Steve Roger Fabio This list will be part of a webpage. When clicking one of the names another list should show up with data related to the person clicked, like this: Steve Sold cars Type Price Date Skoda $5000 11/2/2010 Audi A3 $30000 11/8/2010 Roger Fabio What would be the best way to acheive this using JasperReports. Would I use JasperReports, iReport and JasperServer? Thank you!
  14. phantastes
    You could try this: http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=36763&topid=49764#49764
  15. phantastes
    The above $V{gpaAverageMeasure}.setScale(2, java.math.RoundingMode.HALF_UP) , were $V{gpaAverageMeasure} is a BigDecimal, works. I had pulled in floatValue() in the measure calculation which messed it up. So the short of it is, just use BigDecimal. Magnus
  16. phantastes
    Hi, I want a value of 3.665 to be rounded to 3.67. I have a field provided with a BigDecimal. The field is in a crosstab. I've set the field to show 2 decimal places. The problem I am having is that it doesn't seem to round correctly. In the fields textfield I have: $V{gpaAverageMeasure}.setScale(2, java.math.RoundingMode.HALF_UP) Instead of rounding up to 3.67 it rounds down to 3.66. Any help would be very welcome! Magnus Post Edited by phantastes at 03/23/2010 21:02 Post Edited by phantastes at 03/23/2010 22:46
  17. phantastes
    Hi, not sure if I understand exactly what you are trying to do but it sounds like you want a variable that only counts values of certain grouptypes? If that's the case then add a new variable. Set it to Calculation Type = Count. In variable expression field write something like this: $F{groupName}.equalsIgnoreCase("Business") || $F{groupName}.equalsIgnoreCase("Personal") ? $F{groupName} : null I hope that helps!
  18. phantastes
    Hi, you could try creating a category group. Then set up the summary variables for that group. Place those variables in the group footer. Now in the "Print When Expression" specify to only print the band when the two categories you want printed comes up ie new Boolean($F{groupName}.equalsIgnoreCase("Business") || $F{groupName}.equalsIgnoreCase("Personal")). And don't forget to sort the values by your group. Magnus
  19. phantastes
    Hi, Your question is very broad. What I would say is to start working on the report, and when you run in to any specific issues then come back here and post those questions. In that way we would know what question to answer.
  20. phantastes
    Maybe some more information is needed on your part. How far have you come? Which part of the doc file do you want as a report? The whole thing or just part of it?
  21. phantastes
    The solution is to make sure the subreport element, in the main report, has enough height.
  22. phantastes
    Hi, I have a bit of a head scratcher that I need some help with. I have a subreport in a band (I've tried page header as well as a group header with the same result). The problem I'm having is that because of this subreport then empty space is added at the bottom of the band causing a lot of unwanted air in the report. Any help would be very welcome! Magnus
  23. phantastes
    Great, glad it worked!
  24. phantastes
    Ok, I've done something similar. Have you tried checking "Remove line when blank" and "Blank when null" in Element Properties? That might be part of your solution. Let me know if that helps. And this might be a conversation to have in the iReport forum. Magnus
  25. phantastes
    Hi Chris, I am not sure that I understand how you want it to look. If you could insert another table showing this then maybe I could give you a hint. Magnus
×
×
  • Create New...

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

Products

Explore