[How to find the difference/variance between previous and current row values in detail band ?]

Hi,

You can achive this by using 3 variable. For example create variable like below. Sort is important. Beacuse jaspersoft calculates the variable by orders.

1. vSalesCurr =  $F{Sales}
2. vSalesDiff =  $V{vSalesCurr} - $V{vSalesPrev}
3. vSalesPrev =  $F{Sales} (you can define 0 as initial value)

While jasper processing the vSalesDiff,

• vSalesCurr holds current value because it is calculated already
• vSalesPrev holds the previous value because it is not calculated yet and still holds the previous value. 

That's the trick.

[How to link input control with report parameter?]

If you use different dataset from main dataset to load data to your report, you have to pass the parameter to the sub dataset also. Probably that's the problem.

[Count number of rows where a specific fields value]

Hi,

I assume that you use the variable on Group header, not on group footer. So you have to set the evaluation type of the textfield which is used for variable on table. Select the text field and go the properties. Under the 'Text Field' section, set the evaluation type as '[Groupname] Group' and try again. You should see the proper values.

[Limit number of rows to be fetched in query]

If your query result has too many rows, then yes.You should test two way and decide. In my experience, around 100K records the performance difference is noticeable.

[How can i show sum of column in heade or details band]

1. Change the rotation of the fields.Go to static text properties>static text>rotation

2. Drag the fields, which you want to sum, to column header and change fields evaluation time to 'Column'.

[Limit number of rows to be fetched in query]

Hi psundaravaradhan,

You are right. That's the only way to make it on Jasper level is giving a filter expression. But If you want to use like that and the result set has too many rows, some performance issue will come with it. Because when you giving a filter expression for the top records, reports show top records after fetching all the query results.

 

 

 

 

[How should the source be written to use the first three letters of the name if four is not available?]

You can try this.

IF(LEN($F{patron_last_name})>4,$F{patron_last_name}.substring(0,4),$F{patron_last_name})

[Showing Multiple Markers on Map Component even subdataset returns single row of lat-long]

For detail band nature, it is normal to behave like that. For example in first iteration dataset has one row but second iteration the result set has two row and goes like that. So. first evaluation of detail band your map has one marker and second iteration there will be two marker with previous one. 

Create two parameters for lat and long data and try to assign your lat and long fields to that parameters. So your parameters will hold last record while each detail band evaluation. After that use that parameters, not fields, for markers.

[java.lang.IllegalArgumentException: Illegal pattern character 'r']

I guess there is a field with illegal pattern on report. Check the fields' pattern on report by design window or search with 'pattern' on source window. Find the field and correct the pattern.

[how to prevent groups from repeating]

Create a sort field from outline window according your gruop which is city i guess in your case. Jasper groups the data according the order of the result set coming from datasoruce. So you need to order first. 

[JasperServer Error, resource not found at: subreport]

Change subreport expression "repo:subreport.jrxml" and publish report to jasperserver.

[In 'Text Field', '11' and '111' numbers are printed incorrectly.]

Without lookinh to source code, hard to tell sth. If you share the source code, you can get more accurate responses.

[Query failing on row number sql command]

Are you sure about this query working on SQL. Because there is a syntax error.

 select
a.oracle_project_id, a.client_id, a.mhs_client, a.stage, a.Date_Changed
from (
select  o.oracle_project_id, o.client_id, o.mhs_client, v.Date_Changed, stg.name stage,
ROW_NUMBER () OVER (PARTITION BY o.oracle_project_id ORDER BY v.Date_Changed desc) AS RowNumber)
from inv_investments inv ...

Remove the end bracket after 'RowNumber' and try again.

[Edit multiple reports]

create a group from outline based on name field. Click group band and go to group band propertes. check the 'new page' under Group Band Properties.

After that, go to report properties and check the properies as you want for example 'title on a new page'

[Hello, I have been trying to create a table with 2 headers and merge cells. Like in the example below. Can someone please explain HOW TO MERGE CELLS using the design pannel (not the code). Please help. Thanks in advance!]

Hi,

Select two columns, right click and go for 'Group Columns'. After that modify your table design as you want.

[cvc-enumeration-valid error]

I guess there is an empty property or properites on report. So it causes an error about that value.

Switch to xml view and search for  ="" . Check the propertes with ="" and give them a valid value.  

[Hide column in table by use of property]

I checked it on jasperserver 6.1 and it works perfectly even make the change on studio by using print when expression. Showing hidden column by selecting from 'Show columns'  is valid and working. What jasperserver version are you using?

[my jrxml just can find only one row]

You should use group bands or detail band for fetching data not column bands.

[Expression Editor]

Check if xtext plugin for eclipse is installed. if not try installing xtext plugin.

eclipse.org/Xtext/download.html

 

[Input control overrides as I publish reports to Jasper Server]

Hi,

Uncheck the 'is for prompting' of acct_id parameter from studio. Next time you will publish the report, jaspersoft studio will ignore it. 

[Jasper server returns an internal server error when I try to log on to the server. How do I fix this]

It seems you have a connection porblem to your mysql DB.

"Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure"

I'm quoting from this answer which also contains a step-by-step MySQL+JDBC tutorial:

If you get a SQLException: Connection refused or Connection timed out or a MySQL specific CommunicationsException: Communications link failure, then it means that the DB isn't reachable at all. This can have one or more of the following causes:

 

1. IP address or hostname in JDBC URL is wrong.

2. Hostname in JDBC URL is not recognized by local DNS server.

3. Port number is missing or wrong in JDBC URL.

4. DB server is down.

5. DB server doesn't accept TCP/IP connections.

6. DB server has run out of connections.

7. Something in between Java and DB is blocking connections, e.g. a firewall or proxy. 

 

To solve the one or the other, follow the following advices:

 

1. Verify and test them with ping.

2. Refresh DNS or use IP address in JDBC URL instead.

3. Verify it based on my.cnf of MySQL DB.

4. Start the DB.

5. Verify if mysqld is started without the --skip-networking option.

6. Restart the DB and fix your code accordingly that it closes connections in finally.

7. Disable firewall and/or configure firewall/proxy to allow/forward the port.

[Having a problem with variables and the IF function]

IF($F{partnumber}=="90000013",$F{qty},0.00)

or

IF($F{partnumber}.equals("90000013"),$F{qty},0.00)

[How to let user change measure in HTML5 bar chart?]

You can not use sth like "$F{$P{MeasureType}}".

For example, the expression should be sth like:

$P{MeasureType} == 0 ? $F{s_amount} : $F{s_number}

[Hide detail band when table fetching empty record]

ıf you send your selectable fields in to your subquery you will get this.For example,

select id,name,(select count(*) from tasks where per_id=x.id) as checkfield

from person x

where $X{IN"x.id","personid"}

[Hide detail band when table fetching empty record]

That's a little bit tricky I guess :) maybe you can try do sth like this. add a column your main report query and the query will be your table dataset query with COUNT().

(select count(*) from ... where ... ) as checkfield

so, if checkfield is 0 then it means there is no record for that specific row.

After that you can use this field for print when expressin of detail band :)