[Is there a way to make JasperReports Server use net.sf.jasperreports.export.html properties]

Hi Hozawa,

I have had the same problem. I raised a support call with Jaspersoft and they told me there wasn't any exporter properties to ignore pagination.

I asked for this to be submitted as an enhancement request but it doesn't appear to be in the release pipeline.

The workaround was to have two versions of the report - one with pagination and the other without(!!)

 

 

 

 

[Time format should be Eg. 2.30 AM to 2 hrs 30 mins in ireport]

Have you considered doing the required formatting in your database query instead?

[Things you wish you knew when you started with JasperReports Server/Library]

Johnathan, two things spring to mind:

1. Have a version control practice that works for you. We simply version controlled the jrxml file but in hindsight this isn't enough. The whole report unit - jrxml and parameters need to be included. I think this is where the import-export tools would come in very handy.

2. Make use of relative dates. You really need these if you want to schedule reports that use date parameters. I initially wrote reports using java.util.Date but never again - always use relative dates for date parameters.

[Things you wish you knew when you started with JasperReports Server/Library]

Perhaps there are some ladies who would like to contribute.

[how to divide a field by a parameter]

Add a Text Field with an expression like this:

$V{TotalCost_2}.divide($P{Building_Area}, 2, RoundingMode.CEILING)

[Things you wish you knew when you started with JasperReports Server/Library]

We're not a golf club you know.

[call oracle stored procedure - Exception: Bigger type length than Maximum]

Have you looked into this bug in the Oracle driver?

 

http://stackoverflow.com/questions/2788030/exception-while-calling-stored-procedure-bigger-type-length-than-maximum

[How to format printWhen??]

Yes the print when expression would do what you require. You could enter something like this:

 

!new java.text.SimpleDateFormat("yyyy-MM-dd").format($F{MY_DATE_FIELD}).equals("0000-00-00")

[Restricted user acces only once]

JasperServer uses Spring Security framework. So perhaps you can use some configuration to achieve this

e.g.

<session-management>

<concurrency-control max-session="1"/>

</session-management>

[Applying different band color]

I don't think you can change the colour of a band. However, you could add a Frame element to a band and add your report fields to that. Then you can create a conditional style to use different colours as required. Assign the style to the Frame element.

[How to get information from web to Jaspersoft Studio?]

If you are using the multi-tenancy feature then you can access the organisation id in a report query by creating this parameter in your report:

$P{LoggedInUserTenantId}

Similarly if you assign attributes to users you can access these using:

$P{LoggedInUserAttribute_myAttributeName}

where

myAttributeName is the name of the attribute you have defined on the server.

 

 

[Dynamic Dates when Scheduling Reports]

You should use the relative dates feature. This enables you to enter a parameter like WEEK-1, MONTH-12 and this will give the parameters the dynamic property you require in your scheduled reports.

You need to give the parameter a class type of net.sf.jasperreports.types.date.DateRange. Then you will probably want to set some default values such as:

new net.sf.jasperreports.types.date.DateRangeBuilder(EDATE(new Date(),-12)).toDateRange()

new net.sf.jasperreports.types.date.DateRangeBuilder(TODAY()).toDateRange()

 

More details available here:

https://community.jaspersoft.com/wiki/how-use-relative-dates-jrxml-static-reports

https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v60/using-parameters-queries

 

 

 

[How to perform date validations in jasper server?]

Make use of the Print When Expression property.

 

You could add a Static Text field to the title band of your report that has some like "Start Date must be before End Date". Then set the Print When Expression to be something like $P{START_DATE}.after($P{END_DATE})

[How to add percentage value inside slice of pie chart and on the top of bars in bar chart?]

For the pie-chart I added this property via the Show Advanceed Properties button. Note I had a variable which contained the total count which I used to calculat the percentage:

plotOptions.pie.dataLabels.formatter

Tick Use an expression

"function() { return ((this.y / " + $V{V_TOTAL_COUNT}.doubleValue() + ") * 100).toFixed(2) + '%';}"

 

[Need help with a Crosstab (columns are a field)]

To start with you want to remove the red lines and warning symbol that have appeared in the crosstab design. What is happening is that the $V{} elements you have do not fit in their container.

To do this you need to 

1. From your main report view, double click on the crosstab.This will then take you into the crosstab for editing.

2. From the Outline view, highlight the columns in the Column Groups and then extend them to be the same size as your $V{} elements. Or right-click on the $V{} elements and select Size To Container -> Fit Both

[jasper license]

http://community.jaspersoft.com/documentation/tibco-jasperreports-server-installation-guide/v60/setting-jasperreports-server-license#additional_646152231_1143475

 

Jaspersoft Documentation library here:

http://community.jaspersoft.com/documentation?version=13758

 

Yes I believe a license will cover any edition of the application.

[Conditional report values]

In SQL this should be

$P{owner} IS NULL

[Parameter "LoggedInUserTenantId" does not exist"]

The stacktrace is reporting a problem with "LoggedInUserTenantid" which is different from "LoggedInUserTenantId" as a consequence of the lowercase i. Therefore there doesn't seem to be a problem with your SQL query as the problem is with a query elsewhere. It would seem you have another query running which is using "LoggedInUserTenantid" and it is that query that is failing rather than the one you've quoted

[input parameter populated from prompt seems to be ignored - newbie]

That seems odd unless you've got another parameter defined in your report. If you don't think you have then I am not sure what to suggest - perhaps the report XML has become corrupt in some way. It might be worth starting a new report from scratch and add bits in one at a time.

[input parameter populated from prompt seems to be ignored - newbie]

Start with something simple to prove to yourself that the parameter value is being set. Find the parameter listed in the outline view and drag it into your title band. Then run the report, enter a parameter value and see if the value appears as text in the title band.

[adding of variables which is of different variable class]

If you are adding Strings to BigDecimals you will need to do something like this: $V{variable1}.intValue() + Integer.parseInt($V{variable2})

[Relative Date with current time]

are you not able to find this out for yourself??!?

[Relative Date with current time]

new SimpleDateFormat("ddMMyyHHmmss").parse(DATEFORMAT(new net.sf.jasperreports.types.date.DateRangeBuilder("DAY-1").toDateRange().getStart(), "ddMMyy") + DATEFORMAT(new Date(), "HHmmss"))

[How to display the pie chart percentage in decimal values ?]

Try setting this property: tooltip.valueDecimals

[Displaying 2 related records from the same table on the same Jasper form]

This sounds like you just need to write your SQL query in such a way that it brings back details of bride and groom in a single row.

So you might have something like:

 

SELECT

B.NAME AS BRIDE_NAME

,G.NAME AS GROOM_NAME

FROM

MARRIAGE_DATA B

JOIN MARRIAGE_DATA G ON G.MARRIAGEID = B.MARRIAGEID

WHERE

B.TYPE = 'Bride'

AND G.TYPE = 'Groom';