[how to find out jasper reports server instance in a report]

Hi Hozawa, Thanks for your reply. You meant  I pass the full server URL as a static parameter to each of the report having default value as the full URL? Even if I do that how will report know on which server it's being hosted on? 

Also, do you happen to know if there is a way to view jasperserver.log file from the JasperReports Server UI (like logging in as jasperadmin/jasperadmin)?

 

[how to find out jasper reports server instance in a report]

Is it possible to check which jasper reports server the report being run on? Like if there are multiple jasper reports servers in an organization, would it be possible to check the hosted server name from a report?

[JasperReports Server log files and reading from a parameter/properties file on server]

I've couple questions regarding jasper reports server.

1 -I have community version of Jasper Reports Server and I have explored almost all areas but I can't find a way to view server log files from the front-end UI. Is there any option to view log files from the Jasper Reports Server UI?

2- I've multiple instances of the server on different ports. For example port 8080, 8081, 8082. I've three different texts that I would like to be shown on my reports based upon the server. For example if port = 8080 then show text1, if port=8081 show text2, and if port=8082 then show text3. Is there any place/property where I can specify either a port number or server name or something unique to that server and where jrxmls can read from and then display the texts conditionally?

 

[iReport ver 3.6.2 if then else question]

AND condition:

({field}==1 && {field2}==2)? "do something2":

({field}==1 && {field2}==3)? "do something3":

({field}==1 && {field2}==4)? "do something3":"do something at the very end"

 

 

[iReport ver 3.6.2 if then else question]

{field} ==1? $P{SUBREPORT_DIR} +"Load_File_Two.jasper" : ({field}==2?"do something here: "else do something else here)

or 

{field}==1?"do something1":

{field}==2?"do something2":

{field}==3?"do something3":

{field}==4?"do something4":

{field}==5?"do something5":​ "last else do something here in the end"

 

 

 

[How can we make the PDF document printing (already in half letter format) be able to accommodate two half pages on a single letter?]

What is halfletter format? Are you referring to news paper style (vertical) where you have columns on left and right? Or horizontally dividing the letter size page into two sections?

[how to convert decimal to string in a calculated field]

something like this: 

create a variable that checks: {field}.contains("1)? 1 : 0

create a running total and use that variable in it. then sum on the running total and it should give you total of 1's. 

 

 

[Is there a default row limit when running reports?]

Click Window--> Preferences--> Jaspersoft Studio--> Report Execution: Make sure there is no limit under check box 'Limit Number of Records'.

[Unable to open ireport gui interface]

If you are trying to install Jasper Studio. All you need to do is download the executable from jaspersoft.com and just do the install. It's not very complicated. Make sure you have at least Java 6 or higher SDK on your machine for it to work.

 

 

[Summing a variable in Group Header band level shows as null. Works in Group Footer band]

Was able to fix it. Let me know if anyone would like to know what needs to be done. 

[Summing a variable in Group Header band level shows as null. Works in Group Footer band]

Applogize for the formating. I don't know what's happening with the forum site. It does not show a previw of the post and messes up the formating of the sample report that I put there. Basically USA is a GROUP and I need to sum totals for CA and CO and show it in a varialbe in the GROUP HEADER but it's coming up null. I am palying around with 'Evaluation Time' but still no luck. 

[Summing a variable in Group Header band level shows as null. Works in Group Footer band]

USA                                                           null ( should show sum of 500 + 300 but shows null)

     CA                                                        500

     CO                                                       300

Canada                                                  null 

    ON                                                     100

    Alberta                                              200     

[Summing a variable in Group Header band level shows as null. Works in Group Footer band]

 

USA null ( should show sum of 500 + 300 but shows null)

 

CA 500

 

CO 300

 

Canada null

 

ON 100

 

Alberta 200

[sub-report not working when sub report parameter is linked with a main report's field]

Sorry, here is more details: 

Main report sample data: This report pulls all ORGIDS for a given date.

ORGID: 1001

EAST REGION    

                 2016/01/01         $5000

                2016/06/15         $4000

WEST REGION

                2016/05/31         $3000

                2016/06/12         $2000

ORGID: 1002

EAST REGION    

                2016/02/01         $1000

                2016/05/15         $1500

WEST REGION

                2016/05/01         $6000

                2016/06/13         $4000

 

This is how the Grand total report should like for ORGIDs 1001 and 1002.

ORGID                                  Total Sales

1001                                       $14000

1002                                       $12500

 

But it does not seem to get ORGID value from main report correctly. It only works when I hardcode main report for either ORGID=1001 or 1002 and shows grand totals for only one ORGID. But when I run the main report for all ORGIDs the grand total report just comes up blank.

ORGID                                  Total Sales

null                                         null

 

 

[sub-report not working when sub report parameter is linked with a main report's field]

Dear Folks,

I've spend almost whole day today in trying to figure out what I am doing wrong. I would really appreciate if someone could point out where I am doing wrong. 

I've a main report and two sub reports. 

Main report: Group1 on ORGID field. That ORGID field is then passed as a parameter to $P{subORGID} parameter for both subreports. First sub-report is a details report, it's in Group1 footer band, and prints data for each ORGID on a separate page. That part is working fine. 

The second sub-report is with grand totals for each ORGID. Hence I've placed it in Summary section of the main report. I've also linked that sub-report with main report's field $F{ORGID}  = $P{subORGID}. For some reason the subreport is not able to get all ORGIDs in the parameter and is not returning any rows. If I only run the main report for one ORGID, say specifying in WHERE claues ORG.ORGID='1001', the grand total sub-report works fine and brings back data for that ORGID. But when I remove the WHERE clause and want to see all ORGIDs, the grand total sub-report just comes blank. 

Should I change the type of $P{subORGID} to a collection etc.? Or I am missing something? 

[ClassCastException: java.lang.String cannot be cast to java.lang.Boolean]

Very frustrated with Jaspersoft Studo 6.2.0 (loved older versions of iReport).

I am not sure why the developers of JasperStudio suite keep making it difficult to use. Older versions of iReport (3x) had a nice feature to double click on error message in the console and it would take you to the filed/object that is causing the error. With their greates JSS 6.2.0, that feature is no where to find and hence for past two hours I am not able to find where the heck this error is occuring. Could anyone throw any ideas? I've also checked the log (Windows-->Show View...) menu but it's not telling me anything about this error.

Error message: java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Boolean.

I know what the error means but I am not able to find where is it occuring. I've checked all fields, variables, parameters.

[InputControl - Min, Max values. Have anyone ever used?]

Hi hozawa, Thanks! Yes, the error is occuring in JasperServer. Anytime I set MIN and MAX values and click 'Submit' it just blows out. I am using 5.6.0. Is there any bug fix/patch for that version if you know?

[failure in loading native library db2jcctv....already loaded in another classloader]

Forgot to mention. This is occuring in JasperStudio 6x.

[failure in loading native library db2jcctv....already loaded in another classloader]

Hi, I have added required JAR files to the class path but I am getting this error when I am trying to retrieve fields from DB2. There are some other pass which may also be using the same library and I am not sure where should I put it so it loads for all apps.

Caused by: com.ibm.db2.jcc.am.SqlException:Failure in loading native library db2jcct2, java.lang.UnsatisfiedLinkError: Native Library C:Program FilesIBMSQLLIBBINdb2jcct2.dll already loaded in another classloader: ERRORCODE=-4472, SQLSTATE=null

 

[Source variable ... not found for return value ...]

I had the same issue in Jasper Studio 6 but I got it resolved. Once you add the sub-report variable (source) in your sub-report, make sure to compile the file or better yet compile and then close the report and exit JS IDE. Do the same thing with main report after you have joined the target variable to that source variable. After you re-launch JS IDE the error should go away.

[InputControl - Min, Max values. Have anyone ever used?]

Hi, I am not able to save changes when I enter Minimum Value and Maximum Value for a numeric parameter. The error says it's not able to update it. Has anyone have any ideas?

[jasper server error while trying to set Minimum and Maximum Value for a numeric parameter]

Hi, I am trying to configure an InputControl for my report that has been developed using latest JasperStudio 6.2.0. I have a numeric parameter which allows values like 1, 2,3 etc. I am trying to set a minimum value and maximum value limits and when I click 'Submit', the JasperServer is throwing this error: (copying first few lines of the error message):

 

 

Error Message could not update: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoDataType#4570]; SQL [update JIDataType set type=?, maxLength=?, decimals=?, regularExpr=?, minValue=?, max_value=?, strictMin=?, strictMax=? where id=?]; nested exception is org.hibernate.exception.DataException: could not update: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoDataType#4570] Error Trace com.jaspersoft.jasperserver.api.JSExceptionWrapper: org.springframework.dao.DataIntegrityViolationException: could not update: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoDataType#4570]; SQL [update JIDataType set type=?, maxLength=?, decimals=?, regularExpr=?, minValue=?, max_value=?, strictMin=?, strictMax=? where id=?]; nested exception is org.hibernate.exception.DataException: could not update: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoDataType#4570] at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:648) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411) at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374) at org.springframework.orm.hibernate3.HibernateTemplate.flush(HibernateTemplate.java:881) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeWriteCallback(HibernateDaoImpl.java:78) at

[Where is iReport 3.1.1 properties popup]

Hi Aimee, Thank you very much for this tip I found the properties box that I was looking for. I was suprised that a formatting properties box would have to be enabled from 'Windows' menu. I was expecting it to be under 'View' --> 'Tool Bars' menu.

[First grouped row is omitted]

Play around with 'Evaluation Time' property. It might be causing it. Are your fields in variables? Because sometimes variables have this issue.

[Where is iReport 3.1.1 properties popup]

Dear Folks, I know iReport 3.1.1 does not have this popup anymore which is very disappointing as it was a very handy way of setting propoerties of fields etc very quickly. However, I am also not able to find properties like 'Same Height', 'Same Width', 'Same Size', 'Align Bottom', Align Top'. Anyone has any ideas please?

Thanks in advance