javier.ggi90

Solved it by changing ALL joins interacting with the table to Left Join. This table had two joins with two different tables so I had to change both of them to Left, apparently Jasper detects an anomaly and resets it to default (Inner Join) if there is a design mistake.

Hi everyone, I am having an issue while creating a domain in the JOINs tab. Every time I try to pick Left Outer or Right Outer and then exit this tab (either by selecting another tab or saving the domain) the value is reset to Inner Join. Has anyone seen similar issues and how can I solve this? Javier PS: Using JasperServer 6.2.0. Edit: changing tabs does not reset the value to Inner, but saving the domain resets it.

I know this was long ago but I am facing the same issue in JasperServer 6.2.0, did you get a solution for this?

You can create a new Variable and write its expression as follows: new SimpleDateFormat("dd-M-yyyy").format($F{yourField}) This converts your date into a String with the specified format which is useful for grouping. Javier

Is there a way to escape reserved words in the DOMEL language for the domain's calculated fields? I have a field called "in" and need to use it in a calculation to create a new one. Is that possible? Javier

Can you attach or paste your jrxml? Maybe I can find something there and help you better. Javier

I always do the following to achieve what to state: Add the subreports in the same band (except detail or footer of any group)Add the "break" element between all subreports set it up to break on page.ignorePagination: default value (I don't remember if that is true or false).net.sf.jasperreports.export.xls.one.page.per.sheet=true (just to be sure I add this property in the main report and every subreport)As a bonus, there is a property that allows you to name each sheet as you want. If it will always have the same value you can use net.sf.jasperreports.export.xls.sheet.names.{arbitrary_name} changing 'arbitrary name' for the sheet number starting from 1, e.g. to name the third sheet you write the number 3 and the value you want. If the name of the sheet changes dynamically you have to use net.sf.jasperreports.export.xls.sheet.name on a report element. The first property does not accept variables/parameters/fields but the second property does. Hope any of this helps, Javier

The way Jasper handles data sources in reports makes it so that it is used and consumed so you have to "rewind" it to use it again. You can look at it as a table (lets assume it has 5 lines): The first subreport runs and uses the datasource's information up to the fifth line.The second subreport tries to access the the data source and reads it but it is already on the fifth line so it assumes the source is empty.I do not really remember how to solve this (specific instructions) but I do remember passing some instructions into the "Data Source Expression" property of the subreport. An example of something I did for a JSON datasource is passing this value into the previously mentioned property: "$P{REPORT_DATA_SOURCE}.subDataSource()". Hope I at least point you into the right direction. Cheers, Javier

The problem is that, because of the way my application works and is used by clients, the domain's cache functionality was disabled. We are working on the database side now which is probably the best way to tackle this problem.

Hi everyone, I am having some performance issues in my domain due to having a derived table with HUGE amounts of data. From what I have read and done I understand that a domain loads ALL the data in the database and then applies filters based on a report's parameters for example to filters all the retrieved data. So my question would be: Is there a way to load only information needed based on the parameters before the domain loads all the data from the database?If there is, how can I achieve this?Thank you for your help, Javier

Are you sure the parameters are the correct data type? Also that the date's format is the same as the one you are using the MySQL's stored procedure?

Does the same error appear if you try to "ORDER BY filer_name_organization, filer_name_last"? Sometimes I have issues while grouping or ordering by an alias.

Yes you can, what you cannot change is the ID of the domain. If you want to do that, I suggest creating a copy of the domain naming it and giving it the ID desired and then pointing every report you want to that new domain.

Don't know your exact route to the report but lets just say you run a report. Now, copy the URL and at the end add: &parameter_id=value&parameter_id2=value2.....&parameter_idx=valuex

The correct use of parameters in query is $P{param_name} so change your query to the following: select * from instance where (CUSTNAME = $P{customer})

If you still see "null" even though the "blank when null" property is set, then you probably have a "null" string. Then you can try setting the condition as: WHERE total != "null"

Can you please paste the log? I don´t think that is enough information for us to work out a solution.

There is a property named as "Remove line when blank", check it so it is true. If that does not work you can try to modify your query for the report so that you have a condition as follows: WHERE (info1 + info2 + info3) IS NOT NULL Cheers, Javier

Does Jaspersoft have any integrations with security frameworks like OAuth, Active Directory, or LDAP? No idea on this, sorryIs Jaspersoft the same as the “Jasper Report Server”? Jaspersoft is a company owned by TIBCO and one of their products is JasperReports ServerWe have installed Jaspersoft from the Amazon Marketplace. Is there an easy way to tell from our AMI which version of Jaspersoft we installed? In any screen on the bottom left side is a text field with "About TIBCO JasperReports Server" that is actually a button, click on it to see your version.We would like to use Jaspersoft to display dashboards on TV monitors we have throughout our office. However, my experience with Jaspersoft is that the user is logged out after a given amount of time. Are there any options to prevent login timeout so we can use Jaspersoft for this purpose? There probably is a way to configure this, though I am not sure.Is there any easy way to clear out all of the demo data sources, domains, adhoc queries and reports that come with the default AWS Marketplace install? The easiest way I know of is to delete them manually, you can delete complete folders so this should not be that hard.I found a website that covered features in Jaspersoft 6.2 that we do not have in our version of Jaspersoft. How can I find out if/when that version will be available in the Amazon Marketplace? Version 6.2.0 is already available from the support homepage given to you when you purchased the AWS JasperReports Server. You can download it from there and use their js-upgrade scripts to upgrade it instead of uninstalling and installing again.When using the AWS Marketplace version of Jaspersoft, is there an upgrade path to newer versions of Jaspersoft, or is our only option to create a new AMI and port all of our objects to the new environment? If having to move everything from one environment to another, where can I find documentation on best practices and steps for doing this? See above answer, as per documentation or a guide I used this and found it really helpful: http://community.jaspersoft.com/documentation/tibco-jasperreports-server-upgrade-guide/v62/upgrading-61-62 Regards, Javier

What Kkriplani said is true, you should go and check out the information he recommends. But to answer your question I always use something like this: WHERE company = $P{COMPANY_NAME} AND ($P{EMPLOYEE_CODE} is null OR $P{EMPLOYEE_CODE} = code) AND ($P{JOIN_DATE} is null OR $P{JOIN_DATE} = joindate) What this does is that it checks whether the PARAMETER is null and if it is not null, then it compares to the field you want to filter with.

Solved the issue by upgrading JasperServer from version 6.1.0 to 6.2.0. Apparently this is a bug with the version of the server.

Is PRIORITY a numerical value? If so try it like this: ($F{PRIORITY} == null ? 0 : $F{PRIORITY}) and make sure the variable is of a number type (BigDecimal, Integer, Double, etc)

I had not thought of doing that, I uploaded one of the subreports as an independent report and it is showing as empty but the parameters are all correctly assigned. Additionally I added the No Data band and that is what the report is loading. I have checked the parameters are correctly assigned, that the data source is the same one but there is still no data even though Studio does show the correct information from the domain. EDIT: Can this be a bug in Jasperserver? I am using AWS and the server is version 6.1; after several tries and inspection with other reports that worked on the trial version (Jasperserver 6.2) and none of them work anymore, every of them appears as empty.

As you probably found out already, if the value is null there will be no dot so you can solve this in several ways, I can think of these: Create a new dataset for the chart and EXCLUDE data for the registers that have no value.Put the values into a variable and create the chart using this variable. In the expression create a condition so that if the value is null, it should take a value of zero.Regards, Javier

The main report has no data but I added some to test it and it seems that the report IS showing but the subreports are coming up blank. @hozawa: By dependencies do you mean the jrxml files and input controls? I did check that. I uploaded it two times, once via Studio's assistant and the other directly in the server and adding the dependencies manually.