jlarkin_1

Now I've copied the input and pasted it into another directory. Same result.

Now I've reused the site_id parameter and the query used to set up the other location select box. When I tried to use them. I get a hidden error that site_id is missing and it's defaulting to null, resulting in no locations populating despite site_id existing and having a value. So I deleted site_id and created one local to the report, same result. So I deleted the location selector and rebuilt it, same result. So basically, what I've learned is that in JasperReports, the iFrame interface, and input control reuse are mutually exclusive for all inputs that are more complicated than a text box or calendar. Wonderful.

The first set of input controls that threw the security error had a query embedded in the input control definition and that query relied on the site_id parameter. So I decided to try another way: I set up the query for the input controls and then assigned the query in the input control definition. Same result.

Have you edited the original image in an image editing program to see if perhaps what you think should appear white is actually transparent? The default transparency color is grey, so it's possible that the area in question is supposed to be transparent but that isn't working as expected. Sorry if you've thought of this already. It's really a "second pair of eyes" sort of answer on my part. :)

tl;dr: I am trying to reuse an input control that relies on another input control and get a security error when I try to. I have a series of reports that in our existing site use a single form, since the filters for the report are the same. Several of the filters are based on a parameter that will be passed into the report, which is effectively the identifier for the domain that is calling the report. It is a security feature that we filter this information by the domain. For the sake of demonstration, I'll call this parameter p_siteid. It is used in the queries embedded in the admin's definition of the input control. I set up and tested the first report, creating several input controls that rely on p_siteid. Eventually, I realized that there were some organizational issues in the tree, so I created a folder named "relies on p_siteid" and I moved all of the input controls that rely on p_siteid into it. Magic happened, everything was fine, yay. Then I realized that there was an additional organizational problem in the tree and I created a folder for the set of reports that I was working on. I moved the report into that folder, magic happened, everything worked, yay. Then I tried to create the second report. I saved the .jrxml as a new file name. The I went to the jasper admin to set up the report. I did the first setup page, uploading the second .jrxml file. On the input controls page, I added a control for p_siteid. Then I tried to add the first of the input controls that relies on p_siteid. I got the following error: An error has occurred. Please contact your system administrator. (5321) It works to reuse an input control from the original folder that doesn't rely on p_siteid. I searched for this error message and found that this is a security error and that I should check the logs. The logs say: 2013-03-27 13:10:26,364 ERROR Validator,http-8080-2:408 - [sECURITY FAILURE context=inputControlPath-Create_AdHoc_InputControl_context, key=inputControlPath, type(URLNoProtocol)=^[p{L}p{M}p{N}p{Pd}p{Pc}p{Po}p{Pi}p{Pf}:/%.s]*$, input=/organizations/organization_1/datatypes/Input_Controls/dependent_on_p_siteid/p_location_id_list, maxLength=100, isBlacklist=false] I really don't know how to read this message and I don't know how to fix or get around this security error. I should be able to reuse the input controls or there's really no reason for them to exist outside of an individual report. Perhaps I need to create p_siteid as an input control that's in the tree instead of having individual p_siteid setup in the reports. It just seems silly to have a reusable input control for a hidden text box. Does anyone know how I can fix or get around this? Thanks!

I know that this is really a long shot, since I've asked in more relevant channels already to no avail, but does anyone have a ColdFusion translation of the PHP sample app or an already built CF interface with the Jasper 5 webservices? I'd prefer to reuse existing code, obviously; I'm on CF 9. I'll translate it myself if I have to but it will be a larger task than I have time on my plate for right now. Crossing my fingers! Jen

I have a website with an existing form that I wish to reuse with JasperReports, even if only for a demo phase. To take a shortcut, we are using the iFrame integration. I can pass parameters from the web app to the iFrame to filter the report and all is well. Except... We have a multi-select box in the existing form. It generates a comma-delimited list of IDs to filter by. I have set up my query to use $X to manage the filtering list and this works in iReport, where I have set the parameter class to java.util.List. When I move the jrxml up to the server, this no longer works. I have tried deleting the parameters set up on the server and then the filter just doesn't get implemented because the value is null. I have tried creating the parameter on the server as a string and I get an exception that "the value must be an array or a collection." I have tried not using $X and I get an error that the value isn't an integer. I have not found a way to enable a list parameter that ACCEPTS a passed in list, as opposed to one that displays a select box to the user. I would prefer to not have to recreate the entire form, which will be complicated to recreate, especially since we already HAVE the form working. There are actually 5 form fields affected by this problem in this form alone and 4 of them involve munged data. How can I pass a comma-delimited list to an IN clause in SQL via URL variable? Thanks!

I've noticed a couple of areas in which having set things up in the jrmxl in iReport doesn't make that information available after the jrxml is uploaded to the server. For instance, I enter the query in the jrxml and then I have to enter it again in the server admin. I set up parameters and then have to set them up again in the admin. This seems wrong; it seems like this information should be added to the server as well, but maybe that's not supported. Is this expected behavior? I can get around the problem with the query pretty easily for now but I haven't figured out how to set up default value expressions for the parameters on the server. I have things that work in the iReport interface that don't work on the server and this is complicating my ability to debug. Thanks for the help!