spiker_bang

Hi, we have installed jasper server in oracle DB. Now we are planning to move to vertica DB, can I able migrate to vertica? or can I install new one in vertica? Currently we are storing jasper reports in oracle DB as BLOB. can we able move that functionality to vertica(as vertica will not support BLOB)? -- Koteswar.

I am able to schedule a report using webservices and able to retrive list of scheduled reports. now is it possible to get scheduled report output data into some object? If possible let me know the API for same. Thanks in advance.

I am able to schedule a report using webservices and able to retrive list of scheduled reports. now is it possible to get scheduled report output data into some object? If possible let me know the API for same. Thanks in advance.

Hi, check the below code. I am making webservice call to schedule a report to run after 5 mins. but this report is running immidiately. how to avoid that?? Thanks. Code:JobSimpleTrigger trigger = new JobSimpleTrigger(); trigger.setOccurrenceCount(1); Calendar calendar = Calendar.getInstance(); System.out.println("current calendar --->" + calendar) ; calendar.add(Calendar.MINUTE,5); System.out.println("After calendar --->" + calendar) ; trigger.setStartDate(calendar); trigger.setRecurrenceIntervalUnit(IntervalUnit.fromString(jr.getIntervalUnit())); job.setSimpleTrigger(trigger);

Hi, check the below code. I am making webservice call to schedule a report to run after 5 mins. but this report is running immidiately. how to avoid that?? Thanks. Code:JobSimpleTrigger trigger = new JobSimpleTrigger(); trigger.setOccurrenceCount(1); Calendar calendar = Calendar.getInstance(); System.out.println("current calendar --->" + calendar) ; calendar.add(Calendar.MINUTE,5); System.out.println("After calendar --->" + calendar) ; trigger.setStartDate(calendar); trigger.setRecurrenceIntervalUnit(IntervalUnit.fromString(jr.getIntervalUnit())); job.setSimpleTrigger(trigger);

Hi, check the below code. I am making webservice call to schedule a report to run after 5 mins. but this report is running immidiately. how to avoid that?? Thanks. Code:JobSimpleTrigger trigger = new JobSimpleTrigger(); trigger.setOccurrenceCount(1); Calendar calendar = Calendar.getInstance(); System.out.println("current calendar --->" + calendar) ; calendar.add(Calendar.MINUTE,5); System.out.println("After calendar --->" + calendar) ; trigger.setStartDate(calendar); trigger.setRecurrenceIntervalUnit(IntervalUnit.fromString(jr.getIntervalUnit())); job.setSimpleTrigger(trigger);

Hi, Is it possible to create generic jrxml instead of individual jrxml files? Ex : (Part of jrxml file) <parameter name="ageParam" class="java.math.BigDecimal"/> <queryString> <![CDATA[select * from employee where sal > 20000 and age > $P{ageParam}]]> </queryString> assume here ageParam :25 If I use this jrxml file, we can use this only for different age's instead of this, is it possile to use like 1) <parameter name="queryParam" class="java.lang.String"/> <queryString> <![CDATA[$P{queryParam}]]> </queryString> assume here queryParam : select * from employee where sal > 20000 and age > 25 or 2) <parameter name="selectValue" class="java.lang.String"/> <parameter name="fromValue" class="java.lang.String"/> <parameter name="whereValue" class="java.lang.String"/> <queryString> <![CDATA[select $P{fromValue} from $P{fromValue} where $P{whereValue}]]> </queryString> assume here selectValue : * or name,sal,age,desig,bu fromValue : employee whereValue : sal > 20000 and age >25 Is it possible to create dynamic templates then static ones, which can be possible with cristal reports??

Hi, I have login with jasperadmin and created report using jrxml in /reports/sample/ folder. I got the result. created another report using same jrxml file with same credentials in /reports/custom/ folder. But, this time if I run the report, got 'The report is empty.' msg. what might be the reason to get empty report???

Hi, Is it possible to create generic jrxml instead of individual jrxml files? Ex : (Part of jrxml file) <parameter name="ageParam" class="java.math.BigDecimal"/> <queryString> <![CDATA[select * from employee where sal > 20000 and age > $P{ageParam}]]> </queryString> assume here ageParam :25 If I use this jrxml file, we can use this only for different age's instead of this, is it possile to use like 1) <parameter name="queryParam" class="java.lang.String"/> <queryString> <![CDATA[$P{queryParam}]]> </queryString> assume here queryParam : select * from employee where sal > 20000 and age > 25 or 2) <parameter name="selectValue" class="java.lang.String"/> <parameter name="fromValue" class="java.lang.String"/> <parameter name="whereValue" class="java.lang.String"/> <queryString> <![CDATA[select $P{fromValue} from $P{fromValue} where $P{whereValue}]]> </queryString> assume here selectValue : * or name,sal,age,desig,bu fromValue : employee whereValue : sal > 20000 and age >25 Is it possible to create dynamic templates then static ones, which can be possible with cristal reports??

Hi, I have login with jasperadmin and created report using jrxml in /reports/sample/ folder. I got the result. created another report using same jrxml file with same credentials in /reports/custom/ folder. But, this time if I run the report, got 'The report is empty.' msg. what might be the reason to get empty report???

Can we deploy jrxml file into jasperserver using java code instead of manual deploy?? Please let me know any example link if we able to do so. Thanks in advance.

Hi, I am able to export/run report dynamically using Java and .jrxml files using JasperReports-3.5.2. I would like to know, whether we can able schedule those reports? If it possible then please let me know the API for the same. -- spiker_bang.

Thanks dude. I will check it. thanks again... /tools/fckeditor/editor/images/smiley/msn/regular_smile.gif

Hi all, I would like to jasperserver report data to save in csv file using java API. It is possible to do the same with java API??? If possible can you provide sample link/code for the same?? Thanks in advance.

Thanks mate. My understanding is that we have java API to run jasper report using java. But we are not having any API to schdule a jasper report. But we have other options to achive this. like using scheduled threads or timers or other 3rd party libs like Quartz. Is my understanding is correct?? If we are not having any java API to run jasper report, then are we having any java API to save data into any csv or xls file and store at specified path?? If we have such a option in API then can you provide the which is class is useful or sample code/link for the same?? Thanks in advance.