[JasperServer on AWS Elastic Beanstalk?]

JasperReports Server looks for the license file in three places: the WEB-INF folder, the user's home directory, and any arbitrary location specified by the -Djs.license.directory JAVA_OPTS setting. You can set this directory to whatever you want, and I presume you could also use a variable instead of an explicit directory.

You can learn more about license file management on Linux here:

http://www.jaspersoft.com/scorm_data/InstallingJasperReportsServer5forLinux_9565/data/tpc/1e585ce4-243e-46ae-8cc5-8f862afbd82f/topic.html?directlaunch&Mode=T

Mary Flynn

Jaspersoft

[Error in addDataSourceAws.jsp - JasperReports Server 5.2 on EC2]

This issue has been resolved. Customers with active support subscriptions can contact Technical Support and request the hotfix for issue #33210. Note that this issue only occurs if you download JasperReports Server version 5.2.0 and install it on EC2.

Mary Flynn

Jaspersoft

[our subscription is pending and should be ready momentarily.]

Hello - can you provide a bit more info on what you did (if anything) after accepting the terms? The recommended path is documented here:

http://community.jaspersoft.com/jaspersoft-aws/launch

Did you click one of the Cloud Formation scripts? If so, which one?

Sorry you're running into this trouble. Hopefully we'll get you on track quickly.

Mary Flynn

Jaspersoft

[The server has encountered an error.]

Glad to see that you solved the problem. Thanks for the follow up post with the solution!

 

Mary Flynn

Jaspersoft

[Jasperserver Pro on AWS 'VPC ID does not exist']

Hi Pete - I don't have quite enough information to help you troubleshoot, so I'll start with a few helpful links in case you haven't found them already. If the problem persists, please write back with the details of your data source type. Omit things like your password, of course. 

Connect to AWS Data Sources wiki article and connection best practices video: http://community.jaspersoft.com/jaspersoft-aws/connect

FAQ: Can I connect to on-premise databases?: http://community.jaspersoft.com/wiki/jaspersoft-bi-aws-frequently-asked-questions#Can_I_connect_to_on-premise_databases

Good luck,

Mary Flynn

Jaspersoft

[How to add a $ sign before a number.]

Is the field numeric or text?

[How to add a $ sign before a number.]

Hi - I haven't seen this problem before. The error message would help.

 

Forgive me if this suggestion is much too elementary, but check the field width. The field may not be wide enough to show the desired formatting. Make the field wider. You didn't mention if you tried running the report. Do you get a different result in design mode and preview mode?

 

Good luck,

 

Mary Flynn

 

Jaspersoft

[Error in addDataSourceAws.jsp - JasperReports Server 5.2 on EC2]

Notice from Jaspersoft: Version 5.2 of JasperReports Server is currently not certified to run on Amazon EC2. A software defect has been identified that generates an error when creating a new data source. The defect is in the processing of being fixed.

 

The error message is:

 

java.lang.IllegalStateException: Exception occurred rendering view org.springframework.web.servlet.view.JstlView: name 'modules/addResource/dataSource/addDataSourceAws'; URL [/WEB-INF/jsp/modules/addResource/dataSource/addDataSourceAws.jsp]

 

Workaround options:

 

• Downgrade to version 5.1.
• Watch this thread for notification of the defect fix.
• Use the Jaspersoft BI for AWS service as instructed at http://community.jaspersoft.com/jaspersoft-aws/launch. This includes the certified version of Jaspersoft for AWS. Note that Jaspersoft BI for AWS is a pay-as-you-go service offered by Amazon Web Services.

[No topics were available in the topics folder.]

Since you pose the question as to what's easiest, I'd say that the easiest is to restart AWS. Otherwise you can use something like PuTTY to connect to the server (you will need your private key and when prompted, log in as ec2-user). Then run "service tomcat7 stop". Make sure everything shuts down ok. Then run "service tomcat7 start". Again, it's easier to just restart the AWS instance. Be sure you don't terminate it!

 

Mary

[No topics were available in the topics folder.]

Hi John,

You can customize this, but it does require you to edit an xml file and restart the server. So be prepared with SSH or WinSCP to access the files on your AWS box and make sure that users expect a restart.

The file you want to backup and then edit is:

../webapps/jasperserver-pro/WEB-INF/applicationContext-adhoc.xml

Search for "defaultTopicDir" and you will find the following lines:

        <property name="defaultTopicDir" value="/adhoc/topics/"/>

        <!--<property name="defaultTopic" value="sample1"/>-->

        <property name="defaultTopic" value="AdhocDemo"/>

 

Hopefully it's clear that you change the default Topic directory by entering the folder name - in your case you would change "/adhoc/topics/" to your preferred folder. I added the "defaultTopic" line as well - the default is a sample that ships with Jaspersoft.

 

One thing that I want to bring to your attention is that you usually want to have a folder dedicated to Topics. So in your case you have a folder called /OurCompany. In that, you probably want a folder named /OurCompany/topics. This is because all JasperReports units found in the "defaultTopicDir" folder appear in the Ad Hoc Topics chooser. You probably don't want all JasperReports units to show up. (Then again - you might - I just want you to do it purposefully if that's the case.)

 

Save the changes (plain text file format, of course). Restart JasperReports Server / Tomcat. You should then be all set.

 

Mary Flynn

Jaspersoft

[ERROR: transaction is read-only jaspersoft aws bi suite]

Timy2 - I'm not a SQL or PostgreSQL expert, but I can offer you an idea that may be able to help you.

Jaspersoft runs database queries, which are naturally read-only transactions. Your complex SQL statement includes sub-queries. A quick web search yielded this, from http://www.postgresql.org/docs/9.1/static/sql-select.html: "Just as in a table, every output column of a SELECT has a name. In a simple SELECT this name is just used to label the column for display, but when the SELECT is a sub-query of a larger query, the name is seen by the larger query as the column name of the virtual table produced by the sub-query". It appears that the SQL is invoking a "write" transaction.

The cleanest way to handle this is to use an ETL process to transform and load the data into a table so it can be easily queried. It's possible you could make a stored procedure that sets the transaction type, but that may not be allowable and I wouldn't recommend it strictly from a security point of view.

I hope this helps.

Mary Flynn

Jaspersoft

 

[Problems while running jasperserver on ubuntu 12.04]

Hi Reyner - You are starting and stopping JasperReports Server correctly. If you want JasperReports Server to start as a service (rather than using ctlscript.sh), you can find an example of how to do that in the jasperreprots-server-5.1/scripts/linux directory.

It's hard to say what is causing the 404 error. If Tomcat loads, then JasperReports Server should be running. My best suggestion right now is to check the log files. This article provides more detail than what you need, but it gives you a good understanding of where the files are located: http://community.jaspersoft.com/wiki/how-produce-clean-log-files-troubleshooting.

I hope this helps.

Mary Flynn

Jaspersoft

[Input Controls on Jaspersoft AWS]

Hi John - Based on your reference to the Freight report, I assumed you're using iReport and not the Ad Hoc report designer. If you're using Ad Hoc, then I need a bit more info on exactly what you're doing. Otherwise, continue on.

Mastering the input control is very liberating. What you ran into is the flip side of a feature that is flexible and powerful. Unfortunately it was not obvious.

I'll use your suggestion of the Freight report as an example. When you edit the Freight report unit and click the Controls and Resources tab, you see three input controls: Country, RequestDate and OrderId. These input controls were created to be part of the report unit. You can think of them as tightly bound. I recommend that you NOT set them up this way, but as reusable controls, but you'll learn that when you get to the reference material at the end..

To see how this input control is defined, click on it. The Locate Input Control opens, and as you note, there are two choices. The first is what you want, and it really should read "Define or Edit an Input Control in the next step." Click Next.

On the Create Input Control page, you can type anything you want for the prompt. It could be as simple as "Country" or more elaborate, such as "Select a country from the list", etc. The really really important part to making the input control work with your report is to exactly match the Parameter Name. This value needs to be the same spelling and case as the parameter in your report. References on how to do this at the end of this post.

Back to the example. The Type selected for this input control is "Single-select Query". Click Next. The Locate Query page appears. Again, the first option should read "Define or Edit a Query in the next step." With that selected, click Next. 

The next three steps walk you through naming the query as a resource, selecting its data source (what are you going to query) and then the query itself. 

After you click Save, you'll see the Set Parameter Values page. It's not important for our example, and it can be confusing or seem redundant. For our example, just click Submit. Now, I'll tell you the reason for this page. Assume for a moment that your database includes two columns - one for the Country name (e.g., type = varchar) and another for the Country code (e.g., type = smallint). For the sake of efficiency, maybe you want to use the Country code (e.g., smallint) in the database WHERE clause instead of the varchar. But to minimize human error, you want to present the list of country names (e.g., varchar) to the user. This page allows you to do that with the "value" and "visible" columns. In this hypothetical example, the visible column could be country name and the value could be country code. To make this work, the SQL statement on the previous page needs to include both columns, e.g., something like this: 

select country, countryCode from ORDERS group by countryCode order by country

I added the order by so the country names would be in alphabetical order for the humans. If your data is pre-sorted in the database it may not be necessary.

Hopefully this gives you enough to accomplish your near-term goal. Here's more information to help you out:

Online help: http://help.jaspersoft.com/js-help-v5-en//Default.htm#search-input control

• http://help.jaspersoft.com/js-help-v5-en//Default.htm#js-help/Query_based_Input_Contro.htm
• http://help.jaspersoft.com/js-help-v5-en//Default.htm#js-help/Input_Controls.htm

JasperReports Server Administration Guide, sections 4.3 and 4.4: http://community.jaspersoft.com/documentation/jasperreports-server-administration-guide

iReport Ultimate Guide, section 6.2.1 Using Parameters in a Query: http://community.jaspersoft.com/documentation/ireport-ultimate-guide

I hope this helps.

Mary Flynn

Jaspersoft

[Input Controls on JasperServer Pro AWS Ad-hoc Views/Reports]

If the data type is numeric, then unfortunately you do not have the list-of-values filter operators. You could consider changing the source data type from numeric to varchar/text. Sorry I cannot think of a better alternative.

Mary Flynn

Jaspersoft

[Configure default summary method not working]

Hello there - You are right to use the Domain designer display features. If the field contains pseudo guid values, you will be best changing the type from "measure" to type "field." When you set a field to type "Field" the summary function list only makes functions count and distinct count available. 

Let me know how this works for you - good luck!

Mary Flynn

Jaspersoft

[How do you enable SSL in Jaspersoft for AWS]

Yes. Since you own and control the server, it's not possible for Jaspersoft to provide a certificate for you ahead of time. But you may configure SSL on yourJaspersoft BI for AWS instance exactly as you do on other servers. For more information, refer to the JasperReports Server Ultimate Guide, Chapter 8: Application Security.

 

Mary Flynn

Jaspersoft

[Unable to connect to Mongo DB 2.4.3 -- Jasper Reports Server 1.00 and hour unable to]

Can you ssh into the server? This wiki article explains where the log files are and offers advice to cleaning them up so you can focus on the current problem: http://community.jaspersoft.com/wiki/how-produce-clean-log-files-troubleshooting. 

Mary Flynn

Jaspersoft

[filter on aggregated field]

Filtering on an aggregate value can be done in the Crosstab ad hoc view if using Jaspersoft OLAP (not included with Jaspersoft BI for AWS) as the data source, or in JasperReports at the query with the GROUP BY and HAVING clauses. This link may help: http://www.w3schools.com/sql/sql_having.asp.

 

Mary Flynn

Jaspersoft

[Jaspersoft is hiring sales engineers!]

Jaspersoft is hiring sales engineers! If you're good with technology, good with people, and enjoy mapping features to tangible business value, you may be just the person we're looking for. We have openings in the Americas and Europe:

Multi-Lingual Sales Engineer

Location: North America, ideally Miami FL or New York City

The Multi-lingual Senior Sales Engineer applies technical expertise, customer relationship building, and basic team selling skills in order to support the sale of Jaspersoft software and services in the Americas. This support includes, but is not limited to: pre-sales strategy planning, technical fit qualification, professional product demonstrations, and applying BI industry knowledge and competitive expertise throughout the sales cycle. The Multi-lingual Senior Sales Engineer is responsible for the success of the prospect’s technical evaluation and perceived value of the software solution as a whole. The Multi-lingual Senior Sales Engineer supports multiple account managers and must be able to identify, prioritize, manage, and communicate issues both internally and externally. English and Spanish fluency is required; Brazilian Portuguese is desirable.

 

Sales Engineering Team Leader - Europe

Locaiton: Paris, France

Reporting to the Director of Worldwide Sales, the Sales Engineering Team Leader applies technical expertise, customer relationship building, and basic team selling skills in order to support the sale of Jaspersoft software and services. This support includes, but is not limited to: pre-sales strategy planning, technical fit qualification, professional product demonstrations, and applying BI industry knowledge and competitive expertise throughout the sales cycle to win business.  The Sales Engineering Team is ultimately responsible for the success of the prospect’s technical evaluation and perceived value of the software solution as a whole.  Working both as Team Lead and as a Sales Engineer, the Sales Engineering Team Leader works closely with Sales Representatives to drive the prospect’s pre-sale technical evaluation process.

 

Posted by:

Mary Flynn

Director of Worldwise Sales Engineering, Jaspersoft

[Nullpointer when reading fields from query (3.5.2)]

Hi luciano_castro,

Giulio and I came across your post while troubleshooting the same error message from a customer. It seems like it's a subtle design issue. I can recreate your scenario by creating two simple parameters:

• parameter1, type string, no default value
• parameter2, type string, default value = $P{parameter1}

iReport returns Error:null when you click Read Fields in the Report query box.

In this scenario the default value for parameter2 is "null" because that's the value for parameter1. Set a default value for parameter1 and the field list is returned.

It seems like you may have a similar issue where at least one parameter has a default value that is evaluating to null. In my customer's case the default value is being set by a custom method and we need to work that out. In your case I hope it's as simple as the example above.

Good luck!

Mary Flynn

Jaspersoft sales engineer

 

[How do we integrate HTML pages in JS?]

Hi Chris,

 

I don't know if this will point you in the right direction for your app or not. But there are two resources you can try. One is a white paper called "Customizing and Rebranding the JasperSoft User Interface." The section, "Extend a Page Flow" might get you started with some ideas: http://www.jaspersoft.com/re_overview.html#whitepapers.

 

 

The better more comprehensive resource is Chapter 9 of the JasperServer Ultimate Guide. The JS Ultimate Guide is included with JS Pro or you can purchase a copy at http://www.jaspersoft.com/JasperShop_Documentation.html. The Ultimate Guide covers Pro and Community Edition.

 

 

Good luck! I'd love to see what you end up with... :)

 

Mary

[there is some support after buy licenze]

Hello there,

 

I'm going to guess that your company purchased a subscription for JasperServer Pro. This comes with a commercial license, support, and other good stuff. The problem you're encountering is that the company did not opt to get a license for JasperAnalysis Pro (the ROLAP/analysis component). That's why you get the "Product Feature is not licensed" message every time you click an analysis view. With a JA Pro license, the analysis views would appear in your browser and your data access/analysis would be handled by the JA relational olap server.

 

My suggestion is to share this post with your admin. I'm certain Jaspersoft sales would be happy to provide a quote for JasperAnalysis. :)

 

Mary

[Report Alternate Row Colors are Not Displaying]

Most likely you have fields or layout objects overlapping each other. The JR report viewer (written in Java) and PDF can display overlapping layout objects fine, but HTML tables cannot. (If you're super interested in the HTML limitations and options, you can check out http://www.jaspersoft.com/jaspersoft_app17.html.)

 

The way I like to handle this is to use the Report Inspector panel in iReport to select each object and note its properties. If you already know you have an object overlapping another (for example, a rectangle box), you can replace the box with a frame and apply your styles to the frame. The frame is not a graphic object; it's more like a container. You put all your layout items inside the frame and the layout items inherit whatever styles you apply to the frame.

 

HTH,

Mary

[Slow Resize]

Hi there,

 

I ran into the same issue quite unexpectedly during a live demo. Dragging and dropping, resizing, and even selecting items took 5 to 15 seconds to complete.

 

An internet search for NetBeans and performance resulted in my fix.

 

I added the following as an environment variable. The -Dsun.java2d.d3d=false option turns off DirectDraw. The rest manage memory. I got this tip from http://performance.netbeans.org/howto/jvmswitches/index.html. I'm running iReport for NetBeans 3.1.2 on Windows. I hope it works for you on 2.0.5.

 

JAVA_OPTS=-Xms128m -Xmx512m -XX:PermSize=32m -XX:MaxPermSize=128m -Xss2m -Dsun.java2d.d3d=false -Xverify:none

 

Mary

Code:

Post Edited by Mary Flynn at 12/17/08 18:31

Post Edited by Mary Flynn at 12/17/08 21:15

[Barcode not printed when running the report from]

I had a similar problem a while back. I think I had to add the "barbecue" (and possibly the "ireport") jar from the iReportlib folder to the target application's classpath (e.g., your java app's lib folder).

 

Mary