beekerc69

what if the input control is a SQL query?

i see the answer below that requires modification to a file on the jasperreport server. i don't have this luxury. i don't have access to the server and the admins will not mofidy any files. how do i force the column headers to display, but do so in the .jrxml code? Thanks

I'm having the same issue. Tried both DIME and MIME. didn't make a difference

I have a need to copy/move/migrate ad-hoc views from one JasperReports server to another (from a DEV environment to a PROD environment). Everything i've found on the internet and in this forum says to use the import/export capablity of the Web UI after logging in as superuser. This option is not available to me and will never be available to me, so please do not tell me that i need to get that access as superuser and follow the posted instructions. it's not going to happen. I can only login as an Organization user with ROLE ADMINISTRATOR rights. The thing is i was not the original Ad-hoc View author so i don't know how it was built or anything about it (other than i need to copy it), but unlike Reports and other objects, there is no right-click Edit option for Ad-Hoc Views to find out how it's build and how it can be recreated. Can anyone walk me through the steps to look at an Ad-Hoc View to gather what is needed so it can be re-created in on another JasperReports server? Please understand that my competenecy is with Jaspersoft Studio reports and not Ad-Hoc View creation, so please make the steps very basic. Thanks in advance.

based on the replies and some other research, i've got one more option. Select * from ( with xyz as (select.....) select from where ) in this form, you can still use with/as constructs but it complies with the rule that word SELECT must be first . this would be useful when changing the server SQL validation is not an option.

You are correct, Tomcat is for JasperReports Server. I have both installed on my laptop (running Server 2008). I am talking specifically about Jaspersoft Studio 6.1 (which requires Java only).

I'm running Jaspersoft Studio 6.1.0 on Windows Server 2008 R2 Installed a month ago, it ran fast and rendered previews quickly now it can take 10 to 20 seconds between clicking an object and the object box getting highlighted. clicking or tabbing between property boxes is equally slow and painful. in addition, sometimes when i click on an object it doesn't "highlight" with the corner and edge handles, but the object outline glows orange/yellow, but it is not selected. . THis happens a lot. I am running the current version of Tomcat 8 and Java 8 How can i troubleshoot performance?

what would be the proper method to insert the formatting in the expression editor. sspecifically becuase one wants to mix both a formatted number and a formattted date in the same text field box? Thanks

I'm converting several reports from Crystal to Jaspersoft that have SQL queries that us the With/As clause before the acutal Select statement is encountered. While this seems to work in Jaspersoft Studio - meaning i can see the report in Preview mode, it appears that JasperServer doesn't like it. i get a 6632 error. in one case, i was able to move the With/As clause queries down into the From/Join section and make it work, but i know there will be queries where i won't be able to do that. is there a way to get JasperServer to work with the With/As clause?

I have written several reports, with subreports. they run fine in Studio 6.1.0. When the report is published, I go into report on the Report Server and point the Input Contols to the Repository Input Controls and Queries and confirm the DataSource. but after selecting the Inputs, the first page renders but then i get this error. Is there a simple root cause for this error? or what is the best way to troubleshoot this?

I am trying to publish a report from Studio 6.1.0 to Jaspersoft Reporting Server 6.1.0. I have successfullly published before and am needing to update/republish as i continue development. Normal progress is to pick the destination location in the Repository, review the identified resources, confirm the DataSource and click Finish. now i'm getting an error The error Detail text is java.lang.Exception: The Server has returned an error with code 1 and with the message could not update: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource#5416121]; SQL [update JIResource set version=?, name=?, parent_folder=?, childrenFolder=?, label=?, description=?, resourceType=?, creation_date=?, update_date=? where id=? and version=?]; constraint [sC51622PPMRPTP122S.SYS_C001057672]; nested exception is org.hibernate.exception.ConstraintViolationException: could not update: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource#5416121] at com.jaspersoft.ireport.jasperserver.ws.WSClient.putReportUnitResource(WSClient.java:617) at com.jaspersoft.ireport.jasperserver.ws.WSClient.modifyReportUnitResource(WSClient.java:552) at com.jaspersoft.studio.server.protocol.soap.SoapConnection.addOrModifyResource(SoapConnection.java:266) at com.jaspersoft.studio.server.protocol.ProxyConnection.addOrModifyResource(ProxyConnection.java:311) at com.jaspersoft.studio.server.publish.Publish.publishResources(Publish.java:196) at com.jaspersoft.studio.server.publish.Publish.publish(Publish.java:65) at com.jaspersoft.studio.server.publish.wizard.Publish2ServerWizard$3.run(Publish2ServerWizard.java:302) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121) Where do i begin to troubleshoot this kind of error.?

i have the same problem in Studio 6.1 adding the above code to Print When did not fix it

follow up question i have published reports with sub-reports from Studio to Server. sometimes they show up as a resource just like you suggest, however, sometimes none of the sub-reports show up in the Resoruce list. when that happens, how does one correct it?

Thanks Hozawa any chance you could post an example or two? thanks

Can you use an expression to evaluate data and print a particular image file? currently, i have 3 images Red, Yellow and Green (standard grapic stoplights) i stack all 3 at the same X & Y position. for the red one, i set the Print When Expression to $F{STATUS} == 3 for the yellow one, i set the Print When Expression to $F{STATUS} == 2 for the green one, i set the Print When Expression to $F{STATUS} == 1 but this means placing 3 (or in some status displays, as many as 8) icons. I'm hoping there's a way to build an Expression to evaluate one or more dataset fields and have the image resource to be displayed to be determined by the Expression. Can this be done?