evalentine

for reports

I thought the Parameter 'JASPER_REPORT' contains the file name of the Report.

Could not load object from location : Inv_by_BTN_Sub1.jasper This is the first of two sub-reports called. I have the reports running on iReport. Created a report unit, copied the JXML, created the imput controls on the server. Now I am getting this error. Running 3.7 CE and iReport 3.7.6 Any suggestions????? Thanks.

I can not find this in the forum or the iReport Guide. Is it possible to pass values of fields in a report to the parameters in a sub-report? I thought I read this is the proper method to set the value of a parameter to be passed the the SQL of a sub-report. The main report prompts the user for some data. This value is loaded into a parameter and used in the SQL statement. A record is returned, printed, value from a field is inserted into another parameter and the sub-report is called to print the detail records. Any suggestion on best practice??? Thanks.

Did you find this driver as a compiled file? I can only find the source.

Is there anyone that is using this configuration; SuSE with jasperserver 3.7, using Postgersql as the data source, not as the jasperserver repository? I have tried several times and have not been able to get the Postgresql Driver to test sucessfully. Any suggestions? Thanks.

I have 3.5 working with this configuration but have not been able to get the Driver to connect with version 3.7. Centos current OS, JasperServer 3.7 with MySQL as repository and Postgresql as the data source. I have tried several drivers from the Postgresql site including the current one which is listed as working with Postgresql 8.3, java 1.6. java -version shows: java version "1.6.0.13" Java SE Runtime Envernment (build 1.6.0_13) When I test connection in the data source, the error is lava.lang.UnsupportedClass VersionError: Bad version number in .class file Is there something I am missing? Thanks for any suggestions.

Has anyone been able to connect a Postgresql DB as a data source with Jasperserver 3.7? I have not been able to get a Postgresql Driver to connect on a new install on Centos current OS. This configuration has been working fine with version 3.5 on other servers. The errors are all indicating there are version differences. Any suggestions will be welcome. Thanks.

It is working now! Thanks.

My ignorance is showing. I will need to get much more into Java than I thought I would. Your answer solved the problem. Much thanks.

I am still not getting this correct. The variables are defined as java.lang.Integer. If I use: ((($V{timeproj_h_2}.intValue() * (60)) + $V{timeproj_m_2}.intValue() ) / (60)) I get cannot cast int to integer. If I use: ((($V{timeproj_h_2} * (60)) + $V{timeproj_m_2}) / (60)) I get : * is undefined for the argument type Integer,int. I seem to be lost in Value Type Hell. Any suggestions to explain this or just get around it? Thanks.

In the Expression Editor : (($F{timeproj_h} * 60) + $F{timeproj_m}) / 60 Error says * is undefined for the argument type Integer,int. Any suggestions? Thanks.

I drink coffee but do not do Java! $F{rts_status}.equals( 5) ?"Closed":"Open" rts_status is integer, how do I convert it to a string for .equals? Thanks for your help.

I want to take the sums of two columns and add together. The first column is the hours, the second is the minutes. Something like; $V{tot_hours} = (($F{hours} * 60) + $F{minutes} ) / 60) This will equal the total number of hours as a decimal. Then I can multiple by the hourly rate. Any suggestions? Thanks.

I am trying to set the value of a variable based on the value of the database field. The field is an integer and the variable is string. I have tried : $F{rts_status}.equals( 5) ? ($V{status}.equals( 'Closed' ):$V{status}.equals( 'Open' )) but I am getting the error 'Invalid character constant'. Any suggestions? Thanks.