drummer54

No one knows how to get this to work? I'm still having this problem and see no way around it. I might have to report it as a bug, because I've created groups and shouldn't those group footers provide subtotals for that group rather than a running total? It's not the kind of thing I should have to jump through hoops to get to work.

I've asked a similar question and received no responses but have made progress - albeit by trial and error and creating a new report each time I figure something out with row groups, because there seems to be no facility for rearranging crosstab row groups. The current issue is that the highest level row group - year - produces only a total row at the end of the report even though there are, depending on one of the parameters being passed, sometimes multiple years to display on the report. In the attached XLS file search 'Total January'. Under that row there should be a row labeled 'Total 2014', but instead it goes into December 2013 and at the end of the report there is a row labeled 'Total 2013' which combines all of the data for 2013 and 2014. How can this be resolved? And can it be done without creating yet another report from scratch that would include the fix? As stated above, if the answer it another row group that is parent to the year group, there seems to be no way to add it, because it will be appended to the other groups and there is no way to move it.

I never used iReport but agree that JasperSoft Studio is "not ready for prime time." Have you tried using the crosstab control? It's horrible. And if you make changes to it DO NOT save your report until you're sure the change works properly, because the undo is extremely buggy.

I tried the update but it wouldn't complete. I'm still feeling my way with this so maybe it's something I did wrong? Below is the error message: Your original request has been modified. "Jaspersoft Studio feature" is already installed, so an update will be performed instead. Cannot complete the install because of a conflicting dependency. Software being installed: Jaspersoft Studio feature 5.6.0.beta-v201405151441 (com.jaspersoft.studio.feature.feature.group 5.6.0.beta-v201405151441) Software currently installed: Jaspersoft Studio 5.5.2.final (com.jaspersoft.studio.rcp.product 5.5.2.final) Only one of the following can be installed at once: Cassandra Plugin 5.6.0.beta-v201405151441 (com.jaspersoft.studio.data.cassandra 5.6.0.beta-v201405151441) Cassandra Plugin 5.5.2.final (com.jaspersoft.studio.data.cassandra 5.5.2.final) Cannot satisfy dependency: From: Jaspersoft Studio feature 5.5.2.final (com.jaspersoft.studio.feature.feature.group 5.5.2.final) To: com.jaspersoft.studio.data.cassandra [5.5.2.final] Cannot satisfy dependency: From: Jaspersoft Studio feature 5.6.0.beta-v201405151441 (com.jaspersoft.studio.feature.feature.group 5.6.0.beta-v201405151441) To: com.jaspersoft.studio.data.cassandra [5.6.0.beta-v201405151441] Cannot satisfy dependency: From: Jaspersoft Studio Community RCP Feature 5.5.2.final (com.jaspersoft.studio.rcp.feature.feature.group 5.5.2.final) To: com.jaspersoft.studio.feature.feature.group [5.5.2.final] Cannot satisfy dependency: From: Jaspersoft Studio 5.5.2.final (com.jaspersoft.studio.rcp.product 5.5.2.final) To: com.jaspersoft.studio.rcp.feature.feature.group [5.5.2.final]

Why is it that I can only upload one file when I ask a question? It seems to allow me to upload multiple files but when I go back to review there's only one file and I have to edit the question to add another file. This happened earlier today and I thought I had done something wrong but apparently not. I had to edit the question twice to get all 3 files uploaded.

The crosstab control is making me feel dumber and dumber and way too old to be doing this ****. Latest problem - trying to display subtotals by month and year. When I added the row groups for year and month it placed the page_count_measure1 variable in the footer and when I ran the report the values were identical to those on the last row displayed, which seemed to make the row groups rather useless. I added a measure to sum the page counts and placed those in the row group footers but I still only get one subtotal row for month (though the report is running for 2 months) and that month total is the same as the year total. There is no break on month as I'd expected. Also the text for the row group footers is "total month1" and "total year1". If I replace the static text fields with variables for month and year I get a null value. I suppose that makes sense but it also contributes to making the row group rather useless if they can't be identified (assuming I can get the totals correct). I'm going to attach the JRXML file and Excel files representing the output from the current production report developed in SQL Server Reporting Services and the output from JasperReports. I will greatly appreciate it if someone can explain where I've gone wrong.

Interesting - I started deleting items from the crosstab hoping to narrow down the problem until arriving at the minimum to have the crosstab work and got the null pointer exception every time I ran it. I deleted the crosstab control and didn't get an error but of course didn't get a report either (I don't need the detail band so deleted immediately after creating the report). I then closed the report without saving, having saved it immediately before deleting items from the crosstab. I reopened the report and ran it and, lo and behold, it worked. Why would that be? I'm used to closing and reopening Microsoft products to get them to work properly but I didn't even close JasperSoft Studio. I only closed and reopened the report.

Is it just me and the report I'm trying to create or does anyone else have a problem with java.lang.NullPointerException errors in crosstabs? I've been trying to create what is proving to be a very complex report (simple in SQL Server Reporting Services but not so much in JasperSoft Studio) and for every step forward I end up taking one back when I try to add another feature. Unfortunately, I've also had serious problems with the undo function, so that when I do foul up something I usually can't get back to the most recent good copy. I've been overcoming this by not saving my work until I have what I know is an error free version, but this last time it didn't work and I ended up having to re-create everything I had done. After doing so the java.lang.NullPointerException cropped up again and I've no idea what the source is. I can't even remember how I resolved it previously (likely dumb luck). Maybe I'm just getting too old for this ****.

I've created a crosstab using results from a SQL Server stored procedure that list processed page counts by person by day. Column headings are individual pages and the first row is the date in descending order. The individual names are to be ordered alphabetically in ascending order. So far, so good. But, 2 of the columns have a total count of processed pages by date and a count of unprocessed pages which are to be displayed in the second to last and last columns, respectively. The way we currently manage this, in a SQL Server Reporting Services crosstab, is by using a column called sort_order. The individual names have sort_order = 1, the total pages sort_order = 2 and the unprocessed pages sort_order = 3. I can't figure out how to have the JasperReports crosstab use the sort_order field to get the columns in the correct order. The stored procedure is returning the data in the correct order. I also added sort fields to the dataset to make sure they were being sorted properly in the dataset. I tried setting the 'Data Pre Sorted' option in the crosstab dataset properties but then the page counts cells ended up all blanks. I created another crosstab and added sort_order as a column group in addition to individual name and that results in a null pointer exception.

That's great! I've run into issues with undo in the crosstab editor today. Thanks.

I don't think that's going to help after all. The Java solution is far outside my comfort zone and the style solution won't work for me. I had thought that maybe it would work in a Pattern Expression but I can't find any documentation for Pattern Expression and my attempts at coding it compile & run but have no effect. Thanks, anyway.

I wasn't able to recreate exactly what happened, but hopefully it's close enough. I had another copy of the report that I had been working on and saved it to yet another copy. On this last copy I double clicked on the table to open the table editor, selected the first 3 columns (company, region, location) using shift-click, right clicked and selected New Column Group. Everything appeared to be normal so I clicked Undo to return the table to its previous state. The result was that the first FOUR columns were reordered to company, region, head count, location. I've renamed the files to before.jrxml and after.jrxml for clarity.

Thanks very much. I'm quite new to JasperReports and never used any version prior to 5.5.1. Anything you can do to make things more intuitive is much appreciated! I'll see if I can reproduce the problem. It occurred more than once but the last time I performed this operation it worked. Unfortunately I had to abandon creating the report using a table because I couldn't figure out how to perform calculations beyond simple sums in subtotal rows. I submitted a question but received no useful responses. Basically I have to sum two different fields then divide one of those sums by the sum of both fields to obtain a percent.

That might help. Not being Java fluent (used it for a few months about 12 years ago but that's all) I'll have to study it. Thanks very much.

I discovered this morning that none of my subtotals is working properly. If I run the report for a single region within a company the totals are correct, but if I run it for multiple regions in a company the simplest grouping becomes accumulative. In other words, for example, the employee head count for region 1 is correct but for region 2 is the accumulation of regions 1 and 2, region 3 is the accumulation of regions 1, 2 and 3 and so on. And the percent column is simply the first region percent and never gets updated. I can't believe how unintuitive and poorly documented this application is.

Is there a way to create a single conditional style to apply to multiple fields and variables? For example, I have a report being populated from a SQL Server stored procedure that returns 12 fields, one per month, of data represented in percentages. For each month I need to set the background and foreground colors to one of 3 different combinations based on how the percent for that month falls within a specified range. I also have variables for each month that calculate these percentages at the region and company level. That gives me 12 fields and 24 variables to set a conditional style for. The only way I can figure out to do this is to create 36 different conditional styles, one for each field & variable. Is there an easier way to do this? It's quite cumbersome and tedious. Seems it would be much easier to create 3 styles and in each of the 36 objects set the style based on the value in that object.

If you happen to see this (I know it's been awhile), what reporting tool did you settle on? I've been playing with JasperReports and anything beyond a very simple report seems to require jumping through a lot of hoops, assuming you can figure it out or get a straight answer.

I finally figured out how to do this, but it certainly wasn't intuitive and not something I ever found documented anywhere.

Could someone please EXPLICITLY explain how to pass parameters to a crosstab? The only instructions I've found are for iReports, which I've never used and have been unable to translate into JasperSoft Studio. I've created parameters in the main report and in the crosstab but cannot find a way to pass from main to crosstab.

I originally tried a cross tab but couldn't get it to work. Can't recall the exact problem. It was a few weeks ago and I've worked on a lot of other things since then. I'll take a look at that again. Thanks.

I have a table that groups on company and region after printing location detail. Is it possible to merge cells in the group footers for a more pleasing layout, one which our users are accustomed to seeing with SQL Server Reporting Services? For example: Company1Region1Locaton1535 location2447 Selected locations for Region1 total9712Selected locations for Company1 total9712Is there a way to do this without jumping through hoops?

I created jrxml.txt and uploaded it. Thanks.

By the way, this is in JasperSoft Studio 5.5.2

I've uploaded the latest JRXML file, the latest of several attempts. This one doesn't produce an error but it returns 0 for the calculated percent. The variable mth1_individual is where the percent is being calculated as the result of (mth1_compliant / (mth1_compliant + mth1_noncompliant)) * 100

I'm at my wits' end over this. I've created a table in JasperSoft Studio with subtotals on region and company. The detail data from the database contains, by location (the hierarchy is company / region / location), values for number of employees, total number of compliance events for all employees for that location, number of events that are in compliance, number of events not in compliance, and percent in compliance. For example, the first location has 40 employees, 1793 total events, 1760 events in compliance and 33 events not in compliance. That results in a compliance percent of 98% after rounding, 1760 / 1793. All of this data is returned by the database query. The problem I'm having is in computing region and company percents. I have to sum the events in compliance and the events not in compliance across region and company levels and then perform the calculation to get the percent in compliance for each region and the company as a whole. How is this done? Everything I've tried either results in 0 for the percent or an "Error evaluating expression".