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

avinash.eng18

Members
  • Posts

    43
  • 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 avinash.eng18

  1. i have created a report book using two reports one report consists of crosstab(a) and another consists of table data(b), i have successfully created a report book but each report is getting generated 5 times in a sequence a,b,a,b,a,.. like this Any Suggestions
  2. is there any other way to achieve analytics/ prediction using any othe component that can integrated with jasper studio
  3. Hi I need to use prediction models in my reports and hence need to access revoConnectR jar but i am not able to download the component and the exception i receive is access denied. Can anyone help me on this. url i am trying to access is: http://community.jaspersoft.com/project/revoconnectr-jasperreports-server
  4. I have been trying to generate pdf report from TALEND ETL, but its generating only blank PDF evertime , with multiple components like tjasperReportExec, tJasperServerExec and I am using 6.3 jasper server professional edition.
  5. i have made the suggested change but still not able to achieve the result.. any help.. it still throws the same error.
  6. have a report (javabean collection datasource) which uses a date function - DATEFORMAT($F{meetingDate},"EEEE dd MMMM yyyy"). The report runs fine in eclipse and if I remove the function it runs properly through java. With the function I get the following errors though net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. The method DATEFORMAT(Date, String) is undefined for the type ****** value = DATEFORMAT(((java.util.Date)field_OBSDate.getValue()),"EEEE dd MMMM yyyy"); //$JR_EXPR_ID=10$ <--------> 2. The method DATEFORMAT(Date, String) is undefined for the type ******* value = DATEFORMAT(((java.util.Date)field_OBSDate.getOldValue()),"EEEE dd MMMM yyyy"); //$JR_EXPR_ID=10$ <--------> 3. The method DATEFORMAT(Date, String) is undefined for the type ******* value = DATEFORMAT(((java.util.Date)field_OBSDate.getValue()),"EEEE dd MMMM yyyy"); //$JR_EXPR_ID=10$ <--------> 3 errors My required date formatt is MM-DD-YYYY HH:mm:SS
  7. i belive you are creating the report using studio and declaring a parameter in the studio. If my above assumption is true you can keep the parameter datatype as java.util.collection this will let the user to enter one or more values in the parameter which is created in the jasper server
  8. I have a query to display errors occured in the last 5 days in a test case(assume), some times i dont get any error. and in this situation when i try to generate a error details as usual, JasperServer is throwing an error stating"Error executing SQL query" but doesnt throw any error when run through jasper Studio Anyone have faced similar situation!! Appreciate help on this.. Note: i tired using when no data property but of no use.
  9. I have a requirement, where in I need to plot a graph(date vs values). On some of the days i get more than one value per day. How do i handle this
  10. hi @hozawa, thanks i have checked if postgresql is up or not and it was down and when i checkd the postgresql log file it says there was a permission level change on those config files. So i reverted the permission back to the postgres user and then tried to restart it worked!! Thanks @hozawa
  11. Hi i actually needed to access jasperserver's associated postgresql and hence changed the postgresql.conf and pg_hba.conf files. soon i change them (as ec2-user) the jasperserver became unresponsive and started thrwoing error 404 resource not available. Later i reverted the changes but still the jasperserver is responsive. I didnt take a snapshot before changing my bad! note: I have checked the catalina.out and it was saying connection refused as error/exception. any help on this is much appreciated.
  12. i tried changing the height in the right bottom pane by selecting the page already but it doesnt allow me to keep the length as such mate.. :(
  13. I have a report where in the the report will be consisting of 32 different html5 line charts so it would require almost 450cm space so that none of the chart details missed. Do i have an option of increasing height of the report to 450cm??
  14. Hi i need to change the default y-axis interval chosen by the jasperstudio, and need to set custom interval or range for the y-aixs. how to achieve this. is there a property i need to enable or any a code i need to attach in the jrxl. Appreciate suggestions and solutions. thanks
  15. I have followed the link given and imported times new roma normal font and installed it(earlier i was using Sans Serif normal), After the import of timesNewRoman font and updating it and published it to the server. After this the report itself didnt work saying it doesnt have the font. (i have followed complete procedure in the attached link). When i do a manual export of the report to pdf i dont have any words loss. But the loss of words is happening when i am generating pdfs automatically using TALEND ETL and tjasperserverexec component. I dont know if there is a bug in the component or export!! can you pls help me on this @hozawa
  16. I need to schedule report exporting for a particular department which needs to run daily. And each day the list of employees for that department changes. So i am using Talend ETL to schedule this job and save the pdfs in a particular folder in my local. But the problem is, while creation of pdf from the server it is missing some of the data and generating pdf!!! though complete set of data is available in the report?? I am using Jasperserver 6.3 Talend ETL community 6.01 and tjasperserverexec component to trigger pdf export. Can any one pls suggest how to fix this words missing in the automated export of reports. Thanks in advance.
  17. Hi, I trying install the JasperReportServer(6.3 CP) on RHEL 6.9 But when finish installation i receive the error below: Warning: Problem running post-install step. Installation may not complete correctly Error running /opt/jasperreports-server-cp-6.3.0/apache-ant/bin/ant import-ce -DimportFile=install_resources/export/js-catalog : BUILD FAILED /opt/jasperreports-server-cp-6.3.0/buildomatic/bin/import-export.xml:352: The following error occurred while executing this line: /opt/jasperreports-server-cp-6.3.0/buildomatic/bin/import-export.xml:135: Java returned: 255
  18. @ernestoo it worked super cool.. and its quite intresting, I just wrote a function for import and the hack around is really helpful. thanks.. function: as superuser: create or replace function bytea_import(p_path text, p_result out bytea) language plpgsql as $$declare l_oid oid; r record;begin p_result := ''; select lo_import(p_path) into l_oid; for r in ( select data from pg_largeobject where loid = l_oid order by pageno ) loop p_result = p_result || r.data; end loop; perform lo_unlink(l_oid);end;$$;then: insert into my_table(bytea_data) select bytea_import('/my/file.name');
  19. Hi team, we need to upload a file to jasper server, and we use HTTPS (secure connection), is there a way to achieve it? I came across a link stating it is compatible only for HTTP!!! http://community.jaspersoft.com/wiki/getting-started-rest-web-service-api
  20. Update JICONTENTRESOURCE set data = bytea_import('C:UsersavinashpoDesktopDMtestsetAvinash.pdf')where id =20667; I am using this query in jasperETL to upload a specific file. but jasper doesnt allow absolute path in query. is there any way to achieve this. Thoughts/ trails/soultions appreciated. Thanks in advance!!
  21. i want to insert pdf from a folder(this will be a daily job). is there a way to achieve this..
×
×
  • Create New...