fcramy

Lucian, this all makes me wonder why it doesn't use EST when EST is selected both on the login screen and under the datasource configuration

PERFECT! Thank you, Lucian.

another twist in the puzzle (see attachment)

can you describe exactly how you went about "blanking the time zone setting for the data sources used in JasperServer."? Hate to try and resurrect a dead thread but i've also posted here: http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=107&topicid=77176 with no response.

so i've found this: http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=47753 which points to this: http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=45272 which effectively says this: Resolved the problem by blanking the time zone setting for the data sources used in JasperServer. Apparently if this is left blank on the data source config, it will use the local time zone (since I am 7-8 hours from GMT, the time difference calc's were resulting in dates being one-day off). how do I go about "blanking the time zone setting for the data sources used in JasperServer."?

My biggest single gripe about JasperServer is that it flat out behaves differently than JasperReport (specifically, jasperreports developed in iReport). The problem I'm seeing now is that dates are displayed as one day prior (in fact, exactly 4 hours prior) to the date put into the parameter. this is what I put into the default value expression of the JRXML: ((new Date().getMonth() / 3) + 1 == 1)? new Date(new Date().getYear(), 0, 1) : ((new Date().getMonth() / 3) + 1 == 2)? new Date(new Date().getYear(), 3, 1) : ((new Date().getMonth() / 3) + 1 == 3)? new Date(new Date().getYear(), 6, 1) : new Date(new Date().getYear(), 9, 1) This code works to correctly calculate the beginning of the quarter from within the default value expression of JasperReports. When i run this through iReport, i see no problem whatsoever. For any reports I've run in this quarter, i'm seeing July 1, 2010 as the start date. When I modify the JRXML to account for the "repo:subreport_name" format of jasperserver and run this report and have jasperserver email the output to me I get a different result: 6/30/10 8:00 PM This seems like a bug to me.

Thanks for the reply TK. That's almost exactly what i ended up doing (after a lot of digging through manuals and the forum). I got the original encrypted password from one of the install scripts and updated the row with that for the password field. I'm wondering though if there's any way I can encrypt a clear text password and install that. Of course, that would pretty much defeat the purpose of having a database with that information in it, but just wondering.

just to clarify, this is the password to JasperServer

Not exactly sure what happened, but it seems the JasperAdmin password stopped working? I'll attach the log to see if there's anything fishy that may show the password being changed somehow. In any case, it doesn't matter to me (ostensibly) how the password was changed. What does matter is how to get my password working again. So, I found the JasperServer DB tables looked at the usernames. Encrypted of course. So, I tried to update the password for JasperAdmin. Couldn't log in after changing it (and restarting apache), even though I could read the password as what I typed into the JasperServer login page. Maybe this is as a result of the encryption settings. Not sure. So, next I tried adding a new user as an admin with an easy to remember password. Same problem. No luck logging in. Here's what the table looks like now: mysql> select * from jiuser;+----+---------------+----------+----------------------+-----------------------------------+----------------------------------+-------------------+---------+----------------------------+| id | username | tenantId | fullname | emailAddress | password | externallyDefined | enabled | previousPasswordChangeTime |+----+---------------+----------+----------------------+-----------------------------------+----------------------------------+-------------------+---------+----------------------------+| 1 | anonymousUser | 1 | Anonymous User | NULL | CF35D2E88192D6EB | | ☺ | NULL || 2 | jasperadmin | 1 | Jasper Administrator | mike.cialowicz@firstcoverage.com | 1stCoverage | | ☺ | 2009-12-29 14:47:21 || 3 | jasperuser | 1 | jasperuser | | 332F12C5F5D083ED88CFE6D20284B07C | | ☺ | 2009-05-07 11:50:20 || 4 | ramyAdmin | 1 | Ramy Jasper Admin | ramy.abdel-azim@firstcoverage.com | password | | ☺ | NULL |+----+---------------+----------+----------------------+-----------------------------------+----------------------------------+-------------------+---------+----------------------------+4 rows in set (0.00 sec) PLEASE HELP!

The sample reports are all well and good, but they tell nothing of where the scriptlets are supposed to go within JasperServer. In fact, i've found very little documentation in terms of how JasperServer works behind the scenes. I'm just looking for a directory structure type of view for the report templates, scriptlets, et. al.

could you explain how this works a little more, please? In the SalesByMonth sample report i see this line: scriptletClass="test.TestScriptlet" as an attribute in the JasperReport tag. What is the significance of the "test." piece of the string?

Thanks so much for replying! Sorry it took me so long to notice this, i was on to the next project. The answer to your question is a little complicated because I've created a java application that produces the reports in bulk. So, the process goes like this, i run an SQL query that returns results from a database, i put those results into an xml file, i run that xml file through an xsl transfer which generates another xml file that can be read by the java app. the java ap then creates the paramter map with the code attached. Code: then this piece of code is called to fill the report: Code:public String fillJasperToJRPrintWithDB(String compiled, Report r) throws net.sf.jasperreports.engine.JRException { String jasperPrint = ""; try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); connection = DriverManager.getConnection(r.getInfo().getDBConnectionString());//"jdbc:sqlserver://fcreports:1433;user=fcdbuser;password=vB7zc31b0Ml;databaseName=firstCoverage"); if(ParseCmdLine.isVerbose()){ System.out.println("Filling report: " + compiled); } jasperPrint = r.getInfo().getFilledDirectory() + r.getReportName(); System.out.println("The .jasper filename will be: " + jasperPrint); HashMap <String, Object> reportParams = new HashMap<String, Object>() ; reportParams.putAll(r.getQuerySet()) ; reportParams.put("SUBREPORT_DIR", r.getInfo().getSubreportsDirectory()); reportParams.put("IMAGE_DIR", r.getInfo().getImagesDirectory()); JasperFillManager.fillReportToFile(compiled + ".jasper", jasperPrint + ".jrprint", reportParams, connection); if(ParseCmdLine.isVerbose()){ System.out.println("Filled report to: " + jasperPrint + ".jrprint"); } connection.close(); } Post Edited by Ramy Abdel-Azim at 12/09/08 21:46

Hello, Though I've been using JasperReports for several months now, i'm fairly new to the hyperlink feature. what i'm trying to do is set a hyperlink to an anchor that is in a subreport. However, since the subreport hasn't been created at the time of compiling the master report, i get a run-time error. The report looks like this: symbol today's score yesterday's score AA 35 25 BB 41 62 this chart is generated by a subreport. I want each symbol field to link to a point in another subreport that looks like this: AA Article # 1 about AA ---Summary of Article Article # 2 about AA ---Summary of Article This is generated by a second subreport . I would like the AA returned by the first subreport to navigate to the corresponding articles for AA returned by the second subreport. any help would be GREATLY appreciated. _Ramy

My question could be posted in a different section but my first guess is that it goes in the IReport section and not the JasperReport section. If I'm wrong, I'll gladly take my question there. My issue is this: i've created a Java application that takes, as input, an xml file with several parameters for the creation of a set of Jasper Reports. These parameters are fed into the query and a set of reports returns. I've found that the first time I run the batch application I get blank reports. In order to figure out why I get blank reports, I manually extract one set of parameters from the xml file and insert them into IReport as the default value expression for the report. If this report does not come back blank, I find that when I go to run the batch application, the reports that were previously blank are now populated with the data I originally expected. What I've deduced is that the blank reports are being generated because some combination of the default value expressions with the parameters the applicatoin is getting from the xml file are not valid and, therefore, not returning any results. If anyone has bumped into this issue or can give me some more information about the nature of default value expressions, I would greatly appreciate it. Let me know if it would help to see the jrxml files. I can attach those as well.