[Report book- individual reports are running 5 times each]

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

[revoConnectR /revoDeployer not able to download]

is there any other way to achieve analytics/ prediction using any othe component that can integrated with jasper studio

 

[revoConnectR /revoDeployer not able to download]

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

 

[HTML5 charts not rendered in PDF format using Talend ETL]

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.

[Date function compile problem]

i have made the suggested change but still not able to achieve the result.. any help.. it still throws the same error.

[Date function compile problem]

 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

 

[What input control type to use for entering multiple values]

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

 

[Jasper throwing error when no data is rendered by the query]

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.

[two or more datapoints to be plotted on the same day in line graph]

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 

[AWS jasperserver becomes unresponsive after editing pg_hba.conf and postgresql.conf files]

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

[AWS jasperserver becomes unresponsive after editing pg_hba.conf and postgresql.conf files]

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.

[Error setting maximum height to a report]

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.. :(

[Error setting maximum height to a report]

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??

 

[how to set y axis range/intervals and min,max limits for html5 charts using jasper studio]

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

[Few words missing in the automated pdf export from jasperserver report]

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

[Few words missing in the automated pdf export from jasperserver report]

not yet @hozawa Thank you.. i ll do right away..

[Few words missing in the automated pdf export from jasperserver report]

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.

[Warning: Problem running post-install step. Installation may not complete correctly]

yeah i am using oracle jdk 8

[Warning: Problem running post-install step. Installation may not complete correctly]

yes i am using oracle jdk8

 

[Warning: Problem running post-install step. Installation may not complete correctly]

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

[Is there a way to import PDF in the JasperServer repository]

@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');

[Does REST API works with jasper HTTPS]

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 

[Upload a pdf file in the jasper server repository using jasper etl]

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!!

[how to connect to jasperserver repository database]

i want to insert pdf from a folder(this will be a daily job). is there a way to achieve this..

[Is there a way to import PDF in the JasperServer repository]

did you achieve this i have a similar requirement now