raja.shekar

Thank you for you Reply.. I tried to upload a file manually to my ftp.. i found there is a problem with my ftp setting... Once i fix i will post here on my fix. Thank you once again.

i didn't tried to fftping a file manuall to that server.. I am uploading the same file used with other ftp servers.

I am scheduling the jasper reports from jasper server to FTP. When i schedule i didn't get the files in particular FTP. other than that FTP i'm able schedue and i got the files in my FTP. I got the below messages when i schedule for that FTP. i also checked with username and password of my FTP. It looks good.also i have write permission for that user. I tried to connect using the credentials using Fire FTP. i am able to connect it.. i am getting the following message when i schedule the report to FTP. " Subject: The job failed to execute. Review its parameters.Date: TodayComponent: Report SchedulerMessage: Job: ftpjob (ID: 3778558) Report unit: /Reports/Bair_Integration_Reports/Raids_Online_Report Quartz Job: ReportJobs.job_3778558 Quartz Trigger: ReportJobs.trigger_3778556_0 Exceptions: report.scheduling.error.upload.to.ftp.server java.net.SocketException: Connection reset at java.net.SocketInputStream.read(SocketInputStream.java:196) at java.net.SocketInputStream.read(SocketInputStream.java:122) at sun.nio.cs.StreamDecoder.readBytes(StreamDecoder.java:283) at sun.nio.cs.StreamDecoder.implRead(StreamDecoder.java:325) at sun.nio.cs.StreamDecoder.read(StreamDecoder.java:177) at java.io.InputStreamReader.read(InputStreamReader.java:184) at java.io.BufferedReader.fill(BufferedReader.java:154) at java.io.BufferedReader.read(BufferedReader.java:175) at org.apache.commons.net.io.CRLFLineReader.readLine(CRLFLineReader.java:58) at org.apache.commons.net.ftp.FTP.__getReply(FTP.java:310) at org.apache.commons.net.ftp.FTP.__getReply(FTP.java:290) at org.apache.commons.net.ftp.FTP.sendCommand(FTP.java:479) at org.apache.commons.net.ftp.FTP.sendCommand(FTP.java:552) at org.apache.commons.net.ftp.FTP.sendCommand(FTP.java:601) at org.apache.commons.net.ftp.FTP.pasv(FTP.java:952) at org.apache.commons.net.ftp.FTPClient._openDataConnection_(FTPClient.java:755) at org.apache.commons.net.ftp.FTPClient._storeFile(FTPClient.java:565) at org.apache.commons.net.ftp.FTPClient.__storeFile(FTPClient.java:557) at org.apache.commons.net.ftp.FTPClient.storeFile(FTPClient.java:1795) at com.jaspersoft.jasperserver.api.engine.common.util.impl.FTPUtil.putFile(FTPUtil.java:206) at com.jaspersoft.jasperserver.api.engine.common.util.impl.FTPUtil.access$400(FTPUtil.java:36) at com.jaspersoft.jasperserver.api.engine.common.util.impl.FTPUtil$FTPServiceClientImpl.putFile(FTPUtil.java:171) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJobFileSavingImpl.saveToFTPServer(ReportExecutionJobFileSavingImpl.java:208) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJobFileSavingImpl.save(ReportExecutionJobFileSavingImpl.java:92) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:562) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:222) at com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.execute(ReportOptionsExecutionJob.java:49) at org.quartz.core.JobRunShell.run(JobRunShell.java:213) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557) report.scheduling.error.upload.to.ftp.server java.net.SocketException: Connection reset at java.net.SocketInputStream.read(SocketInputStream.java:196) at java.net.SocketInputStream.read(SocketInputStream.java:122) at sun.nio.cs.StreamDecoder.readBytes(StreamDecoder.java:283) at sun.nio.cs.StreamDecoder.implRead(StreamDecoder.java:325) at sun.nio.cs.StreamDecoder.read(StreamDecoder.java:177) at java.io.InputStreamReader.read(InputStreamReader.java:184) at java.io.BufferedReader.fill(BufferedReader.java:154) at java.io.BufferedReader.read(BufferedReader.java:175) at org.apache.commons.net.io.CRLFLineReader.readLine(CRLFLineReader.java:58) at org.apache.commons.net.ftp.FTP.__getReply(FTP.java:310) at org.apache.commons.net.ftp.FTP.__getReply(FTP.java:290) at org.apache.commons.net.ftp.FTP.sendCommand(FTP.java:479) at org.apache.commons.net.ftp.FTP.sendCommand(FTP.java:552) at org.apache.commons.net.ftp.FTP.sendCommand(FTP.java:601) at org.apache.commons.net.ftp.FTP.pasv(FTP.java:952) at org.apache.commons.net.ftp.FTPClient._openDataConnection_(FTPClient.java:755) at org.apache.commons.net.ftp.FTPClient._storeFile(FTPClient.java:565) at org.apache.commons.net.ftp.FTPClient.__storeFile(FTPClient.java:557) at org.apache.commons.net.ftp.FTPClient.storeFile(FTPClient.java:1795) at com.jaspersoft.jasperserver.api.engine.common.util.impl.FTPUtil.putFile(FTPUtil.java:206) at com.jaspersoft.jasperserver.api.engine.common.util.impl.FTPUtil.access$400(FTPUtil.java:36) at com.jaspersoft.jasperserver.api.engine.common.util.impl.FTPUtil$FTPServiceClientImpl.putFile(FTPUtil.java:171) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJobFileSavingImpl.saveToFTPServer(ReportExecutionJobFileSavingImpl.java:208) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJobFileSavingImpl.save(ReportExecutionJobFileSavingImpl.java:92) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:562) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:222) at com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.execute(ReportOptionsExecutionJob.java:49) at org.quartz.core.JobRunShell.run(JobRunShell.java:213) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)" Please help me on this.....

I need to create a calculated field that checks the two condition in "IF" statement of domain designer. Example: field1='RAJ' field2='RAM' so i need to create a calculated field f3 that should check field1 and field2 . that is if(field1=='RAJ' or field2='RAM',field1,'') when i tried to use above statement i am getting the following error "An erorr occured while performing the previous request" Please help me on this.

Hi all, Thanks for the reply. I need to use if statement in calculated fields of domain designer.for single condition it's working. if(a='10',a,b) its working. However i need to check b also. Example if(a='10' or b='15,a,b) it's not working. Please help me on this.

I need to concatenate three string variable as one field while creating the domain using jasper server domain designer. please help me on this..

I need to use case statement in calculated fields while creating the domain using domain designer of jasper server. It would be helpful if i get any suggestion..

Hi Rajesh, No there is no fixed number of callTypes. i just given the sample number of records for some calltypes. they just variable number...and also i need to show the output in pie chart..

Hi Rajesh, I need the results as like follows: CallType CallCount TypeA 250 (Number of records in the domain dataset for the CallTypeA) TypeB 540 (Number of records in the domain dataset for the CallTypeB) TypeC 100034 (Number of records in the domain dataset for the CallTypeC) Like above i need to show the result in pie chart....

Hi dhruvisha, Thanks for your feedback. I am using domain dataset to create the report from iReport. Please suggest how can i create count variable for calltype..

I need to find the count of a field in iReport. For example i need to create a variable called "CallCount" which have count of "CallType" field. So i need to use "CallType" field in Category section of Piechart and "CallCount" variable as measure. So that pie chart will show the call types and its call counts. Please help me on this....

Hi rajesh, Thanks for your reply. i need to find the top10 values using the count. For example i have a field called "CallType" and i have created a variable called "CallCount" which is count of "CallType" field. So i need to use CallType field in Category section of Piechart and CallCount variable as measure. In the above case i need to show in a piechart which consist of only top 10 biggest "CallCount" CallTypes. Thank you once again. Waiting for your valuable comment.

Hi rajesh, Thanks for your reply. i need to find the top10 values using the count. For example i have a field called "CallType" and i have created a variable called "CallCount" which is count of "CallType" field. So i need to use CallType field in Category section of Piechart and CallCount variable as measure. In the above case i need to show in a piechart which consist of only top 10 biggest "CallCount" CallTypes. Thank you once again. Waiting for your valuable comment.

@yananderson I am trying the same method to create a pie chart using html5 chart in iReport. However i am getting the top10 records from the domain dataset But i need top10 records by countwise in a column. Please help me on that...

@melandro.. I too have to find the top 10records using domain dataset..Did you Got it. If yes Please post How?

I need to find the top 10 results records in pie chart by countwise in iReport using domain dataset. Please Can anyone help me on this.. Immediate response would be more helpful

I created the view using jasper server domain . i need to give multiple text values as input to filter the records in view. but when i tried to give multiple values with comma separated its not filtering.. Please give some thoughts about it. If someone helps asap it will will be helpful. Thanks, Raja shekar