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


  • Posts

  • Joined

  • Last visited

GonzaLinares's Achievements


Apprentice (3/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Collaborator Rare

Recent Badges



  1. Hi, I´m using JasperStudio and JasperReport Server v6.4.2 I have a SOAP web service method which given a date and a work shift, returns time in seconds since that date. (An example of work_shift format: Mon - Fri { 7:30 am - 5:30 pm }) Currently i´m using a datasource which contains these 2 parameters as fields (date and workShift). I want to show in a report a field containing the result of calling this web service passing these 2 fields as parameters. Is there any way to call a web service SOAP method passing input parameters from Jasper? Any guide would be appreciated. Thanks, GL.
  2. Can use one or many TextFields in order to show parameters in the headers. Not sure what do you mean about values and codes. Is value a field in your dataset or how do you get it? In case you have a particular value for each code, then you can hard-code it. Ex: $P{param1}.equals("VA") ? "VAvalue" : $P{param1}.equals("CT") ? "CTvalue" : "No value" For the last point you mention, can put these TextFields in a frame with a print when expression. Print the Frame when there is at least 1 TextField that is not null. Ex. (field1 != null || field2!=null ||.... ) ? true : false Then can use another Textfield with expression "All records" and you opposite print expression than Frame. Ex: (field1 != null || field2!=null ||.... ) ? false : true Let me know if any of this is helpful. If not, give me some more information so we can work it out. Regards, GL.
  3. Configure frame print when expression. Just add a boolean expression checking if list is empty Example: Print When Expression: ( myList.length > 0 ) ? true : false Regards, GL
  4. Did you try checking that subreport size does fit in report? Had this problem many times and could manage to make it work changing items size. If this does not work, try making a simpler subreport till it work. Then add complexity till it stop working. This way you can check why it´s not working. Regards, GL
  5. You can make it work by using an order by expression in your query. In this case both pies have different categories, then you can order data by those categories you have in common. Example: order by case when field.name = 'POSTCARD' then 1 when field.name = 'BOOK' then 2 else 3 end I know this is workaround and not a solution, but may be helpful. Regards, GL
  6. Hi, I´m having some problems with some Standard and Custom Reports. Can execute without any error all reports that do not have multi-select query inputs. Example: Query in report: WHERE cr.type_symbol IN $P!{TypesList} Input control query: SELECT DISTINCT cr.type_symbol as type from cr Then add as resource the input control. Have 2 parameters at report: Name: Types Class: Collection Nested: String Name: TypesList Class: String Expression: "('"+org.apache.commons.lang.StringUtils.join($P{Types}.toArray(),"', '") + "')" When i execute the report, input control works fine (shows what it´s suppossed to), then when i click "Acept" i get this error: (Just showing "Caused By" parts) com.jaspersoft.jasperserver.api.JSException: Error filling report Arguments:... ..... Caused by: net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query: SELECT cr.ref_num as REF_NUM, cr.open_date as OPEN_DATE, cr.close_date as CLOSE_DATE, cr.status_symbol as STATUS, cr.summary as SUMMARY, cr.impact as IMPACT, cr.priority as PRIORITY, cr.type_symbol as TYPE, request_area_description as AREA_DESC FROM cr WHERE cr.type_symbol in ('Incident', 'Problem', 'Request') Caused by: java.sql.SQLException: [DataDirect][OpenAccess SDK JDBC Driver][OpenAccess SDK SQL Engine]syntax error, unexpected $end at ( ... N'Incident at com.ddtek.openaccess.ssp.Diagnostic.toSQLException(Unknown Source) ...... Things that i tryed: - Instead of using $P!{TypesList}, used $X{IN,cr.type_symbol,TypesList}. Got similar error. Instead of "WHERE cr.type_symbol in ('Incident', 'Problem', 'Request')" i get an error like this: "WHERE cr.type_symbol in (?,?,?)" - Made an input control of class string, executed report and wrote down: ('Incident','Request') and it worked. Bad thing about this, is that i want to use multi-select query as input control, this way user don´t have to write anything. - Tryed same report using a different datasource (this datasource point to a "test" DB while the one that fails point to "production") and it worked too. From this what i get is, maybe a JDBC controller problem? What do you think? What am i doing wrong? Any idea will apreciate. Thanks, GL
  7. To @joseng62: Prerequisite for installation is 8Gb. Have 16Gb, so i don´t think it´s a memory problem. About permission level issue, i´m doing the installation logged as an administrator. Last option you mentioned about installer being corrupted i didn´t get it into consideration before, gonna download the installer again and try my luck. Edit: Made it work!. Downloaded installer again and turned off anti-virus. Not sure if it was having trouble with anti-virus or if it worked because old installer was corrupted, but made those 2 changes and it worked. Thanks for the answers!
  8. What about using a TextField checking if field is null: $F{NAME}==null ? "???" : $F{NAME}
  9. What error do you get? If you get error with highchartsxsd not loading I had same problem. Make it work following this: .https://community.jaspersoft.com/questions/1087226/highchartsxsd-not-loading Basically, had to download Commercial version of JasperStudio. Regards, GL
  10. As title says, i´m having this issue when trying to install JasperReport Server v6.4.2 Followed standard installation guide using bundled Tomcat and postgresql database. Did not configure anything manually. Installation goes well till 6%, while it says: "copying postgresql database". Then it close without giving any error. Looking up at log files generated, i got this: class com.ca.bicoe.cajasperserver.install.guiinstaller.customcode.ShowInstallProgress.install() Unexpected Fatal Error: java.lang.OutOfMemoryError: Java heap space Done this installation succesfully 4 times on different servers before, but never got this problem. Any idea what could be wrong?
  11. I had same problem using JasperStudio. I resolved it by generating a new .jasper file for all the subreport that i wanted to update, and then re-uploaded the full report.
  12. In order to pass a field from Main report to a subreport, first of all you have to create a parameter in your subreport. Ex: Name: SUB_USERNAME , Type: String Then go to Main report and click on the subreport element. In the right side click in "edit parameter button". Map values from main report to subreport parameter. I´m not sure if you are trying to pass just one value of USERNAME or ALL values. If you want to pass to your subreport all values with just 1 parameter, then what you can make is a new parameter of type collection in the main report. With a variable add all those values and then pass that collection to your subreport. Probably is easier to get those values from the subreport query, and pass as parameter a value to filter the where clause. Regards, GL
  13. Found out this way of creating a report formed by other reports (Report Book). Managed to make it work, but not very well. When i run the master main report, it execute in order the reports i put in content. The problem is, it generate like a loop and keep generating the content report again and again. What could be the reason of this behaviour ? In case i was not clear. I have a master report (Report book). I put 3 report into it. When i execute it, it generate the 3 tab (one for each report) that it should generate,but then it enters a loop and keep generating those 3 tab. All report are using same JDBC connection, and all of them use same query.
  14. Finally find a solution.Did something similar to what you said. Created a input control asking for the date. Then used 2nd parameter to convert value in the input control. I guess all parameters have same evaluation time, but input controls have an earlier evaluation time.Hence, 2nd parameter does take value from 1st parameter (At least at Jaspersoft Server, since it worked with 2 parameters in Jaspersoft Studio)
  • Create New...