goyalrich

Hi, When we create a domain, in the Display tab we get the option to change the Data formats for Dates and Numeric fields. That is working fine for Numeric fields, but for Date fields the option it gives in dropdown for vaiable data format is for Numeric field, not for date/time fields. How can I get relevant masks for date fields in Domain Dispaly tab.

Set the proper timezone on the machine where you have installed the jasperreport server. I too got the smae error, resoved it by setting the same timezone on the jasperserver machine as what my database server have.

Nopes it didnt. It could have been useful if I was using iReport. I am creating domain, then I want the localised column values in Adhoc views and reports generated from that domain. I tried using caluclated field as $R(fully_qualified_field_name), but this give the exception, because jasper is not translating it, and sending $R in the query to oracle. Please check if this can be done,

From the stack trace it seems that the SID given in the connection details is wrong. Re- check your connection settings.

I think my quetion has been misunderstood. I am able to loclaise the label, name of the column. But I want to localise the values of the columns..how Can I do that?

How can I use oracle procedure in domains. I want to call the procedure, in such a a way that output of procedure becomes the column of tables.

I got it working. Mistakenly I was not using the fully qualified column name.

Hello, I am using domains to create adhoc views and reports. I have a database fields "Reason", and it has value like resonForIssue,reasonForCancel. This value is stored in DB so that it can be localised on the UI. Now I want to use this field "Reason" in adhoc views and reports. How can I provide it translation? I mean how can I localise the field values? Is there any way?

Hello, I am creating a domain , and I want to use profile attribute in the query for derived table. is this possible? For example in the Derived Table tab cab I create a query like select * from project where project_id = 'profile_attribute_name'. How can we do this? what is the syntax to use? I have tried multiple options but niether f them worked.

Hello, I have created a domain with security , I want to apply row level security to get the restricted data. All users have PROJECT_ID set as profile attribute, I want the user should get the records of their project only. <principalExpression><![CDATA[authentication.getPrincipal().getAttributes().any{it.getAttrName() in ['PROJECT'] }]]></principalExpression> <filterExpression>testProfileAttribute(PROJECT_ID, 'PROJECT_ID')</filterExpression> </resourceAccessGrant> When I am creating a adhoc view out of this domain, I get the data of that project only, but cannot apply addition filters on other fields through adhoc view.What is the soultion for this?

Thanks for help. This worked fine. But I have few questions: 1) This is using SOAP, I have read that soap support for neweer versions has been stopped. 2) Why it is not working with rest url. getting the error which I have posted. Though if I use the same url through the browser directly it gets me the list. That might be because the browser is using "GET" method. Can you please explain how can I achieve this through code.

Hello, I am using rest webservices to list the resources. I am using the same pattern as given in the sample folder. Getting the below error on jasper serverERROR RESTAbstractService,http-bio-8080-exec-8:138 - Method POST is not supported for this object type - request params: Path: /resourcespublic class JasperMain {public static void main(String args[]) {WSClient client = new WSClient("http://10.55.36.70:8080/jasperserver-pro/rest/resources", "jasperadmin", "jasperadmin");List reportList = client.list("/reports"); }} WSClient.javapublic class WSClient { protected JServer server = null; public WSClient(String webServiceUrl, String username, String password) { server = new JServer(); server.setUsername(username); server.setPassword(password); server.setUrl(webServiceUrl); } public List list(String uri) throws Exception { ResourceDescriptor rd = new ResourceDescriptor(); rd.setWsType(ResourceDescriptor.TYPE_FOLDER); rd.setUriString(uri); return server.getWSClient().list(rd); }} Please respond.