anandharaj

As far i know, only Excel, CSV and PDF exporter are available for customization in XML file

Hi Lucianc, Thanks for the updates.. will do the test. For others, you may check my website on the installation guide for JS-3.5 on PostgreSQL-8.3 at http://www.raj2u.net/jasperserver-35-with-postgresql-83-on-linux.html . Your comments and feedback are most welcome. Post Edited by Anandharaj @ Raj at 03/24/09 15:35

Actually what are you trying to do?

Hi Guys, Im porting JS 3.5 to be run on Postgres 8.3. When i create a user, im getting an error due to SQL error. ERROR JDBCExceptionReporter,http-8080-2:78 - ERROR: column "this_.username" must appear in the GROUP BY clause or be used in an aggregate function The SQL being executed is: select count(*) as y0_ from JIUser this_ left outer join JITenant tenant1_ on this_.tenantId=tenant1_.id where this_.tenantId is null order by this_.username asc, tenant1_.tenantId asc The same thing happening when create new role. Basically the entries added to database, it just that not able to display in UI due to the "order by" clause Note: Im still using default hibernate and oid column. Will do the changed here later. Post Edited by Anandharaj @ Raj at 03/24/09 04:31

OK, you are welcome :-)

I'll post the sample later as i dont have it now. In generally, you need to define the parameter as "collection" data type and your SQL should be: WHERE status IN ($P!{parameter})

Hi kuzman, you can use the script from my website http://www.raj2u.net/jasperserver-installation-on-linux.html This DDL script is based on JS3.0 there were slight changes on data type - type "oid" is changed to "bytea". If you installing fresh JS, thn just simply rename "oid" and create the schema. Also, you need to change the hibernate properties. Read all the comments posted in my blog

Hi mdjj, nice hints.. This is something that our Admin can implement in JS as default

Hi guys, this feature already requested. Therefore i'll mark ID3669 as invalid. Please refer to ID:3506

Yes, "archiving" is not yet supported in report scheduling

Hi, as far i know, JS will always display the first value as default. Perhaps, try to set it as "mandatory"

You can do the changes using iReport via JasperServer plugin.

Hi, It is useful if you provide the error message. BTW, in my website also have JS DLL script for Postgres.That is for JS v3 but you can use for JS3.1 as there were no changes in DB in JS3.1

Yes, im clear. In a general view, this is not possible, but probably might have some "method" to do this.. perhaps our JS Admin can answer you.

Do you mean to pass the parameter (input control value) to a report?

Hi yashdeep, #1 - Its requested long time ago - everybody is awaiting for this :-) #4 - Already available in JS - JRVirtualizer. But its has problem for non-paginated reports. Refer Tracker at http://jasperforge.org/tracker/index.php?func=detail&aid=3651&group_id=112&atid=376 Hi developerdude, Will take a look at Quartz website

Hi Sridhar, i think you dont have clear picture about JasperServer (JS). JS is a web container which need to be deploy into Java Servlet (Tomcat / Jboss / Weblogic). JS also need a DB to store its metadata (MySQL, PostgreSQL, etc). JasperReports (JR) is a engine to produce the reports, therefore its included in JS. iReport is a tool to design the report. So, please make sure that your JS is running fine and then start designing the report in iReport -> upload into JS -> Run report in JS www.raj2u.net Post Edited by Anandharaj @ Raj at 03/20/09 01:21

Hi developerdude , very good suggestion. I'll share my comments as well. #1 - Yes, this is important and good to have. In my case, i have put this version next to title #2 - Ya, good suggestion. Sometime i will go back and check again the report name :-) #3 - That is the reason i always name it same as my actual xml file name. #6 (1) - Good suggestion. New things for me to learn #9 - Yes, JS have improve by sending error message to scheduled report recipient, but i have requested to enhance this feature. Refer to "Tracker" #10 - You can use "NoData" band section to write custom messages and display to user if the report is empty. Post 2 -(b) - It is not make sense to change a file extension (eg: *.xls to *.zip), but it really have meaning changing *.csv to *.txt Even my current requirement is to generate a txt file with some field delimiter (actually a CSV file just the extension is .txt). So, to make it more useful, i would love to see all report export option (eg: csv-> field delimiter, xls-> remove blank row) to be available in UI, so that i can set right in UI instead editing the xml file . This can be extend to create more report export with different option. Meaning, i'll choose "CSV" as report type and set option "delimiter" as "|" and name it as "CSV 1". Then create the same type with "," as delimiter and name it as "CSV 2" One more suggestion, if somehow the report fail to generate/send email, JS will re-try for n times before it concluded as "fail" and notify the JS admin. Post Edited by Anandharaj @ Raj at 03/19/09 01:48

If you set timezone for "datasource", please remove it.

Actually i dont know much about scriptlet, that the reason i created own java class

Yes, you can use your own java method and call it in jrxml file. Im my case, i've created a java package (make it jar file) and put in JS/Tomcat lib folder. You also can use "scriptlet" to write your method..

Hi Sherman, Thanks for the info. Its really something nice to have especially to limit the report by "timeout"

Yes, im still using JS 3.0 and its work fine.. Perhaps you can post your jrxml file here

closing

Similar request at http://jasperforge.org/tracker/index.php?func=detail&aid=3506&group_id=112&atid=376 Marking this as invalid, further notes shall be updated there.