james.t
-
Posts
39 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by james.t
-
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
james.t replied to arunkumar.muniraju's topic in Products
Have you considered doing the required formatting in your database query instead? -
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.
-
Perhaps there are some ladies who would like to contribute.
-
Add a Text Field with an expression like this: $V{TotalCost_2}.divide($P{Building_Area}, 2, RoundingMode.CEILING)
-
We're not a golf club you know.
-
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
-
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")
-
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>
-
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.
-
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.
-
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?
james.t replied to daad.madhusudan's topic in Products
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}) -
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.formatterTick Use an expression"function() { return ((this.y / " + $V{V_TOTAL_COUNT}.doubleValue() + ") * 100).toFixed(2) + '%';}"
-
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
-
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.
-
In SQL this should be $P{owner} IS NULL
-
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
james.t replied to gerald.meachem's topic in Products
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
james.t replied to gerald.meachem's topic in Products
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
james.t replied to agilaganesh92's topic in Products
If you are adding Strings to BigDecimals you will need to do something like this: $V{variable1}.intValue() + Integer.parseInt($V{variable2}) -
are you not able to find this out for yourself??!?
-
new SimpleDateFormat("ddMMyyHHmmss").parse(DATEFORMAT(new net.sf.jasperreports.types.date.DateRangeBuilder("DAY-1").toDateRange().getStart(), "ddMMyy") + DATEFORMAT(new Date(), "HHmmss"))
-
Try setting this property: tooltip.valueDecimals
-
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';
