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?

Can someone explain the difference in the 5 options you get when you create a new image element in JasperSoft Stuido And most specifically, can someone provide examples of how to use the "Custom Expression". is the expression used to create the path and name of the image file? (dynamic selection) Or is the expression used (like a Case statment) to select from a set of hard coded image files (resources)? Examples would be great Thanks in advance

one thing i've found helpful is to check your parameter definitions against parameter references in the SQL code. make sure they are all accounted for. i'm guessing that when you run the SQL query in a SQL tool (toad, SQLdeveloper, etc) you're commenting out the lines with the $P{} parameters since they won't run in P/L SQL, so naturally the query will run fine against the database. This is what I do. I can't say for sure this is the soluution to every instance of this error, but as a troubleshooting step it works well for me.

Gunnar, ddid you ever find an answer to this?

ntlong, i think the above is a dead link. i'm curious to know if there is a soluton for a) dynamic element sizing, and b) dynamic element positioning in JS. you can do it easily iin Crystal and it's incredibly useful. i'm surprised that Js doesn't have it as a standard feature. please let me know if you've found an answer.

In Crystal Reports you have the option of putting in hard coded values for x-pos, y-pos, height and width of an object, or you can enter an expression to calculate some or all of those values for an object at report print time, giving the report the abilty to dynamically position and/or size an object when the report runs. In Jaspersoft, you can only enter a hard coded value for these parameters. I need to find a way that Jaspersoft Studio can apply an expression/calculation to x-pos, y-pos, height and/or width Does anyone know how?"

Get yet another thing for me to hate about the Studio too. but to be fair, when i had to transition from Acutate ERDPro to Crystal Reports, i pretty much hated Crystal then too. oh, well, just have to get used to it i supposed. just really irritating.

This is annoying and i'm hoping it's a configurable thing. when i'm working in the Outline, moving elements between bands, etc, as soon as i complete an action, the focus of the Outline jumps up to the top of the tree. for small and simple outlines, this is not a problem, but when i have to scroll down to the bottom of the outline to perform my next step, it's a major PITA. does anyone know how to prevent this behavior?

I reviewed the SQL code in Source and in the Dataset and Query Editor. no trace of those parameters exist

I understand the $X syntax, but what if the parameter is not a required parameter (one that you can leave blank to mean "include everything"? for a single entry parameter $P you would use something like. select <field_list> from <table> where $P{<parm_name>} is NULL or $P{<parm_name>} = ID lf the parameter input is blank, then all records are returned, if a parameter input is speciried, then only the one matching reccrod is returned. how would the NULL condition be handled for $X select <field_list> from <table> where $X{IN, ID, <parm_name>} if the parameter(s) are specified then every record with that ID will be returned. how should the clause be coded to handle the condition if the input parameter is empty, implying "return all rows"? would this work or is it something else? select <field_list> from <table> where $X is NULL or $X{IN, ID, <parm_name>}

sorry, posted in the wrong place, meant this to be in the answers section to continue the thread