dc137654

Thanks Cody, I will try that. Actually, instead of userID, I will pass the user role instead. That should do the trick. Thanks for the help! Derek

I apologize if this is already answered in a different section but is there a simple way of controlling section visibility to certain users of a report? For example, this is what I want to do: 1)In an application, a user clicks on a printer friendly page which passes the User ID as a report parameter 2)In the report, certain sections will be restricted to certain users (access is controlled in the report based on role, which is stored in our database). Is this even possible? Thanks in advance, Derek

Thanks for your reply Lucian/Beth. We spent a day trying to see if it was a simple fix but even after modifying what you suggested (and other pieces), it was still broken. The good news is that there is a copy of Firefox 1.5 available for the user base to access (we are using thin clients) and it works well. I suppose we will just put that as a notice in the login page of jasperserver. Thanks for your help and keep up the good work! Derek

I'd also like to add that all of the export buttons (i.e. as pdf, excel, csv, etc) do not work. Derek

Hi, I tried to migrate from JasperServer 1.2.1 to JasperServer 2.0 and the user interface broke in a couple of places. 1)hitting on ok/apply for the input controls within a report does not work 2)pagination within a report does not work. Viewing the javascript console yields the following error: ====================================================== Error: [Exception... "Component returned failure code: 0x80040111 (NS_ERROR_NOT_AVAILABLE) [nsIXMLHttpRequest.getResponseHeader]" nsresult: "0x80040111 (NS_ERROR_NOT_AVAILABLE)" location: "JS frame :: http://cbsweb-1.canada.sun.com:8081/jasperserver/scripts/ajax.js :: baseErrorHandler :: line 299" data: no] Source File: http://cbsweb-1.canada.sun.com:8081/jasperserver/scripts/ajax.js Line: 299 ====================================================== We have tested this on: Firefox: 1.0.7 for Suse Linux 10.0 Mozilla: *Mozilla 1.7 for Sun Javaâ„¢ Desktop System* I have also tested this on firefox 2.0.0.4 and it works fine. It seems like the new ajax integration points does not play well with the older mozilla based browsers. Migrating to a newer version of Firefox is NOT an option (at least in the time we are to implement this solution to the business). Any help would be greatly appreciated (hopefully it will be a quick fix!). Thanks, Derek

Firefox 2.0.0.4 on ubuntu, JasperServer 1.2.1

Seems like this post is having issues with the escape characters too.:pinch: what I meant to say was: For Q307, I put %Q307% and it worked

wow, what a quick response! :) you are correct about the HTML encoding problem, however, your solution gives me the following error: Error filling print... Error preparing statement for executing the report query : select a.deal_id as deal_id, b.status_name as status_name, a.su_code as su_code, c.eu_name as eu_name, d.nr_5 as net_revenue, a.deal_init_date as deal_submit_date from dealstatus a, nextstep b, customerdata c, financialanalysis d where a.status_id = b.sub_status_id and a.deal_id = c.deal_id and a.deal_id = d.deal_id and a.status_id in (8, 16, 17, 18, 19, 21, 22) and a.deal_id like '%?%' order by deal_init_date which is the correct error since in a prepared statement, you must enter the ? as the entire value i.e. "... a.deal_id like ?" I fixed this by entering the HTML escape for % in the list control on JasperServer. For example, for Q307, I put %Q307% Not a really pretty solution but it worked for me. Thanks for your advice sherman! Derek

Hi, I am having strange issues with JasperServer and my SQL queries. Here is my situation: I want to use an input control that allow users to select the Quarters of the Year i.e. Q107, Q207, etc. This selection will then be used to populate my query. The issue is that the Quarter is embedded within a field (Deal ID) so I will need to use the 'LIKE' operator. Here is my query: select a.deal_id as deal_id, b.status_name as status_name, a.su_code as su_code, c.eu_name as eu_name, d.nr_5 as net_revenue, a.deal_init_date as deal_submit_date from dealstatus a, nextstep b, customerdata c, financialanalysis d where a.status_id = b.sub_status_id and a.deal_id = c.deal_id and a.deal_id = d.deal_id and a.status_id in (8, 16, 17, 18, 19, 21, 22) and a.deal_id like $P{quarter} order by deal_init_date ================================== I can successfully run this when I create a Parameter Prompt from within iReport (I type in %Q107%), however, when I try deploy this report to JasperServer, I get this error: org.springframework.webflow.engine.ActionExecutionException: Exception thrown executing [AnnotatedAction@2ebbbd targetAction = com.jaspersoft.jasperserver.war.action.ViewReportAction@90067, attributes = map[[empty]]] in state 'verifyData' of flow 'viewReportFlow' -- action execution attributes were 'map[[empty]]'; nested exception is org.acegisecurity.AccessDeniedException: Access is denied On JasperServer, I created a list control with the values NAME VALUE Q107 %Q107% Q207 %Q207% etc. When I remove the %, the report runs with no errors (though it obviously does not return any results) Any ideas?