mwolven

So, I have a chart element in the report's summary band. The chart generates correctly with the correct fields on the screen. BUt where there should be 14 dates along the X Axis, it only shows 1 date and 1 accompanying data point. What am I missing here? In the chart TSN_QT is a numeric field and LAST_COMP_DT is a date field (java.util.Date).

Also - looking for help with Charting. I have the same NULL KEY issue stated above. Is there a good "How to" guide for charts?

I have a Frame in a group header. The frame has 2 rows of Static Text Elements and Text Fields. All of the Text Fields are set to Strect with Overflow. The elements on the second row are set to Float. The frame expands to fit one of the subreports, and it will also expnd if a first row field increases its height. However.... the second row field (under the expanded first row field) should get moved down in the box while the box expands (expected behavior). Except that it appears to me that the field gets pushed down, Jasper doesn't expand the Frame, then Jasper sees that this element is partially out of the box, and doesn't print it. What can I do to make the second row elements behave as I want them to? I had the second row elements in an additional frame, but that pushed the entire frame outside of the outer frame.

Thanks but that doesn't help. The issue is that I need a field (RESOURCE) to be part of the WHERE clause (WHERE $X{IN, RESOURCE, P_RESOURCE}. The parameter (P_RESOURCE) gets its value(s) from an input control. But I do not want the field (RESOURCE) to be in the SELECT statement. But the $X{IN} requires that it be in the select.

What do you do when you print a report and it doesn't display correctly? That is, you suspect that there should be data in the subreports but they are not being displayed. I have occasionally encountered a situtation where my group headers display, but then there is a blank space before the next grouping header where i suspect a subreport (or 2) should be printing. It's curious that it seems to leave space for a 10 row subreport, but doesn't display the actual subreport. So, are there log files that I haven't discovered yet? Or if Jasper doesn't throw an error on the screen, I am out of luck.

I have an Input Control that is designed to have all options selected as the default option. Searching here, I found that I can default the values in the parameter to: new ArrayList(Arrays.asList(new String[] {"WhatValueUWant"})) If the parameter is named: Doc_Status - what is the syntax to put in that parameter's "Default Value Expression" Will that create the behavior in the JasperServer Input Control where all the values are preselected?

I am trying to use the $X{IN, FOO, FOO} where the field "FOO" is not in the Select statement. In SQL, generally, you can reference a field in the WHERE clause that is not specified in the SELECT part of the query. Jaspersoft doesn't seem to support this. I have a SELECT statement that is controlled by 5 input controls in the WHERE clause. If I have to add those 5 fields to the SELECT statement, I get duplicate records because those 5 additional fields cause the other fields in the select statement to be non-unique. Certainly I am not the first person to come accross this - does anyone have a viable workaround?

Turns out, I was lucky enough to the have export.zip file of the reports. I ended up having to unzip the files and then removed the .data extension from all of the subreports. Then, I copied them into a directory that had the .project file and it seems to be working.... for now...

Last week under deadline pressure, we had to edit the files from our JasperServer connection thought the JasperStudio interface. That is, creating a connection to the Server, and editing the jrxml files directly. We did that becuase our files in our jasperworkspace had become corrupted/out of sync/un-usable. Now, we have time to recover the files from the server, put them back in a proper workspace and return to our version control practices. How do I do this? There isn't an obvious method from within Studio and loooking on the server from a remote desktop connection, I cannot seem to find any of the edited files. The files are still accessible from within JasperServer (my reports still run) and from with JasperStudio.

Using Jasper Studio 5.6 So, here is my issue, I have a report, with a subreport, and a second subreport within the first subreport. When I run the report, I get pages with the following content: 1. The group Header from the Main report (a piece of inventory) (60 px in height) 2.The First Subreport header and detail (50 px) and 5 child subreports (1 column header and 5 child records) 3. The First Subreport header is repeated and the child subreport column header is repated and 1 more child subreport. 4. A new Group Header from the Main with a second piece of inventory. And the Column Header and detail from the first subreport. (Total of 110-120px) 5. The column header from the 2nd subreport and 5 more child records. 6. The First Subreport header is repeated and the child subreport column header is repated and 1 more child subreport. How do I get the First Subreport header from page 2 to print on page 1 with the Group Header from the Main page? And how do I get the child records from the second subreport to break better? That is, it seems like JasperServer when displaying those records starts with a blank page to keep as many records together? At this point, I feel like I have tried many combination of split types, etc. Any help would be useful.

Let me restate my question, if I wanted to present and publish 3 version of the same report Inventory_1, Inventory_2, and Inventory_3, what is the easiest way to save these versions? Di I need a separate project file for each? I am interested in using SVN forour projects, is there a how to or best practices for managing the workflow and project spaces?

What is the best way to create test versions of the same report? I have a complicated report with multiple sub reports, input controls and parameters. It seems that copying the folder or doing a Save As doesn't create a clean version of the report. There seems to always be connections to the old sub report location, or the Project file needs to be rebuilt. If I want to present multiple, slightly different versions of the same report to a client, what is the best way to do that?

A client has asked for a Unix version of some previously delivered reports (developed with JasperStudio 5.6). Does the client actually need anything different? Or will the jrxml and .jasper files suffice?

I have a report requirement which is as follows: In the Detail: Main A Row (with 3 Subreports) 1. Subreport D (with Subreport C) 2. SubReport M with Subreport D (and Subreport C) and Subreport P (with Subreport D (with Subreport C)) 3. SubReport P (with Subreport D (with Subreport C)) I have them all connected via two different IDs. They seem to be pulling the correct data. When I have them in the detail report, they just display the same Subreports over and over. If I move them to the summary (as was suggested), they print at the end of the report. I've added group footers on the IDs, but that doesn't seem to get the subreports right either? Would it make sense to have the 3 subreports in a larger subreport that contains the 3 detailed subreport?

So, if I move my subreports to the summary, then they will only print at the end of the report. Correct? Maybe I am using subreports incorrectly? I have a detail row, and then I want to display a row (or rows) of related data. There can be 0, 1 or more related rows, so, I set them up in a subreport. Shouldn't the subreport be called after the detail grouping finishes? That is, if I group in Inventory_ID, when all the detail rows are printed, it should then print the subreport related to that Inventory_ID. Then it should go on to display that next Inventory_ID. Is my logic correct? If I set the report to group on Inventory_ID, should it print the detail row, then any sub reports in the Group footer? Or would those be in the Detail band?