hello_34

I am using jasper report 8.0.2 and I have created an adhoc view. In there In the measurements, I am going to create a calculated measure. In the formula, I am trying to convert a double to an integer and I cannot find a relevant build in function. As shown in the image where A , B is an integer C is a double. SO I want to get the output as Integer. Can someone help me?

I am trying to create a new adhoc view and, there I don't see all the domains listed. it has been limited to 100. Following API is calling and limit is set to 100. Ex - /rest_v2/resources?folderUri=%2F&recursive=true& offset=0&limit=100&forceTotalCount=true&forceFullPage=true&type=topic&type=domainTopic&type=semanticLayerDataSource&type=mondrianConnection&type=secureMondrianConnection&type=xmlaConnection&_=1686644885944 I want to increase this limit to 200 and list all the domains when creating the adhoc views. Can anyone tell, is there any xml file for configuration file where I can change this default value

I had the same issue which which converts date format Apr 14, 2023, 09:29:00 PM to Oct 23, 2022, 02:34:00 a when export report to excel with jasper report version 8. I was able to fix it by making following property inside bean id="xlsExportParameters" in applicationContext.xml (WEB-INF/applicationContext.xml) and restart the server. ```<property name="detectCellType" value="false"/>```