Ba Ma

Hello everyone, I AM using the Software TIBCO JAPSERSOFT 6.1.1. I am trying to add a new Font to the Software. The report is working fine, but when I start to export (PDF) the report the Wingdings symbols don't show up in the report. http://community.jaspersoft.com/wiki/ireport-fonts I found this Link for iReport to add a new Font to the Software, but i can't find it in my software. Is there any fast way how I can add the new font "Wingdings" to my Software, so that if i try to export it as pdf it works? Would appreciate a fast answer, i am really in a hurry. Thank you Cheers

Hi everyone, I am trying to create a condition formatting style, but i receive an error Message for the condition: The condition looks like this: ($F{lastmonth2} ) < ($F{lastmonth} * 0.95) And the error is: The operator * is undefined for the argument type(s) Bigdecimal, double In the Condition im trying to compare two values whether there are bigger or not.. Anyone knows how I can solve this problem?

Hi, (http://community.jaspersoft.com/wiki/how-apply-conditional-formatting-your-text-fields) --> Link for Conditional Formatting I have a question about conditional Formatting. Let's say I have a report with 20 subreports. In one of the Subreports I have a table which contains the number of calls for every month in the last 2 years. Example: Calls | Date 100 01-16 200 02-16 300 03-16 Now as we can see in the exmaple the trend for the number of calls every month is rising. I want now to apply a Condition. Let's say we have the 01.04.2016. I want the Condotion to Compare the last 2 months on whether the last month has more calls then the month before. In the example we got more calls in 03-16 than in 02-16, that's why the condition should be true. If the Condition is true I want the color to be green and if it's not true red. Now i have another Subreport in my Report where I want to display the color. I want it to be displayed in the summary Subreport, which is the 2nd Subreport in my Main report and the Calls are the 5th Subreport. So if the Condition (as in the example) is true, I want it to display in the Summary Report the Word "Number of Calls is rising" (in green) , if there would be less calls I would want it to display "Number of Calls is falling" (red) . I wonder if I can achieve this request with Jaspersoft? Anyone had the same Problem? Thank you for your help =).

Solved--Just changed the SQL. The SQL is supposed to start with a SELECT and not with Parantheses.

Hi everyone... 2016-03-18 14:16:02,566 ERROR AsyncJasperPrintAccessor,pool-4-thread-2:315 - Error during report executioncom.jaspersoft.jasperserver.api.JSSecurityException: An error has occurred. Please contact your system administrator. (6632)at com.jaspersoft.jasperserver.api.security.validators.Validator.validateSQL(Validator.java:500)at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:167)at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1129)at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696)at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:434)at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519)at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:393)at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:728)at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:58)at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:216)at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)at java.lang.Thread.run(Thread.java:745)2016-03-18 14:16:02,575 ERROR errorPage_jsp,http-apr-8080-exec-2:293 - JSException: Anyone knows how to handle this problem`?

The problem is the () at the beginning and ending of both querys... That's why the Server doesn't open the file... Is there any solution?

Hi and Thank you for your response. I already checked it, every file is uploaded correctly. The report is working correctly. I guess the problem is in the SQL: ..SELECT Count(STATUS), STATUS, ROUND(Count(STATUS) * 100 / (SELECT Count(*) FROM call_view WHERE ( create_month = Month(Now() - INTERVAL 1 month) ) AND ( create_year = Year( Now() - INTERVAL 1 month) ) AND customer_company_name = ? ), 1) AS Percentage FROM call_view WHERE ( create_month = Month(Now() - INTERVAL 1 month) ) AND ( create_year = Year(Now() - INTERVAL 1 month) ) AND customer_company_name = ?GROUP BY STATUSORDER BY COUNT(CALL_ID) DESClimit 6)UNION(Select Sum(category_count), 'Other', sum(percentage) from (SELECT Count(STATUS) as category_count, COUNT(CALL_ID), STATUS, ROUND(Count(STATUS) * 100 / (SELECT Count(*) FROM call_view WHERE ( create_month = Month(Now() - INTERVAL 1 month) ) AND ( create_year = Year( Now() - INTERVAL 1 month) ) AND customer_company_name = ? ), 1) AS PercentageFROM call_view WHERE ( create_month = Month(Now() - INTERVAL 1 month) ) AND ( create_year = Year(Now() - INTERVAL 1 month) ) AND customer_company_name = ?GROUP BY STATUSORDER BY COUNT(CALL_ID) DESClimit 6, 1525125215) as original_query)..[/code]Because after I started to Insert the 2nd Part of the SQL(The part after the union) the Server started to display error 6632...

Hi Thank you for your respone. Could you tell me how I can achieve thiS? Cheers

Hi everyone, I got a Report with 20 Subreports.. If i preview the report in the tool Jaspersoft everything works fine... When I upload it on the Server and try to open it the Error "6632 - Contact an admin" occurs. This is the Information from C:Jaspersoftjasperreports-server-cp-5.5.0apache-tomcatwebappsjasperserverWEB-INFlogs Anyone knows how to handle this Problem? Would appriecate anyhelp,. Cheers

Hi everyone, I am Working on a dynamic Report which will contain different Content depending on the paramter. The Parameter filters for a company name.. I now created a Line Chart which displays the date on the x axis value (month - year) and the number of events on the y axis value... If there is no value for a specific Company the whole page gets the error : "Document is Empty" If there is data for the Chart everything works fine. I wonder if there is a way to display the chart too, with no data filled when the query doesn't retrieve any data, instead of the whole report becoming empty... Would appreciate any help... Cheers

Thank you very much for your response. I don't know how I can do this, Could you explain it to me please? Cheers

Hi everyone, I have a Report which contains 20 Subreports. Every Subreport contains only a title band, where all the Information is displayed, because of the complexity... Now I am trying to achieve in the Master Report which contains all 20 Subreports page numbers...However I don't know how to achieve it... I know about the Function Page Number, but if I try to use it in every subreport it always displays 1 on every page when i run the report.. Anyone knows how to handle this? Cheers

Hey everyone, I made a table where the column header should be red and the text in it white. I already changed the text colour to white, but I dunno how to change the colour of the cell to red, anyone knows how to achieve this? Cheers

Solved-- Connection was Wrong..

Hi everyone, I created a report with 25 sites. The report needs 300 seconds filling Time. If I try to publish it on the Jaspersoft Server, it takes a very long time. The window "Publish to JaspersoftReports Server" opens, but it's loading since 30 minutes? Is it normal that it takes that long to publish the report on the Server? Cheers