[PDF Localization for Asian Language ( Japanese, Chinese, Korean etc ) not Working]

The following post https://community.jaspersoft.com/wiki/displaying-east-asian-characters-report-pdf-output describes the necessary steps for using Asian characters in PDF. The web page refers to a font, I have however no idea of the license.... for that particular font.

[how to covert the total sum into word]

To have a custom (java) function it is possible to use scriplets. A scriplet allows you to code a function in Java and call this function in Jaspersoft. More information on this topic can be found in: http://jasperreports.sourceforge.net/sample.reference/scriptlet/

 

[Complex layout properties file]

Is it possible using styled or other markup to create a property including complex layout. This layout would entail:

• Paragraphs 
• Font layout (underline/bold)
• bullet lists

Can someone provide me with a reference on how to achieve this?

Thanks!

[Custom fonts WOFF]

Is it possible to use woff fonts in the generation of pdf's? If so how would I be able to do this?

Thanks!

[Different results]

Hi,

In a report I'm using a SQL query to retrieve the necessary data. Using the identical query in both tools I'm getting different results in SQL developer and Jaspersoft. Can someone point me in a possible direction of what is going on? I have to mention that the query performed is large (execution time 40 seconds +); maybe of relevance.

So my main question is what can be causing the differences in results?

Kind Regards,

Maarten

ps. I checked the different db settings.... they are all the same.

 

 

[SQL table is having a column as json and I want to extract a particular value from that and add it in a new column in table, is there any way ??]

Is there a reason why you do not use postgresql to extract the value in a new column and use it in jaspersoft?

[JasperStudio dosen't print table with fields in preview]

I believe this table is part of a subreport? Where in the subreport (in which band) did you create this table?

[Avoid wrap around textfield]

How can I avoid an unneeded wrap around (and as such generating a blank line) in a text field? I’m retrieving strings of different length in this textfield and for some reason it occurs that the complete string is printed on one line but still there is a wrap around.The properties for paragraph are default. There are no borders of padding.

Thanks!

[Excel export]

Setting this property seems to work but also seems to lead to merged cells when the text becomes longer. Is there a way to prevent this merging of cells? 

Thanks!

[Excel export]

In a report (Excel export)  I'm creating I have some long texts in a particular field. These texts can be so long that when using the stretch with overflow give a 'weird' result (very high columns). Is it possible to use a property for keeping the complete text but that it fallbacks to Excel default behaviour (so the text is in the cell but only partialy visible and you need to stretch the column to see the complete contents of the cell).

Hope this is a bit clear.

Thanks.

[Convert String yyyy-mm-dd to month name]

Hi,

You can do this using a date format. Possible date formats can be found here (for example): https://community.jaspersoft.com/wiki/date-and-time-patterns A pattern can be added to a textfield in the properties of a textield (in the properties find pattern).

Another reference on the use of date patterns can be found here: http://jasperguide.blogspot.com/2014/03/date-and-time-pattern.html

Hope this helps.

Kind regards,

Maarten

 

[How to achieve FOR statement execution using Jaspersoft studio]

Hi,

If I understand correclty you want to create a group on status and then use this to make the totals per status value. This would allow you to get the desired result. More information on the use of groups: https://community.jaspersoft.com/wiki/groups .

Hope this helps.

Kind regards,

Maarten

[How to re-Use same document footer in set of templates]

Hi,

If I understand your question correctly you have a large number of documents that all use the same document footer. A solution to your issue is the use of subreports. More information on the use of subreports can be found here:

• https://community.jaspersoft.com/wiki/subreports-jaspersoft-studio (Jaspersoft studio)
• https://community.jaspersoft.com/wiki/subreports (IReport designer)

Hope this helps. 

Kind regards,

Maarten

 

[Passing values main and sub-reports]

Hi,

I’m having issues with the following use case: I have a report which incorporates several subreports. In the main report a counter is being initiated that needs to continue in the subreports; passing along values between the main and the different subreports. For example:

In the main report I have a counter with value 2 this value is being passed to the first subreport. There the counting starts from 2 and 5 gets added. So the new value is 7. This value is passed to the main report using a return value. The next subreport start immediately after the first. The value 7 is being passed to this second subreport via a parameter. This counts on with a new total of 12. This new total is being passed to the main report and used further in the main report.

In this example it is important to take into account that the value is not printed between the different subreports.

Is this possible? Can someone explain to me in more detail how to achieve this?

Kind regards,

Maarten

[Subtotal group end of page]

Can someone help me with following jasper reports question? Having grouped data I’m trying to add a subtotal of the data in the group when the data continues on a next page and a total at the end of the group. So for example:

123--- as last line of the page the subtotal for all values in the group so far:6--- start new page34--- end of group. Total for all the values in the group:13... start new group…[/code]

Thanks!

[Could not instantiate report compiler : net.sf.jasperreports.compilers.JRGroovyCompiler]

Issue has been resolved by completely removing and reinstalling jaspersoft.

[Subtotal group]

After a lot of searching, trail and error I came to the following solution. 

1. Place the fields in the relevant group header. Set the reprint
    header on each page to true.
2. Create a variable with 
    - calculation sum  
    - expression: field you which to sum 
    - initial value expression java.math.BigDecimal.ZERO 
    - Increment type none
    - Increment factory class: (leave empty)
    - Reset type relevant group
4. Add this variable to a text field with evaluation time now.

Voila. Once again this solution seems to work but  there was/is a lot of trail and error in finding a solution.
 

[Subtotal group]

Hi,

Can someone help me realizing the following.

My data is grouped. Now when the detail lines for a group goes beyond a page the total of all the lines belonging to that group must be shown on top of the following rows on the next page. So more schematically I’m trying to realize the following:

--------------
Page 1
Group A
Detail line 1    amount
Detail line 2    amount
Detail line 3    amount
Detail line 4    amount
Total for group A
Group B
Detail line 1    amount
Detail line 2    amount
--------------
Page 2
Total amount for group B on the previous page (line 1 and 2 in group B)
Detail line 3    amount
Detail line 4    amount
Total for group B
…

Thanks!

[Could not instantiate report compiler : net.sf.jasperreports.compilers.JRGroovyCompiler]

Hey,

When compiling a report using Jaspersoft Studio 6.2.0.final I get following error: 

net.sf.jasperreports.engine.JRException: Could not instantiate report compiler : net.sf.jasperreports.compilers.JRGroovyCompiler
    at net.sf.jasperreports.eclipse.builder.JasperReportCompiler.compileReport(JasperReportCompiler.java:173)
    at net.sf.jasperreports.eclipse.builder.JasperReportCompiler.compileReport(JasperReportCompiler.java:88)
    at net.sf.jasperreports.eclipse.builder.JasperReportsBuilder.compileJRXML(JasperReportsBuilder.java:218)
    at com.jaspersoft.studio.editor.action.CompileAction.actionCompile(CompileAction.java:176)
    at com.jaspersoft.studio.editor.action.CompileAction$3.run(CompileAction.java:132)
    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Caused by: java.lang.ClassNotFoundException: net.sf.jasperreports.compilers.JRGroovyCompiler cannot be found by org.eclipse.core.resources_3.10.1.v20150725-1910
    at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:439)
    at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:352)
    at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:344)
    at org.eclipse.osgi.internal.loader.ModuleClassLoader.loadClass(ModuleClassLoader.java:160)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at net.sf.jasperreports.eclipse.builder.JasperReportCompiler.compileReport(JasperReportCompiler.java:158)
    ... 5 more

The preview works correct, I’m able to compile the report using IReport. Can someone advice me on how to solve this? Changing the java version.. (through the ini file) did not solve the issue.

Thanks!
 

[Hai All, I need help in this generating jasper report in I Report 5.5.0. Please check and Update]

to be clear do you want the necessary steps for building the report? Kan you give a bit more information on your question?

[I will create new adapter with oracle DB but i get this error, how to fix this error?]

This seems to be a authentication problem with the Oracle database you try to connect to. Can you verify you provided the correct username/password? Did you executed the test when creating the data adapter? What was the result?

General information on this error can be found on http://www.dba-oracle.com/t_ora_01017.htm, general information on creating database data adapters can be found here: https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v60/creating-and-using-database-jdbc-connections

Hope this helps.

[Running total over pages]

I have seen different references (questions/answers) on how to get a running total but had no success in implementing it thus far. What I want to achieve is a cumulative subtotal on the bottom of each page. On the first page the total for that page of a column (let’s call this column A ) would be displayed. On the second page the total of page one and page two for column A is displayed and so on until the last page on which the overall total is shown.

Can someone provide me with a way to achieve this?

Thanks.

[Conditional Formatting in CrossTab]

It is possible to use conditional styles on a crosstab. By doing following:

1. Create your crosstab
   
2. Select the text field in the crosstab outline
   
3. Apply a conditional style using the appearance settings of the textfield.
   

For the creation of the conditional style you can use the variables in the crosstab by selecting Crosstab in the left bottom side of the expression editor. After clicking on crosstab you should see the different variables used in the crosstab. A general reference to conditional styles can be found in the jaspersoft manual (a quick internetsearch did provide me with this link: https://community.jaspersoft.com/blog/conditional-colors-fields-jasper-studio-601-example-sceenshot-and-jrxml ).

Hope this helps.

Kind regards.

[Manipulating crosstab]

I am trying to figure out how to manipulate a crosstab in jaspersoft. Can I alter the crosstab in the designeror should I always go through the properties. If I change the crosstab in the designer the columns/rows get completly messed up. 

Thanks!

[Conditional style missing]

Correct. In the past I was able to create a conditional style as described. Now however it seems to be dissapaered. I have tryed switching the project... without result. Resetting the perspective did not solve the problem. 

Update: this seems only to be the case when trying to add a coditional style to an external stylesheet. According to this post (https://community.jaspersoft.com/questions/533024/styles-conditional-inheritance) it is impossible to add conditional styles in external shylesheets. Is this still the case?