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

AnnMary.Thomas

Members
  • Posts

    97
  • 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 AnnMary.Thomas

  1. I have a report where i am displaying an image as background. when the report gets generated the /g image is selectable. How can we remove that. I dont want the user to be able to select the image. ireport 4.0 jasper 4.6
  2. I have a query which returns 8 fields to generate the report. In this the first 7 fields are of various data types String, Big Decimal etc. But the last field returns Resultset object. (java.sql.Resultset). Within this cursor object I have 10 values which I am displaying in the report. Now the problem is I m calling next() method in one of the fields on this cursor object and displaying the data. Now the issue is as I am retreiving almost 200 records and each record has cursor object, Im running into problems like Opn Cursor Exceed error, as Im not closing these cursors. How can we close these cursor object? Or is ther an alternate approach for this? ireport 4.0 jasper 4.6
  3. What I meant is can I use JSS instead of ECLIPSE with the JSS Standalone version for a simple Java desktop application.
  4. So should I keep the language selected as SQL or PL/SQL for complex queries which has user defined function calls, unions ,joins etc
  5. Can I user Jaspersoft studio as an IDE for java projects? Or is it only meant for Jasper reports?
  6. I am using the latestJaspersoft 5.6.0 studio. I have reports with complex queries involving function calls joinswith + symbol etc. So when I am putting such queries in the query editor dialog it shows errors. The Language selected is SQL. I tried setting the language as PL/SQL also. But still it gives errors. Earlier I was working with ireport 4.0 and the queries used to work fine. Please give feedback
  7. You can use conditional styling. Add a new Style ,"rowStyle" to the report Add conditional style to the style(rowStyle) that you created now . Give the appropriate condition for which the background color should change in the condition expression property. (For ex: $F{STATUS}.equals( "Completed" ) ). Add condition for each color required, like Status is "InProgres", "pending" etc Now set the BackColor of this style to the appropriate color Now set the style "rowStyle" for the field for which the bg should change dynamically
  8. The height of the table should be the sum of the height of the row and header.Go to Table and see the height of the data field(row) and the height of the header. Add this and set as the height for the table. The height of the band in which you are going to place this Table should be the same or greater(if it contains other elements) than the Table height
  9. We have not migrated yet.. Actually we have many reports which is developed in 4.0. So are there any known issues which we should take care?
  10. I need to display he data in the following format 2001200220032004....sumdata11020101050data22020202080data330202030100sum60605060 My sql query is select year, data1, data2,data3 from table1. Year data1,data2,data3 are allseparate columns in the table. Cross tab does not help in this case
  11. Give the default value expression for the parameter as " java.util.Arrays.asList($P{REPORT_PARAMETERS_MAP}.get( "loc_codes" ))" and try
  12. Increase the text field width and try. Also check the text field property "Stretch with overflow" is unchecked. "Stretch with overflow" property ,if checked then will print the data which does not fit in the current line in the next line if the text field width is less.
  13. Anyone faced any issue while migrating from Jasper 4.0 to latest version of Jasper (5.0 and above)
×
×
  • Create New...