nchirr

Thanks Matt for the confirmation. A quick followup - do you know of any format issues/problems, while attempting one such thing. From the original JasperPrint Output to .PDF and also to .XLS? Thanks, Nagesh

Hi, Currently we are creating the report for our users in PDF format. And this is what is actually stored in the Jasper meta data tables. During my research, I am thinking if I had created the report as a JasperPrint object and stored it in the meta data table. Later on, I can export the JasperPrint object into any other format that the user in interested in.. say for example one user might want to export the report into .PDF .. and another user would want to export that report as an Excel report. Can someone please confirm or address this approach please. Thanks, Nagesh

Ravi, Although of not much of direct help... check out the following links for some related discussion/information: http://www.raj2u.net/jasperserver-quick-how-to.html check out section B http://jasperforge.org/website/jasperreportswebsite/trunk/faq.html?group_id=252#FAQ28 look for the question How can I suppress page headers and footers when exporting to XLS? - There in there is a note about extrapolating all of the excel parameters to CSV too. Please confirm if how you have resolved your problem. Thanks, Nagesh

Hi, The objective I am working towards - is make the ROLE_USER not schedule a report generation when they login. How I am doing it: In the "repositoryExplorer.jsp" file I have added the <authz:authorize ifAllGranted="ROLE_ADMINISTRATOR"> for the id='schedule_td' <td> entry. But surprisingly although the user is now not able to see the "Schedule" button in its entireity - the page when loaded is throwing a java error - and there is a constant HOURGLASS that is being displayed. This is not stopping the user from moving around - but hte cursor hourglass is constantly there.. and causing some user dissatisfaction. Any help either 1. to address the objective in any other fashion, or 2. How if any other thing need to be done / or be mindful of when adding the <authz> to the <td> entries in "repositoryExplorer.jsp> Thanks, Nagesh

Thanks Matt... for confirming the limit (not necessarily one - as company 1 would not know of the presence of Company2 as such). Nagesh

Thanks Matt. Yes .. my main question was in regards to using seperate Metadata tables. If you can please clarify, Multi-tenancy although seperates in which group the jrxmls, db connections etc are stored, actually would still store it in the same JSPRSRVR database. Right? For my current needs this is not a must. I have DR ability for my Metadata database in place already. But thinking into the future, I wanted to check if when selling Jasper internally to various application teams - if we can leverage the same installation but completely avoid any data sharing (Metadata - generated output content etc). Regards, Nagesh

Hi, I have a requirement to use the same installation of JasperServer accessing seperate databases for data. In addition just to reduce the risk / data corruption, is it possible to define and use seperate JSPRSRVR databases that would store the report templates, generated reports etc., seperately? Thanks, Nagesh

Hi, Really appreciate if someone can help with this. Did look around quite a lot in Google, but could not find anything that is remotely close to a solution or even a problem acknowledgement. Our users login into JasperServer (3.5.1) inteface to view static (pre-generated) reports. During their movement withint their allowed folders and reports, the 'hourglass' is indiscriminately appearing at its own leisure. Although the users can still be able to click on folder/reports etc., for most users the presence of the hour glass is making them wait for something to happen. Please suggest/help how if anything can be fixed? Regards, Nagesh

Thanks Dude.. Since then I was contemplating on which of the various options is the best. Finally what we are doing is - when the report is created, we also are creating a .pdf version and storing it in the archive. Subsequently we will clean up the Metadata tables with a date parameter (anything older than a certain date are deleted). Thanks for your input. Regards, Nagesh

We did figure it out ourselves... we defined the columns with a 1GB .. There is no problem with the space.. as even though the column is defined as 1GB Blob.. it would occupy only the actual size and noting more. But the 1GB size would allow you to successfully create and store any big report upto the maximum of 1GB size. Thanks, Nagesh

Hi, We are using JasperServer 3.5.1 Is there a maximum size to the report that can be generated in Jasper? Is there a correlation between the maximum size a generated report can be of, and the size of the blob field in the JICONTENTRESOURCE table? Could some one please explain this in detail.. or is it that simple a fact? Assuming there is a direct relation - is it as simple to just change the blob field size (from the current 20971520) to any other size so it can accomodate the bigger report? Or are there any other changes we will need to do to accomodate this? Please help. Regards, Nagesh Code:An error occurred while saving P_SUBM009_Subreport3_MarketLevel_Main-200909120535.pdf into the repository.com.jaspersoft.jasperserver.api.JSExceptionWrapper: org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.DataException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.ContentRepoFileResource]Caused by: org.hibernate.exception.DataException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.ContentRepoFileResource] at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)Caused by: com.ibm.db2.jcc.b.jm: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=3.50.152 at com.ibm.db2.jcc.b.wc.a(wc.java:571)

Thanks Sherman. My next question: Once I generate the reports (scheduled) in .pdf and .xls - is there any way, I can actually move them out of the Meta tables and store them in certain folders on the Server Storage? Here I am thinking about how I might manage the size of the meta tables - and how if I should archive some reports (say older than 3 months) but still store the .pdf and .xls that I already created. Thanks, Nagesh

Hi, Can someone please help me understand how the Jasprsrvr database that is created as part of the install used in and by JasperServer? Can it then exist with the database with the data? The data for my reports currently is currently hosted on UDB. Inorder for me to complete the installation do I have to create this 'Jasprsrvr' database in UDB? or can it be created using MySQL on the application server? Thanks Nagesh