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?

Using JasperStudio 5.6, when I enter my SQL, Jasper identifies my field as oracle.sql.TIMESTAMP. If it leave it as that type, I get this error message: java.lang.ClassNotFoundExceptiom: oracle.sql.TIMESTAMP -- net.sf.jasperreports.engine.design.JRDesignField@50d0ae72 If I change the calls type to java.util.Formatter$DateTime, I get this error message: "The nested type java.util.Formatter$DateTime cannot be referenced using its binary name" So what is the correct conversion or workaround here?

Created a report in JasperStudio. Complicated report with subreports, and subreports on the subreports. When I run it in JasperServer, pages 6-35 are identical - except for the page number in the footer. The identical pages show in JasperStudio, and in PDF and XL exports. Any suggestions as to what is going on here?

So, I have a report that was created in JasperStuido 5.6. The report uses parameters that are linked to input controls. I have a sample data set that runs correctly and returns 6 rows in preview mode in JasperStudio. When I publish the report to JasperServer. The report uses cascading input controls created in JasperServer. The input controls seem to work as the cascading choices carry forward to the next input control. But when I run the report, I get the message "The Report is Empty". Does anyone know what I can tweak to get the report running?

Shouldn't an Invalid Character Error tell you the character or its location? Error Messagejava.sql.SQLSyntaxErrorException: ORA-00911: invalid character Error Tracejava.sql.SQLSyntaxErrorException: ORA-00911: invalid character at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:233) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1114) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:691) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1314) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:931) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFiller.run(BaseFillHandle.java:120) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:886) at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:165) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:842) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1731) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1086) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1015) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:908) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:724)

OK< I don't know how many times I went through that wizard and typed a field name there - and never saw the "Add" button. It works now. Works great for a singe value query, Phase 2: Convert to a Multi-Select Query. I've changed the input control to be a multi select query. What do I need to change on the JasperStudio source code and design? For a Single Select Query, the data is successfully generated from: select * from VW_STUFF WHERE VW_STUFF.PLACE = $P{PLACE} For the Multi-Select, I started with:select * from VW_STUFF WHERE VW_STUFF.PLACE IN $P{PLACE}I tried changing the parameter's class from java.lang.String to java.Util.List to java.Util.Collection. None of them generated a report in JasperServer.Then I saw the $X{} reference, and tried:select * from VW_STUFF WHERE $X{IN, VW_STUFF.PLACE, $P{PLACE}}And cycling through java.lang.String to java.Util.List to java.Util.Collection, None of them generated a report in JasperServer. What's the trick to making the Multi-Select work? And having those selected values display in the report.

I have created a report in JasperStudio 5.6. Created a parameter in the report. Uploaded the report to JasperServer. Created the Input Control (using the wizard) on JasperServer using the select with query option, When I execute the report, the Input Control prompt appears, but the text doesn't show. It has the correct number of values, and when I select "OK" it populates the report using the parameter that I chose. I don;t know exactly what I chose, but I can choose different parts of the Input Cntrol box and the report displats different results. Anyone ever seen this before? Have any ideas as to how to solve this?

Is there a tutorial or a list of steps on how to do this - add cascading input controls in JasperStudio?

I have created a report and applied a conditional format/style to a data field. I can change the border color. I can change the text color. The border and text colors change on the correct values. But I cannot figure out how to change the background color. What setting am I supposed to use? Using JasperStudio 5.6 (please don't recommend an upgrade to 6.1).

Below is the image of the report publishing wizard from JasperStudio 5.6.0. The wizard prompts for the configuration of data source and permits the selection of Data Source from Repository, which permits the selection of an ad hoc view. See below: Also, the wizard continues and processes successfuly. On the webside, opening that report in JasperServer displays a report on about 100 pages, which is what I would expect. But the field names are shown and none of the data. I find it hard to believe that ALL of my fields ar not wide enough to display the data. See below:

I created a report in JasperStudio using the One Empty Record data adapter. I used Text Field elements as the fields. I was careful to name them correctly, for example, "ASSEMBLY" with regards to spelling and capitalization. Edit: inititally I entered "ASSEMBLY" in the expression editor. That compiled in Studio and rendered in Server, albeit, it shows the expression text, but the data values. I changed it to F${ASSEMBLY} and that fails to compile in Studio (Field not Found) and doesn't render the report in Server (Report Design not Valid: 1. Field not found...). When I was finished, I Published the report and chose to use a "Local Data Source from Repositiory" with the corresponding fields and field names from a previously created Ad Hoc View. When I click Finish, it processes successfuly. THen I go into JasperServer-Pro and open it. It opens and displays just the field name - and not the actual data. But since it is displaying the page count (Page 1 of 180) correctly, I have to think it is seeing the data rows from the Ad Hoc View. What did I do wrong and what do I need to do to have the data show u in my report and not just the text field names. Do I really need to connect to that database and use SQL to create all of the joins that I need to create the correct subset of data? If so, what's the point of allowing me to connect to a local data source?