[setting default date]

Whoops...the last elseif should have a string of  "BEGINNING OF THIS MONTH", not "TODAY".

[setting default date]

There are a couple of options that I would suggest:

1) Within your start/ed date parameter(s), assuming that your parameter has a class of java.util.Date, enter new Date() as the default value expression and then when you deploy the report to JasperReport Server, don't add an input control for that parameter.  Without the input control, it will always evaluate the default expression at runtime and use the current date.

2) A more elegant way would be to create another parameter that takes a string to represent the date - i.e., it could take TODAY, YESTERDAY, TOMORROW, BEGINNING OF THIS MONTH, etc.  - in addition to the actual date parameters.  When deploying to JasperReport Server you  could then create a single select list of values input control for the string parameter with the possible values of TODAY, etc. but you would not have input controls for the actual dates.  Instead, you would use the string parameter to calculate the date using your own methods/class within the default Value Expression of the date parameters by setting the Default Expression to MyClass.calculateDate($P{StringParam}).

For example, you might have a class MyClass and a static method calculateDate(String str).  This class would be deployed with the report and the method would look something like the psuedo code beow.

By doing this, you can set the String parameter to a constant value when you schedule the report and allow the report itself to calculate the actual dates relative to the actual run date/time at the time the report is running.

Code:

public static Date calculateDate(String str){     Date myDate = new Date();     if (str.equals("TODAY")) {                       myDate= new Date();     } elseif (str.equals("TODAY")) {  myDate = /*calculate the beginning of the current month */}...    return myDate;}

[setting default date]

Is this for a scheduled report or just running any report?  If you set the defaultExpression for the parameter to new Date() this will set the current date.

[jaspersoft vs jasperforge]

JasperForge is the open source community site for Jaspersoft.  If you are downloading iReport from jasperforge, you are getting the open source project download which is not the same as the commercial version in that:

* The community project downloads are not certified by Jaspersoft's QA team - they are tested lightly but do not go through the same rigorous testing as the commercial/pro downloads and therefore do not have the same support levels provided by Jaspersoft's technical support team.

* The community project does not include certain professional features or plug-ins that work with the commercial editions of JasperServer or JasperReports, such as the domain plugin or the pro charts/widgets/maps

If you have a software subscription with Jaspersoft, you should download your software packages from Jaspersoft's support portal to ensure that you are running versions that are compatible and supported by Jaspersoft Support

I hope this helps.

[JOB OPENING: Customer Success Operations Manager]

http://www.jaspersoft.com/images/jasper_logo.gif 

Jaspersoft is Hiring
Customer Success Operations Manager

---

Work along side the engineers and architects of JasperReports, iReport, and JasperServer

Jaspersoft is looking for a motivated, resourceful, and solution focused engineer to help our customers acheive a high level of success and satisfaction with our products.  This is a highly technical position requiring hands-on trouble shooting, customer guidance, and example building and an excellent way to really expand your knowledge of the most widely deployed BI software on the planet. 

Summary

This is a customer/partner focused, hands-on technical support operations leadership position. This individual is involved in the day to day management of the Customer Success and Support processes – including:

• Management of customer escalations and targeted satisfaction efforts
• Representing our customers in Cross-departmental efforts to implement services and tools to drive customer success
• Developing, implementing, and measuring processes and tools to drive Customer Success team efficiency and effectiveness

As a leading open source software company, Jaspersoft relies on customer support excellence. This individual will work with others across the organization to innovate and break the boundaries of traditional “support” to develop a leading model for customer success. 

Location

Jaspersoft Headquarters, San Francisco, CA, USA 

Essential Functions

• Participate in direct customer success management through:
  • Customer escalation management
  • Technical Account Management/Customer Success Management services
  • Occasional Customer Support in a back-up/overflow capacity
  • Occasional on-call weekend/holiday support coverage for support of severity 1 customer issues
• Hands-on development/implementation of Customer Success tools and workflow changes, including:
  • Requirements definition, specification, hands-on development and testing, and documentation
  • Salesforce.com workflow, field, and object customizations
  • Customer Success Portal technologies such as search, document delivery/access, knowledge base content management, case management, wikis, blogs, and forums
  • Customer Survey Tools
• Manage process and technology improvement projects including:
  • Identifying and recommending process and technology changes
  • Provide sufficient status to management on schedules, risks, roadblocks and dependencies
  • Coordinating with product management, publications, development and quality assurance teams to implement enhancements to ensure customer success
• Measure process and team success through the development of critical metrics and establishment of goals
• Training and mentoring Customer Success staff 

Secondary Functions

• Provide architectural direction for customer facing systems implementation
• Conduct vendor evaluations and facilitate buy vs. build decisions
• Occasional contribution to documentation and product quality reviews 

Knowledge, Skills & Abilities

• Proven track record of defining and implementing successful technical support processes and tools
• 3 - 5 years technical experience with web-based enterprise business applications, J2EE technologies, and Operating systems such as Windows/Linux/Unix/AIX etc.
• 3+ years experience working directly with customers in a support or professional services capacity
• 2+ years of project lead/management experience
• Experience implementing workflows and processes within Salesforce.com
• 1+ years experience driving technical and geographically distributed teams
• Experience with the configuration of various J2EE application servers as well as relational database management systems a strong plus
• Experience deploying BI related software and building reports within BI related software a strong plus
• Experience with Web 2.0 collaboration and knowledge management tools and capabilities a plus
• Experience and understanding of Enterprise customer requirements, considerations, and limitations a plus 

Supervisory responsibilities

• Supervisory responsibilities of a global customer success engineering team
• Expected to act as a technical project and process improvement lead 

Success Factors

• Resourceful, fast learner
• Excellent problem determination and solving skills
• Excellent communication (verbal and written) and customer management skills
• Highly motivated, independent thinker with a drive to try and achieve new and great things and contribute to company success through the success of our customers
• Team player with the ability to work independently
• Ability to multi-task, effectively switch gears, and stay abreast of multiple issues, actions, and time-critical tasks.
• Detail oriented
• Self-starter

---

If Interested:

Please email your resume to jobs@jaspersoft.com.

 

Post Edited by mgeise at 03/23/2010 04:24 PM

[[Help] How to merge excel report content]

Set your page width to be larger...crosstabs automatically break at the page margins.   Since the number of dimensions is unknown until run time, you may continue to run into this if you get more and more dimensions.

[Can't start JasperServer (Help!!!!)]

Looks like your database is missing some quartz tables.  You probably want to go back through the install guide and make sure you ran all of the steps to set up the database.

[could not create a report]

If you don't want to buy the documentation, I would recommend taking a look at the wiki pages under the iReport documentation.  The community contributes tutorials, etc. here.

[Dynamic date parameter for reports scheduling]

The same instructions from above would apply.  Once you have an input control and chain of parameters that allows you to enter "Yesterday" and convert it into another parameter with the equivalent calculated Date, scheduling the report with Yesterday as the input is the same as scheduling with any other input control/

Matt

Jaspersoft

[Error in report scheduling for big reports]

Hi Supun,

 

This will depend on your app server and operating system, but assuming that you are running our bundled install with Tomcat, the following is where you would make the change:

 

Windows: <jasperserver-pro>/apache-tomcat/bin/setenv.bat

Linux: <jasperserver-pro>/apache-tomcat/bin/setenv.sh

 

you will see the following line (or something like it - the lines are different in the files but the settings are the same):

• set JAVA_OPTS=%JAVA_OPTS% -Xms128m -Xmx512m -XX:PermSize=32m -XX:MaxPermSize=128m

The -Xms is the minimum heap size and the -Xmx is the maximum heap size.  If you are running into java.lang.OutOfMemoryError: Java heap space you should at least rase the -Xmx value.  Raising the minimum would simply reduce the need for the JVM to allocate more memory as it uses it.  Note also that If you run into an out of memory issue on the PermGen space, you will want to raise the -XX:MaxPermSize. 

 

You should keep in mind the amount of memory on your server along with anything else you may have running there to ensure you leave enough memory for the operating system, etc.  If you are running a 32 bit OS with a 32 bit JVM, you are restricted to a max of 2Gb.  If you find you need more, you would simply move to a 64bit OS with a 64 bit JVM and you can get much higher.  (I have seen some implementations that get as high as 8Gb for large implementations but I am sure there are others that go even higher depending on their needs).

 

There are hundreds of articles on the internet that talk about the various JVM settings and how to optimize memory and performance.  Assuming you are evaluating, you likely won't need to get in too deep on this, but you might be interested in reading through some of them should you move toward a production implementation, etc.

 

Thanks,

Matt

Jaspersoft

[Security problem:Access denied]

Hi,

 

If the issue is around running the report that is in the folder, it will be a permission related to the objects used by the report, not the folder that the report is in.  For example, you will want to check the folders that hold the data source, etc. that the report relies on to ensure that the user has the appropriate permissions to all of the objects that are required to run the report.

 

I hope this helps.

 

Thanks!

Matt

Jaspersoft

[Export the original ResultSet but not the chart?]

This would require a second report to drill through to and export the details.

 

Your best bet here would be to create a report that leverages the same query but generates a detailed listing of records and use it as a drill through, where you pass the same parameters from the chart to the second report to generate the details for the user to drill into.  For what it is worth, with the right controls, etc. you could even use the same report  to allow for drilling into the specific details of the chart.  For example, a particular slice of a pie chart could have a URL that links to the report with specific parameters for that slice of the pie, allowing the user to drill into the records that are represented only by that slice, rather than all records represented in the chart.

 

Thanks!

Matt

Jaspersoft

[Error in report scheduling for big reports]

Hi,

 

As you can tell, this is caused by the JVM running out of memory - specifically running out of heap space.  There could be a few factors that cause this, including any of the following:

1. The size of the report and the export in combination with other activity on the server at the time.
2. Scheduling reports with multiple output formats - it doesn't sound like you are doing this, but the exporters take up some memory and multiple export formats mean there are multiple exporters utilizing the memory.
3. It is possible that the process of putting together the email to send with the report attached also digs into the memory more than a typical scenario of streaming to the client, so you may find that eliminating the attachement of the report to the email would alleviate the issue a bit.  (7Mb would be a pretty large attachment to send in an email anyway)

For implementations with large reports or even reports that leverage large result sets for summary calculations, etc. in combination with the number of users, etc. I would recommend a larger allocation of memory.  We find that many do ok with 1Gb or memory allocated for smaller implementations (average size reports and a relatively small number of active users or concurrent scheduled reports), but many (especially larger enterprises) go with higher memory allocations under a 64-bit OS and load balancing across multiple servers to optimize the JVM for performance and memory consumption through the various JVM garbage collection and class unloading settings as well as distribute the scheduler and user load across several instances.  Higher memory implementations are especially important if you have other web applications, etc. running in the same JVM or app server.

 

I hope this helps.

 

Matt

Jaspersoft

["Access denied Exception" when saving the file]

Since you have the same issue in another version and it is not specific to the functionality, as the foodmart examples work, it points to an issue with one of your repository resources and permissions there - could be datasource permissions, or any other object/folder that your view relies on.  I presume that if you tried setting up a duplicate of the foodmart example, it would work but that the issue is specific to the resources/folders you have created.

 

Short of looking at every related resource and folder where they are stored, etc. it seems you would need to get to a different level of logging or set up the application in a development environment with breakpoints, etc. to see what the issue is.   Jaspersoft support would likely be able to take a copy of your repository and try to reproduce and identify the issue, however this would be something that would require a support contract.

 

Sorry, but I am all out of suggestions without actually looking at the physical repository structure and permissions.

 

Matt

Jaspersoft

["Access denied Exception" when saving the file]

Hmmm...very strange.

 

Nothing has changed in your installation, system configuration, classpath, the way you are starting the app, etc. between when it was working and when it stopped working?  Has your browser recently upgraded or anything?

 

Is this JasperServer Community Edition or Professional Edition? Is this the only action where you get an error?  If you edit an existing analysis view by just going through and accepting the previous values, do you also get the error at the end?

 

Matt

Jaspersoft

["Access denied Exception" when saving the file]

Sounds like there may be a permission issue with the specific folder that you are trying to save into.  What happens if you save to a different folder?

Matt

Jaspersoft

[permissions issue pertaining to acegi security]

Hi Mike,

 

If I were to guess, I would look at the data source used by your queries as it appears you have checked everything else down to query level.

 

Short of looking at every object that your report relies on to ensure that the user has at least read access to it, the exact cause would be difficult to pinpoint.   If you don't mind, I recommend adding an enhancement request to the tracker to request better error messaging that would allow you to pinpoint the exact object missing permissions.

 

Thanks!

Matt

Jaspersoft

[Problems with Worbench 3.5.3 (i386)]

Look under "releases" within this (JasperServer) project - the workbench is listed there.

 

Matt

Jaspersoft

[Dynamic date parameter for reports scheduling]

Hi Ben,

 

I am not totally clear on whether your question is about passing dates that you would normally pass in input controls for scheduled reports or more about dynamically setting the dates that are used.  Based on the subject, I will attempt to cover the latter since the scheduling interface allows for you to provide values when you define the schedule.

 

If you wanted dynamic dates, for example "beginning of this month" to the "end of this month", I would recommend creating a parameter (and input control) that actually takes predefined strings like "start of current month", "today", etc. and then create a date parameter without an input control that has an expression that uses the string value from the first parameter with a java method, to calculate the date.  For example, the method may have a case that says if the string is "Today", then return the result of new Date();...start of month, etc. would be similar, but the date math would be a bit more complicated.

 

I hope this helps.

 

Thanks!

Matt

Jaspersoft

[Missing Jar Files ?]

Also, to answer your question on documentation, the JasperServer Professional Edition Web Services Guide should give you more information for configuring your client.  As a Professional Edition subscriber, you should have access to this through our support portal.

Thanks!

Matt

Jaspersoft

[Missing Jar Files ?]

Mike,

This issue is typically caused by either the wrong client side stubs being used or the wrong URI.  I suggest you check the webservices URI first.  The ".../jasperserver/..." portion will change to ".../jasperserver-pro/..." when you move from CE to Pro.

Thanks!

Matt

Jaspersoft

[Scriptlets in Adhoc reports]

Ad Hoc does not preserve the scriptletClass from the topic.  In fact, Ad Hoc topics have a finite set of supported attributes since the ad hoc feature is geared towards fast report development for non technical users.  For reports that requires scriptlets, they would have to be created in iReport and deployed to the server.

[Limiting the Number of Record Display]

You likely need to:

• Adjust the height of your detail band and font size to allow 20 rows to fit on a page (along with any headers/footer you may have)
• Adjust the size of your page (if you are more concerned about HTML output rather than printable output such as PDF/RTF)

 

[JasperIntelligence and Jasper4Salesforce]

I assume that you want to set up a Link on slaesforce.com page so that users can generate the report directly from the page. (For example, an Account Summary report from the Account detials page) This is possible with Jasper4Salesforce, although it takes a little bit of effort since we have not yet designed this specifically. Basically, you will need to generate a URL that calls the report with the necessary values.

 

Clicking on the report name within Jasper4Salesforce will bring up the Run Report Dialogue – the URL of this page includes a reportUnit parameter in the URL that has the full path to the report. The “/†in the path are replaced by “%2F†– you will need to do this as well when generating your URL.

 

If your report has user inputs that you want to populate from the source page, you will neede

By right clicking on the Run Report page that comes up when you click on the report title, you can view the html source of the page. Searching on “<input type=†will allow you to identify the name associated with each input – ignore inputs of type “hidden†or “submitâ€.

 

The custom link in your salesforce environment should be defined with the following URL definition – this assumes a single parameter of Account0_Id and the need to have the report run automatically rather than have the user enter values:

https://www.jasper4salesforce.com/jasper4salesforce/sforce/flow.html?_flowId=adhocViewReportFlow&reportUnit=<repositoryPathToTheReport>&Account0_Id_R0=<value>&directRun=true

 

Note that the items in <> will need to be provided by the calling page or you directly.

 

Hopefully this helps...if you have additional questions, please let me know.

 

Matt

JasperSoft