michael.mccarthy

hi Thanks for your comment. this doesn't work for me in my situation because: for the user to be able to login in they need to have one of two user roles - user or admin. if they have user role which is lowest ranking role then i need to modify this role as you have mentioned above i have no doubt this will work. that will however mean that all users using this then can't create ad hoc views. i also need to grant a set of users access to create ad hoc views and in that case i would need to give them admin access which i don't want to do - as they don't understand how to create domains etc... i have also tried creating a new role and doing the above and assigning it to user with the user role also however the user role access takes precedent and does not restrict on the new role created. IT seems like its only possible to have 2 sets of users. admins and other (which i can then define as either create ad hoc views or just executing views) Is this correct? thanks Michael

hi Thanks for your comment. this doesn't work for me in my situation because: for the user to be able to login in they need to have one of two user roles - user or admin. if they have user role which is lowest ranking role then i need to modify this role as you have mentioned above i have no doubt this will work. that will however mean that all users using this then can't create ad hoc views. i also need to grant a set of users access to create ad hoc views and in that case i would need to give them admin access which i don't want to do - as they don't understand how to create domains etc... i have also tried creating a new role and doing the above and assigning it to user with the user role also however the user role access takes precedent and does not restrict on the new role created. IT seems like its only possible to have 2 sets of users. admins and other (which i can then define as either create ad hoc views or just executing views) Is this correct? thanks Michael

Thanks for your comment. The link doesn't work however. Its not valid when i click on it. Can you repost please?

Hi All, I can see how to change the permissions folder by folder to read only however the users still have access to create ad hoc reports. I would like the users to have read only access to the ad hoc reports already created and have no access to create reports/ad hoc reports. I can't see how using the roles that are currently present how to do that and i can't assign levels of access when i create a new role. Thanks Michael

the fields are integers and therefore should sum. is there a link to how to create these expressions for calculated fields? i can't find anything on this. also is it not possible to do this in the ad hoc view. i am using jaspersoft server on AWS thanks michael

hi i have a number of fields in my data set which are set to 1 or 0 depending on whether or not it is true or false. i want to sum these together for a partiular day or for a series of days. at the moment i have set the field to be a measure in my ad hoc view but the only options i have are count all or count distinct and neither will sum. alternatively i have gone back to the domain and tried to create a calculated field to do this however i am having no sucess. there are two possible ways this could work - firstly and more easily if its possible to do this in the ad hoc view. alternatively if i could do this in the calculated field section in the domain. do you have a list of expressions that i can use here? its not very clear what type of code i am to use here. i am new to Jaspersoft and trying to use it for reports within my company. Any help would be appreciated Thanks Michael

i cannot see anything to click to allow me to add a screenshot to a comment or an answer on there. there is no attachment button nor can i copy and paste into this box?

​in my ad hoc view i have 2 fields grouped together and this is not reflected when i save it as a report. can you advise how i can do this please? screen shots below