Ba Ma

March 22, 2016

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

March 21, 2016

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?

March 18, 2016

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 =).

March 18, 2016

Solved--Just changed the SQL.

The SQL is supposed to start with a SELECT and not with Parantheses.

March 18, 2016

Hi everyone...

2016-03-18 14:16:02,566 ERROR AsyncJasperPrintAccessor,pool-4-thread-2:315 - Error during report execution

com.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`?

March 18, 2016

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?

March 18, 2016

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...

March 18, 2016

Hi Thank you for your respone.

Could you tell me how I can achieve thiS?

Cheers

March 17, 2016

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

March 17, 2016

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

March 16, 2016

Thank you very much for your response.

I don't know how I can do this, Could you explain it to me please?

Cheers

March 15, 2016

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

March 14, 2016

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

March 10, 2016

Solved-- Connection was Wrong..

March 10, 2016

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

March 7, 2016

hi and thanks again.

yes PRIORITY is a numerical type.

I followed your instructions but it still doesn't work.

NAME: VARIABLE_1

VALUE CLASS NAME: java.lang.Integer

CCalculation: No calc function

Expression :($F{PRIORITY} == null ? 0 : $F{PRIORITY})

and so on....

I then picked the variable as the series Experssion editor in the Line chart, but it is still displaying the same result?

Did i make an mistake?

Cheers

March 7, 2016

Hi Javier,

thank you for your answer, i really appreciate the help.

Could you explan to me how it's working? I never did something like that before.

--- EDIT:

I tried to change the condition in the series Expression editor with :

($F{PRIORITY} == null ? "0" : $F{PRIORITY})

This condition should achieve, that every null value will be a "0" and the line will go down to the x axis.

But it isn't working.

March 7, 2016

Hi everyone,

I created a Line chart which displays 3 diffrent series. But there is a problem:

The line stops when there is no x axis value for a specific date, but if in a futher date there is a x axis value, the dot will be displayed, but the line doesn't connect the dots.

I wonder if it is possible to edit the chart the line goes through the whole graph, without stopping when there is no x axis value for a specific date.

Anyone knows how to solve this?

Would appreciate any help.

Cheers

Marco

February 26, 2016

Hi Everyone,

I am working on a report which should contain the data from the last month. I tried a SQL Statement in TOAD FOR MY SQL which retrieved the data, I really needed.

Afterwards i copied the statement in the Jaspersoft Tool and it results in an error:

The error:

Multiple markers at this line:

-no viable alternative at input 'month'

- missing EOF at '-

The statement:

..select * from call_view where (create_month = month(NOW() - INTERVAL 1 MONTH) and (create_year = year(NOW() - INTERVAL 1 MONTH)));..[/code]

Would be awesome if anybody could help me out.

Thank you.

February 26, 2016

Hello everyone,

I am working on a report with more than 30 sites and more than 10 subreports in it. Every subreport has got the same Parameter. I always have to add a new Parameter for every new Report i create.

The Parameter has the task to filter for a Name in the Database.

I Wanted to ask if Jaspersoft has a feature, which helps me to add one Parameter for every Report I have. The result should be that if i change the Value of the Parameter, the report should then create a new report with the content for the diffrent filtered data.

Cheers

Marco

February 25, 2016

hi guys,

sorry to disturb you guys, but i got a problem with inserting a subreport into the report...

i checked all properties:

Main-report:

width x height = 595 x 842

band property : 802 px

report page: bottom margin = 20, left margin = 20, page height = 842, page oriental = portrait , page width = 595, right margin = 20, top margin = 20,

sub report:

width x height = 595 x 842

band properties : 802 px

report page: bottom margin = 20, left margin = 20, page height = 842, page oriental = portrait , page width = 595, right margin = 20, top margin = 20,

error:

net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.design.JRValidationException: Band height validation for subreport "NOCWeekDay" failed in the current page context (height = 842, top margin = 40, bottom margin = 40) :

1. The title section, the page and column headers and footers and the margins do not fit the page height.

at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:511)

at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$20(ReportControler.java:486)

at com.jaspersoft.studio.editor.preview.view.control.ReportControler$5.run(ReportControler.java:367)

at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

Caused by: net.sf.jasperreports.engine.design.JRValidationException: Band height validation for subreport "NOCWeekDay" failed in the current page context (height = 842, top margin = 40, bottom margin = 40) :

1. The title section, the page and column headers and footers and the margins do not fit the page height.

at net.sf.jasperreports.engine.fill.JRFillSubreport.verifyBandHeights(JRFillSubreport.java:1094)

at net.sf.jasperreports.engine.fill.JRFillSubreport.validateReport(JRFillSubreport.java:1053)

at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:476)

at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:351)

at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:281)

at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:504)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillTitle(JRVerticalFiller.java:318)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:254)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:122)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:555)

at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:119)

at java.lang.Thread.run(Unknown Source)

Anyone can help me out please, i don't know why i get this error and why I can insert the subreport into the report..

cheers

February 24, 2016

hi guys,

sorry to disturb you again, but it's still not working.