[Jasper Studio 6.3.0 - Month-1 issue with a 'create date' filter]

Hi, please see attached demo document.

DateRangeExample.jrxml

[Jasper Studio 6.3.0 - Month-1 issue with a 'create date' filter]

That's because MONTH-1 and its friends are so called DateRange-Expressions.
They are used to instantiate a DateRage object. On that instance, you can call getStart() and getEnd() to obtain the start and end of the given DateRange.

[Custom Function in Jasper Report]

Hi, 

you can use a Subreport for that. Pass the summarized value as parameter. Subreport's data query is something like 

call orcale_function($PARAM)

Then you either print that information directly OR you return the information via variables back the the calling report and use it there.

[How to add indivual metadata to PDF using JasperPrint]

Hi Kathrin,

you can set these properties via properties on the report object: Jaspersoft Config Reference Search for PDF.

 

We're a german based consulting company having a lot of Jaspersoft customers and many many skilled colleagues.
If you need more help feel free to reach out: Gesprächsbedarf?! 🖐 Buchen Sie sich direkt einen Termin! 📅

[How to remove double entries]

Hi,

you can use the Grouping Feature of Jaspersoft and utilize a variable to summarize the value.
You use the Artikelnummer as Group expression. In the group footer you insert the field Menge - Studio will show a wizard to create a variable. Put all other fields in there to - with no aggregation function. Leave Detail Band empty.

We're a german based consulting company and have a lot of small Jaspersoft customers. If you're interested in more details, feel free to contact me.
Gesprächsbedarf?! 🖐 Buchen Sie sich direkt einen Termin! 📅

[Jasper Reports - Accessibility]

Hi, if your question is still valid: https://jasperreports.sourceforge.net/sample.reference/accessible/index.html

[Has anyone developed a way to use JasperReports to create Zebra Labels]

Apparently there's a PDF Direct Print Driver available from ZEBRA. That should enable you to print a PDF.

[How to only pass some parameters via hyperlink and prompt for others]

Perhaps you can use the display settings of the input controls (Top of Page, In Page, ...) to find a setting so that the input controls are always displayed. Then they could be prefilled accordingly.

[inserting existing PDF]

Could https://github.com/katjas/PDFrenderer be an option to render a PDF inside an image expression in Jaspersoft report?

Utilizing the interface Graphics2DRenderable? https://jasperreports.sourceforge.net/api/net/sf/jasperreports/renderers/Graphics2DRenderable.html

[How was your experience with your migration from Crystal Reports to Jaspersoft]

We migrated reports from Crystal Reports to Jaspersoft as part of a project and replicated them pixel-for-pixel.

Stumbling blocks were the execution/display of the data query, the possibility to output data grouped in CR and to replicate the integrated drill-down functionality.

[Bottom Page numbers]

Hi, without further information (bands, print when, …) we cannot help you.

[Multiple Row Definitions in a Table]

Hi,

I would not use a table element here either. I see the use for it limited. It is possible to remove columns and the remaining columns slide up - but the space of the table is not fully used. For such a use case I would go for customized SubReports.

[how to transform character in integer]

Hello,

This should actually work as a problem. Your idea behind it is correct:

Depending on the value of the string (yes or no) a 1 or 0 is summed up. This gives the total sum of the records with yes.

I would simply set the Initial Expression to 1. This will be overwritten with the first record anyway.

I would set the Expression to

$F{arret_dom} != null && $F{arret_dom}.exqualsIgnoreCase("oui") ? 1 : 0

Probably your comparison with == leads to a problem. This checks the equality of objects in Java. Two strings can have the same content but be different objects.

Consider also the correct evaluation time of the text field in which you use this variable.

Greetings, Johannes

  

 

[Multiple Row Definitions in a Table]

Hello Florian,

that is possible and shows the versatile applicability of TIBCO Jaspersoft.

Here I would use additional detail bands and include them based on Print-When-Expressions set accordingly.

Best regards Johannes Held PRODATO

[How can I create a donut chart in Jasper soft studio?]

Using the commercial edition, you can render a HighCharts pie chart and set the innerSize property: https://api.highcharts.com/highcharts/series.pie.innerSize

[How to get started with Jasper server?]

Have you checked if SQLite is one of the supported databases?

Apparently Jasperserver sets a readonly flag on opening a JDBC connection - a method that seems no to be implemented/available on the JDBC implementation of SQLite.

[Excel report with a sheet per group]

I checked “Start New Page” for my group header (and group footer). Therefore I got rid of the the page break.

I UNchecked the “Ignore Pagination” for the report. But mind, that the page height must be tall enough to hold the content for every sheet or you get “funny” sheets in between.