hussainian

Thanks Ramnik. I've already done that.

Hi! Currently we are using Jasper Server CE 3.7 on oracle with Tomcat. The name of the database is jasperserver. Now we want to have another Jasper Server on oracle with different Database name i.e. myreports and on different Tomcat. On both Tomcats, JasperServer is running with jasperserver database. But with new database i.e. myreports, its problematic. I've made changes in Meta-Inf, Web-Inf and Catalina home. But in vain. Can anyone please help. Thanks. AsadUllah.

Well! The work done. I'm using JasperServer to view reports. Now what happens that a very long and odd Stack Trace is printed on the screen. Is there any way to remove this track and print own message? Thanks Lucian. Asad. Post Edited by hussainian at 03/07/2010 11:30 AM

One way I'm doing it is using a function in PrintWhenExpression of all bands. This function in the scriptlet performs the logical part and returns TRUE or FALSE. So if the function returns TRUE, the bands are printed and if FALSE the report seems to be blank white page. Though this solves the problem, but it seems illogical to go through all the report generation process even for the case when the report is not meant to be displayed. So is their any way we can stop the generation process in the start? Thanks. AsadUllah.

Hi! Can we prevent a report to be generated from Scriptlet's beforeReportInit or afterReportInit methods? Thanks. AsadUllah.

Yes, it did. Thanks Lucian.

You can send a parameter to the report using it in Print When Expression of the detail section.

Hi! 1. I'm setting a variable in Report Scriptlet which is displayed in the page header. When I set the variable value in afterReportInit method, the variable is only shown on first page and null on the remaining. When I set the variable in beforeReportInit method, it is shown on all pages except first. And when I set it in afterPageInit, it is shown on all the pages. Can anyone please describe why do afterReportInit and beforePageInit not print on whole report? 2 I've a group in my report with both header and footer. In the case when the group's footer band is displayed on the first line of a page (group's header and all detail on the previous page), the above mentioned variable is not displayed (null) in the page header. Why is it so and how to counter this problem? I've tried putting variable setting statements in different methods. Putting these statements in Detail or Group related methods raises the "maximum open cursors exceeded" exception. Muhammad AsadUllah.

Hi! There are two functions in Scriptlet class i.e. beforeDetailEval() and afterDetailEval(), which as their names describe are called before and after evaluation of Detail band. Is there any function which is called or may be called during the evaluation of detail band. I mean after every single row evaluation. I've a scenario. Lets assume a report End Date Days Remaining Query: Select EndDate from table. Now at every row's evaluation, calculation will be performed that will calculate Days Remaining like Days Remaining=EndDate-(Select CurrentDate from table2) Though this task can be easily performed using query select t1.EndDate, (Select t1.EndDate-t2.CurrentDate from table2 t2) DaysRemaining from table1 t1 But I've some real complex calculations in real which all cant be done on query level. Thanks.

Hi! Kindly tell me how does JasperServer do connection pooling, what is the maximum size of the pool and how can it be increrased. Thanks. Asad.

Hi! Kindly tell me how does JasperServer do connection pooling, what is the maximum size of the pool and how can it be increrased. Thanks. Asad. Post Edited by hussainian at 17/05/2010 03:19 PM

Hi! I want to dynamically change the foreColor of a field based upon the value of the field. For example, a field from the query is STATUS. I want that STATUS to be displayed in color RED when its value is 'V' and the forecolor must be Black when the value is 'O'. Please guide me. Can properties expression do this? Thanks. AsadUllah.

Hi! I'm using JasperServer 3.7. I created a role Test and assigned it to a user say XYZ. Then I assigned Administer Access for all the folders under root. But whenever Iogon to JasperServer with that user XYZ, I get message THE USE HAS NO ACCESS TO THIS PAGE. How can I give access to the role Test? Regards. AsadULLAH.

Thanks All! JasperServer 3.7 with Oracle 10g is up.

Done. Thanks Matt.

Hi! I'm facing some problem while using Resource Bundle. I've added the name of my properties file in my report like this: <jasperReport xmlns="http://jasperreports.sourcefo........ resourceBundle="reportmessages_en.properties"> Then I added this file in JasperServer Repository with the same name and from there I added it to the report unit as a resource. But things not working. Am I doing right/wrong? Please comment. Regards. AsadULLAH.

fbuscema Wrote: yalla.......... In this post http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=54994 are described how to install on Oracle....but i seems not work.....there are some problems in IE for login ad example. Insciallah Insciallah thanks very much. that post was very helpful. I've almost solved the problem. Thanks again. Regards. AsadULLAH.

I've followed the instructions for my JasperServer 3.5. I'm getting the exception BAD CREDENTIALS "11:56:02,944 WARN LoggerListener,http-9080-8:55 - Authentication event AuthenticationFailureBadCredentialsEvent: jasperadmin; details: org.acegisecurity.ui.WebAuthenticationDetails@0: RemoteIpAddress: 127.0.0.1; SessionId: B93C4C6B80CCDB8EE3FFE704B934ACBA; exception: Bad credentials" I've attached all the changed files with this post. I'm using Oracle 10g, Tomcat 6.0, JasperServer 3.5, Firefox on Windows XP. The name of host is "proxy" and the service is "proxy". The username and password for Oracle is "jasperreport". I've checked the JIUSER table from Oracle, it has the the user "jasperadmin" (the schema was created with the later Oracle-3.5.zip with encrypted passwrod). Anyother information required, i'll provide. Regards. AsadULLAH. Post Edited by hussainian at 16/01/2010 12:38 PM

suedonne123! Can you please tell me from where you downloaded JasperServer 3.7 WAR Districution file? I couldn't find it. Regards. AsadULLAH.

Thanks you very much jerzy and lucian. The thing is crystal clear to me now. Regards. AsadULLAH.

What about this then on the same post you mentioned? http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=46764

Well! After googling the net for this issue, I've found that it is possible. But I ould not figure out from where to start and how to go. Can anyone please guide me with step-by-step tasks to perform. Post Edited by hussainian at 15/01/2010 03:53 PM

Hi! Our application is running on Oracle Database Server and to run jasper reports on jasper server, MySQL is also installed. Is it possible to shift jasper server to Oracle rather than MySQL? If possible, what things need to be changed? Regards. AsadULLAH. Post Edited by hussainian at 15/01/2010 11:04 AM

Hi! Please explain. One line "One thing I found with reporting was that JasperReports uses the default fetch size of 25 rows for JDBC. " found at http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=54133 by Sherman and the other "JR reports need to be fully generated before being displayed in a viewer. So the data will be entirely fetched by the time you see the first report page." found at http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=68911&topid=68919 by lucianc I'm really confused.

Hi! Please explain. One line "One thing I found with reporting was that JasperReports uses the default fetch size of 25 rows for JDBC. " found at http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=54133 by Sherman and the other "JR reports need to be fully generated before being displayed in a viewer. So the data will be entirely fetched by the time you see the first report page." found at http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=68911&topid=68919 by lucianc I'm really confused.