rkm258

Hi, I tried setting up security filter and was successful in running a couple. But there seems to be a misunderstanding on how filterExpression in the resourceAccessGrants is defined. 1. Is the filterExpression a groovy expression like the principalExpression, if so how can i generated a row security filter expression that serves the purpose like below sql filter a. user.user_id in (1,3,4,5,6) where user id is an integer. The values are unkown and will be obtained dynamically. Please let me know how i can achieve this in a filterExpression, may be a list of Interger objects. b. x.thrashed_date IS NULL so as to get only those records which have not been destroyed. thrashed_date is a database column of type timestamp. 2. Is a itemGroupAccessGrants definition mandatory. What if i donot have any column security filter to apply. I ignored that column security filter, but found an exception and hence had to place it in to access grant for my user roles. 3. Is there any documentation to better understand the security file format, syntax for expressions, tutorials. The samples and documentation are not of great help, in providing advanced row filtering on data. Thanks Ram Post Edited by Rama Mukkamalla at 03/26/09 21:13

Hi, Thank you, for reply. I have a question regarding Topics saved from Domains. If the domains have a security filter with resourceAccessGrant and other access grants. Will the saved Topic from the Domains obey these security filters. Ram

Hi, Just wondering what is the next release of Professional version capable of in regard to "domains". 1. Will there be a support to add Custom Report Data Source Service. So that i provide the database connection to use, rather than choose one from JDBC/JNDI data sources. I had been able to do so with using Topics not using Domains, because the 'Data sources selection in Domains pulls only JDBC and JNDI datasources'. 2. Can security filters add dynamic values for filtering. The examples i have seen so far adds only static values. Since it is based on groovy language, i'am assuming this might be possible. 3. What additional capabilities will it have for domains. Thanks Ram

Hi, Multi Select parameters should have type as Collection or Java Array objects not primitive type. I suggest using $X{} syntax since it will take care, when no values are selected as well. Please see jasperreports definitive guide or search in the forum for $X{ which will guide u further. Ram

hi, As far as i have worked on it, it works fine for JasperServer report execution but not in Topics. In topics there seems to be a bug, that is fixed in the next release. Ram

Hi, I tried generating gantt charts using iReport 3.1.2. I'am able to display the activities and their time range. The problem is "identifying task & subtask". How should the result set records be arranged to obtain these values. For ex: below columns are task , subtask, task_startdate, task_enddate,subtask_startdate,subtask_enddate step 1,activity 1";"2009-03-13";"2009-04-01";"2009-03-13";"2009-03-16" step 1,activity 2";"2009-03-13";"2009-04-01";"2009-03-17";"2009-03-19" step 1,act under act 1 of step 1";"2009-03-13";"2009-04-01";"2009-03-13";"2009-03-14" step 1,act desc";"2009-03-13";"2009-04-01";"2009-03-18";"2009-03-20" step 1,ew";"2009-03-13";"2009-04-01";"2009-03-22";"2009-03-28" step 2,act of step 2";"2009-03-31";"2009-04-09";"2009-03-31";"2009-04-02" Ram

Hi, Just wondering, have u noticed the dates decreasing by one day, when set to the query string parameter holders like below where in input control i gave 2000-12-31, and 2009-03-18 for Start and End Date parameters. 14:23:50,041 DEBUG JRJdbcQueryExecuter,Thread-223:206 - Parameter #1 (date_start of type java.sql.Date): 2000-12-30 14:23:50,041 DEBUG JRJdbcQueryExecuter,Thread-223:206 - Parameter #2 (date_end of type java.sql.Date): 2009-03-17 Thanks Ram

Hi, As i said earlier, I used ::date date conversion over timestamp in postgresql, then added a java.sql.Date as the parameter type, for report parameters. This got the report query string, date format for parameter holders ?, to be of the form 2009-03-16. But the problem is that the dates are reducing by one day on using, "input control date types". Thanks Ram

Hi, It seems when u set input control in JasperServer, there are two types of data type available, Date and Date Time. Use the Date type. Also process your result set to get the right date format, like in postgresql u can use ::date over timestamp columns to get in the format u desired. Make sure u set the right Timezone for the user logged in. hope this help Ram Post Edited by Rama Mukkamalla at 03/16/09 21:12

Hi, Firstly, for JS 3.1, ireport 3.1.2 is recommended. Though this might not have caused your problem. Can u be more specific in terms of exception. By the way, i'am assuming u were using repo: syntax to refer to ur subreport in the main report. Do verify the full package scriptlet class name in the 'jasperReport' header tag in the JRXML file. Ram Post Edited by Rama Mukkamalla at 03/16/09 18:20 Post Edited by Rama Mukkamalla at 03/16/09 18:28

Hi, I'am using Firefox, JasperServer Pro 3.1.0.1 professional and Adobe 8. It is working fine, on passing the output=pdf parameter. Ram

Hi, Just wondering is JasperServer Pro 3.5 RC is a full professional release, after 3.1, or an experimental. When will there be a full professional release of 3.5 version. Thanks Ram

Hi, How can a Dashboard be set as the default home. Like the one done for the user 'demo' when logged in. Where do i change configurations for doing so. Thanks Ram

Hi, Just wondering in what ways are External Users/Roles different from internal. I didnot find many difference other that certain user details which are not editable from the JasperServer UI. Also what is the purpose of JIAuthenticationSynchronizer. Thanks Ram

Hi, I didnot use any authentication providers, but i used the userAuthorityService to manage my users and roles. U can look at filters requestParameterAuthenticationFilter and userPreferencesFilter to authenticate user/role and locales/timezone respectively. U can create/update users/roles in JasperServer using the userAuthorityService. let me know if u still need any help. Ram

Hi, I'am not sure if this is possible. But what i had done was, to define a custom authentication filter in the acegi filter chain proxy to manage users,roles and authentication by myself. JasperServer uses daoauthenticationprovider and hence using a metadata repository persistance that uses users and roles in jasperserver database. If what u said is possible, then that's great, but i have not seen any documentation of doing so. Ram

Hi, I would like to know the client class, if any available to access the AdminService webservice present at http://127.0.0.1:8080/jasperserver-pro/services/AdminService?wsdl The webservices guide pdf talks about only the repository,scheduler and domain web services and not about the above one. Sample code will be appreciated. Thanks Ram

Hi, I used web services sample appl, java-webapp-sample, to run couple of reports. I noticed that most of the reports that have graph in particular are resulting in blank pages. Is there any restriction on the width of the report for pdf export to avoid loss of data/truncation/loss of graphs? Thanks Ram

Hi, Since u are working on Web Services, i have a small question for u, can u tell me how to access the Admin Web Service, i'am unable to know how to get the client for it. It is not being used in the sample java-webapp for web services. http://127.0.0.1:8080/jasperserver-pro/services/AdminService?wsdl Will look through your question & get back with an answer. Thanks Ram

check this post http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=50032

Hi, Based on the documentation in ultimate guides, it seems the values in this profile attribute table, jiprofileattribute of JasperServer database, have to be entered manually and cannot be done through the API. Correct me if i'am wrong. Any inputs will be of help, as i need these attributes to define each and every user of my system. Thanks Ram

Hi, I tried updating/adding User Profile Attributes. But i just donot see the changes in the JasperServer database in jiprofileattribute table. Let me know if there is anything wrong that i'am doing. For ex: I tried updating a user's attribute value as below, but i donot see the changes User u = userService.getUser(ctx,userName); List l = u.getAttributes(); ProfileAttribute p = (ProfileAttribute)l.get(0); //Obtained the first attribute p.setAttrValue("newValue"); //New value to a attribute userService.putUser(ctx,u); //Saving changes to user Ram

Hi, It might be that u are using Timestamp type from the database, thus group by JasperServer would not show the right data. Hence in the query change the timestamp to date type like in postgresql using column_name::date Ram

hi, does anyone have answers to my above question Ram

Hi, I had this solved using the userPreferencesFilter defined in applicationContext-security. My question now is, there seems to be fixed tmezones, how can these be extended to include other timezones, other than the below default ones. America/Los_Angeles[/code]America/Denver America/Chicago America/New_York Europe/London Europe/Berlin Europe/Bucharest Ram [/code]