zh3ntil

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. vSalesCurr = $F{Sales}vSalesDiff = $V{vSalesCurr} - $V{vSalesPrev}vSalesPrev = $F{Sales} (you can define 0 as initial value)While jasper processing the vSalesDiff, vSalesCurr holds current value because it is calculated alreadyvSalesPrev holds the previous value because it is not calculated yet and still holds the previous value. That's the trick.

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.

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.

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.

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'.

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.

You can try this. IF(LEN($F{patron_last_name})>4,$F{patron_last_name}.substring(0,4),$F{patron_last_name})

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.

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.

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.

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

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

Are you sure about this query working on SQL. Because there is a syntax error. selecta.oracle_project_id, a.client_id, a.mhs_client, a.stage, a.Date_Changedfrom (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.

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'

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

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.

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?

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

Check if xtext plugin for eclipse is installed. if not try installing xtext plugin. eclipse.org/Xtext/download.html

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

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.

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

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}

ı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 checkfieldfrom person xwhere $X{IN"x.id","personid"}

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 :)