dprogrammer

Jasper Studio 6.3 I am very frustrated to not able to find a way to dock the Repository Explorer back. Does anyone know where that control is located which docks all the windows back to default or at least docks Repository Explorer?

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)?

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?

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?

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"

{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"

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?

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.

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

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.

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

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.

USA null ( should show sum of 500 + 300 but shows null) CA 500 CO 300 Canada null ON 100 Alberta 200

USA null ( should show sum of 500 + 300 but shows null) CA 500 CO 300 Canada null ON 100 Alberta 200

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

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?

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.

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?

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

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

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.

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?

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

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.

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