Jump to content
We've recently updated our Privacy Statement, available here ×

Akshay Khedkar

Jaspersoft Staff
  • Posts

    34
  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Everything posted by Akshay Khedkar

  1. Hello, Please let me know which REST call you are trying and provide me the screenshot of the issue for better understanding. Please refer the REST api guide for more details: https://community.jaspersoft.com/documentation/v8-v81-v810/tibco-jasperreports-server-rest-api-reference
  2. Hello, Can you please try with our latest jasperReport studio? JasperReport version 6.3.1 is very old and things might have improved in our newer version. Please download and install JasperReport studio from our edelivary site: https://edelivery.tibco.com/storefront/index.ep I hope this will help you.
  3. Token is provided in the response when making a request to "/jasperserver-pro/JavaScriptServlet" endpoint. "FETCH-CSRF-TOKEN" header with value "1" should be sent to the server in the POST request POST jasperserver-pro/JavaScriptServlet "FETCH-CSRF-TOKEN": "1"
  4. Hello Can you please explain me the problem you are facing in more details and please provide me the export of the report for further investigstion.
  5. Hello It could be a bug with JRS 7.1. Actually JRS 7.1 is too old and we have lots of improvements in our newer versions. I will suggest you to upgrade to our newer version and I hope the this problem will be resolved there. https://community.jaspersoft.com/documentation/v8-v82-v820/jasperreports-server-upgrade-guide-820
  6. Hello, Did you get a chance to check our studio user document ? Please refer the chapter 12 from below studio guide, I hope this will help you: https://community.jaspersoft.com/documentation/v8-v82-v820/jaspersoft-studio-user-guide-820
  7. If you have migrated or upgraded Jasperserver from older version to newer one and you started facing problem with certain Ad Hoc Views fail because of the change in the datatype of field or there is mismatch of data type or some fields are missing between domain and adhoc view. In that case changing "jasperserver-proWEB-INFapplicationContext-adhoc-dataStrategy.xml" property "checkSourcesInStrictMode" from true to false might help to resolve the issue. There is one more property "skipCheckSourcesForViews" - When this setting is true, the server will render the view even if some fields are missing for any reason. Both these and simmilar properties are documented in our "Server Administrator Guide" section "Setting the Level of Referential Integrity" > https://community.jaspersoft.com/documentation/v8-v80-v800/tibco-jasperreports-server-administrator-guide
  8. Hello Ruben, The error captured in the log file is- java.lang.NoClassDefFoundError: org/eclipse/jface/databinding/swt/SWTObservables I found some articles which might help you: https://bugs.eclipse.org/bugs/show_bug.cgi?id=580876 https://answers.sap.com/questions/13804134/sap-bw-not-able-to-open-query-in-eclipse-122022-1.html
  9. Hello Claudia, Did you get a chance to check my prior response? Please provide those details for further investigation.
  10. If you have to create a report in jasper studio using excel data: 1. Create data adapter using microsoft excel data adapter option. 2. give name to data adapter connection and pass the location of excel file under File/URL 3. Please find attached screenshot If you have to create adhoc view in jasper server using excel data: 1. Login with superuser. Then choose Create-> Data Source 2. Choose "XLS data source" or "XLSX data source" option under type and add the path along with file name of your excel file. 3. Save the connection. Please find attached screenshot If you have to run a report in jasper server which is build in jasper studio: 1. Right click on the Data Adapter in studio and export it. 2. In Jasper Server right click on any folder then choose Add Resource-> File-> XML and upload the exported data adapter(refer attached screenshot). 3. In Jasper studio add below property- <property name="net.sf.jasperreports.data.adapter" value="repo:/path/to/xml file"/> 4. Then while publishing report to server choose option "Don't Use Any Data Source" when prompted. test.xlsx
  11. Hello If you have build a report using studio you need to have data adapter to run report. Please refer below guide to create data adpter connection: https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v8/data-adapters If you are on Jasperserver you need to create data source connection where you can pass host,port and table name where those fields are present. Refer chapter 4 from below guide: https://community.jaspersoft.com/documentation/v8-v80-v800/tibco-jasperreports-server-administrator-guide https://community.jaspersoft.com/wiki/connecting-jasperreports-server-your-database#:~:text=1.0%20%2D%20Chapter%204.1.-,Introduction,files%20and%20custom%20data%20sources.
  12. Hello Please provide me the jrxml report for which you are getting error and also send me the detailed error message for further investigation.
  13. Hello Ruben, Please provide me the screenshot of the error message on Jasper studio UI. Also let me know studio version which you ere using? Thanks!
  14. Hello Michael, Please provide me the jasperserver.log(jasperserver-pro/WEB-INF/logs) file and the export of the report with legacy key option.
  15. Hello Michael, It appears that your subreport and report are placed in same organization and dashboard is placed in different organization. Please give a try by adding dashboard, report and sub report in same organization. I hope this will help you. Thanks
  16. You will not be able to see materialized view if you are trying to create a domain based on materialized view. by deafult this option is disabled and therefore you will not be able to see materialized view in domain designer tab. Please follow the below steps to enable it: 1. Open file "webapps/jasperserver-pro/WEB-INF/applicationContext-jdbc-metadata.xml" in any of the text editor. 2. add <value>MATERIALIZED VIEW</value> under <property name="tableTypes"> 3. Then save the file and restart the server. Now you will be able to see materialized view in domain designer tab.
  17. Hello If you are compiling report there is no need to select Build Project option. You can simply compile a report on clicking compile button. Please refer the below wiki article : https://community.jaspersoft.com/wiki/compile-older-jasperreports-version-jaspersoft-studio For best practices to create a report in Jasper Studio please refer our user guide: https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v8/getting-started-jaspersoft-studio
  18. Hello, When exactly you are getting this error message? On JasperStudio or on jasperserver? Can you please provide me the complete error message you are getting?
  19. Please let me know which Database you are using and what is the JDBC driver you are using provided by calcite? Did you tried with vendor specific drivers? Please refer the below support platform sheet to check supported databases: https://community.jaspersoft.com/documentation/v8-v81-v810/tibco-jaspersoft-platform-support-guide-community-edition To check the error logs: 1. select Help-> Installation Details-> Configuration-> View Error logs. Please find the attached screenshot.
  20. The issue is caused by the internal SWT browser behaviour still relying (by default) on IE11. Properly setting up the WebView2 component to force use the Edge engine should solve the issue. Steps to resolve this issue: 1. From the official website download the Microsoft Edge WebView2 Runtime. Best solution is to choose the "Fixed version" x64. 2. Unpack the downloaded package to a convenience directory using a tool like 7-zip 3. Edit the Jaspersoft Studio Professional.ini file appending the following two Java properties (replace with the proper WebView files location): -Dorg.eclipse.swt.browser.DefaultType=edge -Dorg.eclipse.swt.browser.EdgeDir=C:\dev\webview Save the file and restart the Jasper Studio. PFA is the screenshot of issue occuring. This problem is occuring with JSS 8.1.1 and there will not be a problem in JSS 8.2.0
  21. By default when a CSV file is opened in Excel, the Excel app uses the System default encoding for the file, and this encoding depends on the operating system So, we need to let Excel know that our CSV file is an UTF-8 file. If you open this csv in notepad it will work fine. The proper way to open such a file is to open first the Excel app and do the following steps: go to menu Data --> Get External Data --> From Text --> choose your CSV file After that the Import wizard will open and you have to choose UTF-8 as File Origin, and Delimited as field separator then click Next and complete the wizard. After that you will see the Rupee symbol in your excel file.
  22. If you want to hide "Select All" option which comes along with date or timestamp filters in adhoc view. you need to make changes in override_custom.css file. It can be hidden by CSS. For example something like this can be used: .pane.filter .all { display: none; } Login with superuser, then you can download your theme and add below css to override_custom.css file: .pane.filter .all { display: none; } Save the file and re-upload it to Jasper Server. And use that newly uploaded theme as active theme. Please find attached screenshots.
  23. If you wants to remove the "Select all" option for date filter as attached screenshots. You can make changes in override_custom.css file. It can be hidden by CSS. For example something like this can be used: .pane.filter .all { display: none; } Detailed steps are: Login with superuser, then you can download your theme and add below css to override_custom.css file: .pane.filter .all { display: none; } Save the file and re-upload it to Jasper Server. And use that newly uploaded theme as active theme.
  24. If you have a MongoDB JDBC connection and JNDI connection created using MongoDB, and domain is created based on this. I have observed that when you add a new field to your collection in Mongodb, same field does not get added in existing domain so every time you need to create a new domain to show newly added field. To resolve this issue- 1. Add "RefreshSchema=true" parameter in Connection Options while creating the MongoDB JDBC data source connection 2. Enable below loggers in JasperServer(Manage-> Server Settings-> Log Setings) - com.jaspersoft.mongodb.jasperserver.MongoDbDataSourceService45 - com.jaspersoft.mongodb.jasperserver 3. After enabling the loggers create a domain using JDBC connection, you will find connection url in your jasperserver.log file 4. Check if the generated data source url contains "RefreshSchema=true" parameter in it. 5. And use that url in context.xml file to create JNDI datasource. 6. After making changes restart the server and check if the fields are getting added automatically in domain
  25. Whenever you perform Rank function in adhoc designer it always provides the rank from smallest amount as 1. And the formula would be: Rank("field") If you want to sort in a way that largest amount to be ranked 1, you can use this formula: Rank("field" * -1)
×
×
  • Create New...