b_basa

Hi Sherman, Can you briefly explain what portlet wiuld means? Is there a sample on how to extend this for liferay? best regards, Benedict

Hi All, I would like to know if jasperserver 3.7 supports webservices the REST way. Is jasperserver using apache axis version 2? best regards, Ben

Hi All, I also encountered this issue right now because there is a requirement to generate reports in Excel and some people I think don't know how to create an auto filter in excel. This would be a great feature to have if we can set a property on the fields to allow it to have autofilter that is specifically for excel only. Do you think this is possible? -ben

hi Lucian is this feature fixed?

Hi All, Thanks for your kind response. I think I have already found out the solution. What I did is this. I scheduled the report for a certain day or certain occurence. Then I tried to get the previous dates by using org.apache.commons.lang's DateUtil. You can literally pass "$P_ScheduleTime" parameter to the DateUtil's add day or date function. This will in turn give you a new date wherein you can pass as a dynamic date parameter.

I am also encountering this bug for xls but for others it works fine. is this issue solved already?

Hi All, I am recently having some problems with the jasper server scheduler. I have created a report with date as parameters it runs perfectly when I run it manually, but when I want to schedule the report I don't know how to get the dates parameters from the scheduler and feed it to the date parameters. Is it possible to get the server scheduler date and use it as the date parameters for the report? -ben

Hi All, I tried migrating the jasper server db from mySQL to oracle. I managed to be able to work the database for oracle, however I have issues with the sequence nextval. In MySQL the ID's/primary keys are autogenerated, however in oracle i have to use some sequence key. The problem is hibernate is always using the sequence "hibernate_sequence". Is it possible for hibernate to use other sequence declared so that the primary key/id's won't have issue when the sequence number currently being used is already inserted? -ben

Hi All, I currently downloaded the jasperserver 3.5.0 community edition and i am trying to migrate the database from mysql to oracle. I managed to create the schema and constraints and transferred the data from mySQL to Oracle. I also managed to change some of the configuration for Oracle such as the connection to jasperdb and the hibernate dialect. I am able to log in properly to jasperserver and view the repository. However when I try to add a folder I get errors like this. 02:26:08,421 ERROR JSErrorPage_jsp,http-8080-3:329 - java.sql.BatchUpdateException: ORA-00001: unique constraint (JASPERSERVER.PRIMARY_32) violated JASPERSERVER.PRIMARY_32 pertains to the unique constraint on JIRESOURCE table, column ID. the log for the SQL i get is this. 02:31:52,781 DEBUG SQL,http-8080-2:393 - insert into JIResourceFolder (version, uri, hidden, name, label, description, parent_folder, creation_date, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?) I wonder why all the values are "?". is there anything I can do to ammend this? thanks alot in advance -ben