Ullauri.Byron

jasperserver stack comes with its own installation of mysql. Check to see if you have multiple instances of mysql running....conflicting ports change the port number on the jasperserver instance of mysql if needed make sure the port number for jasperserver mysql is the same as the one specified in tomcat (.../tomcat/webapps/jasperserver/META-INF/context.xml)

Found the answer here. 1.) Create a variable (_subtotal) with an expression simillar to: (isFirstRecord) ? initial_balance + amount : amount 2.) Create another variable (subtotal) that sums on _subtotal

I have an initial balance field that I use to keep track of subtotals and eventually an ending balance. these subtotals are equal to: initial_balance + amount I created a variable that does this subtotal calculation: _subtotal and created another variable that sums on _subtotal: subtotal Tbe issue im having is subtotal is adding the initial balance again for each record. ex. initial balance: 20 amount = 10 subtotal = 30 amount = 15 subtotal = 65 . should be 45....

If place the account field in the dummy header only the first account number shows up. Tried using a variable too.

I'm using a JDBC connection as a data source for my master report and would to know if its possible to pass the resultset from my master report query to a subreport for reuse? The reason I'm doing this is that my subreport is essentially repeating the same query as the master report and getting the same results. If it is possible please explain how to do it as well!

Are you suggesting I create n number of groups based on n number of accounts? If that's the case then it would be a problem because I don't know the number of accounts beforehand. I used 4 accounts as an example (A,B,C,D) but it could be more or less. Also, in this multiple group scenario, I would be grouping by the same column...Don't think this presents a problem but just wanted to be clear on that. My solution for it so far has been creating a subreport that uses the same JDBC connection, but it repeats the query and handles the summary grouping there. I feel like this is a redundant approach and have been trying to see if I can reuse the resultset from the master report in the subreport to avoid the repeated query. I placed the subreport in the title of the master and it comes out how I want it, Summary of account A Summary of account B ... Summary of account n Account A Details Account B Details ....Account n Details though I am still looking for a better approach.

Say I have 4 Accounts that are grouped by account number, I would like the following where the summary would be a total balance Accounts Summary Header Summary of Account ASummary of Account BSummary of Account CSummary of Account DAccounts Summary Footer Account A Details Header Account A Details... Account A Details Footer Account B Details Header Account B Details... Account B Details Footer Account C Details Header Account C Details... Account C Details Footer Account D Details Header Account D Details... Account D Details Footer The report I am using now groups them by account number but is repeating in the following way: Summary of Account A Account A Details Summary of Account B Account B Details ...etc I have thought of considering a subreport for the summary section but it would end up being the same query used for the details section which would make it redundant.