[How to use Hive Connection to access data in the Jaspersoft Studio?]

You need to install and configure Hive before you can use Hive. You'll find documentation on the Apache or Cloudera sites (or whatever distribution you are using).

[How to get selected locale in JasperReports Server?]

In general, locales are not used like that. You set the locale, then the UI and the reports etc. are rendered using that locale.

But I suppose you could achieve it with a little bit of JavaScript. You should update your question with a more precise example of a link you want to conditionally hide.

[Comparing two date values in iReport.]

I would try something like this:

( $F{Field1}.getTime() == $F{Field2}.getTime() ) ? "some string" : "another string"

Note that your current example is closer to this:

( some comparison ) ? "some string" : some_date

That's bound to cause problems. Decide if you really want a String or if you really want a Date after the comparison is made.

[documentation]

iReport is installed on a developer's machine. It can always see all folders.

But if you're thinking of limiting what folders someone can see in JasperReports Server, then you just need to set permissions appropriately. Users will only see what they are allowed to see, and that applies whether you are using the web ui or using the JasperReports Server plugin from iReport.

[Help Needed to import jar to jasper server]

How did you deploy the .jar to JRS? Do you get any error message?

[NEED chart scriptlet real example for ireport 4.5.1]

You should look up Chart Themes and Chart Customizers. It's not clear that you'll be able to do what you're intending to do. You'll need to provide quite a bit more detail to get a solid answer.

[Populate datetime input control from a control query?]

I cannot think of a simple solution. Input controls don't have the concept of a default value. JasperReports Server gives them a default value by taking the default value from the corresponding parameter in the .jrxml. That's good enough in many cases, but it doesn't offer much for your case.

You should certainly log an issue on the tracker. Replacing that the built-in logic for getting the default values with your own logic is surely possible, but I suspect it's a big customization.

[Error on console, but it works]

The error doesn't seem to say that it cannot find jasperreports_extension.properties. It cannot instantiate the query executer. I guess the problem is more along the lines of some other dependency that is missing. You don't need js-hive-datasource-1.1.jar. Remove that and let us know if that fixes it.

[Can Jaspersoft Studio support HDFS as a data source?]

Can Jaspersoft Studio support HDFS as a data source?
No.

who can tell me?
Me.

But... as Massimo mentions, there is a built-in connector for Hadoop Hive. Hive converts a SQL query into a map reduce job which uses HDFS files as its source. In many cases this is a better solution; it's far more flexible. In this case we could say the answer is "Yes", but it imposes the constraint of using Hive.

Also, I have seen custom data adapters for file data sources. These included files accessed via NTFS, Samba, HDFS, and others. So it's certainly possible to achieve this. Perhaps it will become a standard built-in data source for Jaspersoft Studio and JasperReports Server someday.

Also, Jaspersoft ETL has connectors for HDFS. So you can use this to get files from HDFS and put them somewhere else (local file system, database, etc.) for use by Jaspersoft Studio. (It works in the reverse direction for loading data into HDFS as well.)

[Error on console, but it works]

If you aren't using Hadoop Hive, then consider removing js-hive-datasource-1.1.jar. Maybe that will solve your error.

[Error on console, but it works]

Please edit your question so that it includes a question.

['stretch with overflow' problem with SansSerif font]

Don't use stretchType="RelativeToTallestObject". It's very unlikely that you want that for your field.

Yes, using SansSerif is likely to have different values if JRS is running on different machines. SansSerif is a logical Java font, and it will get mapped to different physical fonts on different machines. This happens especially when you're using both Windows and Linux.

Use Font Extensions. They exist to solve this problem. If you're using SansSerif, then you probably aren't overly concerned about which font to use. DejaVu is a good choice since it already ships as a Font Extension. Use that. (But you could package any font into a Font Extension and get the result you need.)

[Sort Grouped Tables in Web View]

I have groups in my tables, and the sorting and filtering work fine. Can you add details about how your table is structured?

[Hibernate in JasperReports Server]

I wrote an article about JasperReports Server and Hibernate. It should point you in the right direction. It uses that same samples/customDataSource as a starting point... but then it goes much further with JRS.

[Cassandra]

I'm not sure what explains that "No connection". What versions of iReport and Cassandra are you using?

[Cassandra]

Normally it's best to start with iReport. I'm not sure why that connection is not working.

Once that's working, then you can get the connection setup in JasperReports Server. The steps needed are listed here:

http://community.jaspersoft.com/wiki/cassandra
http://community.jaspersoft.com/wiki/jaspersoft-cassandra-jrs

A few links were broken and items mangled in the move to the new community website yesterday. But we're looking into them. Basically, you just unzip that zip file and copy everyting into the JRS directory. Match folders with the same names so you get a new file in bundles and several .jars in the lib directory. (The one you mention is necessary but insufficient.) You also need to remove the the Hive jar files because of a Thrift conflict. I swear that info was on the wiki page... but I don't see it now. To be precise, here's how I "remove" the files on a Linux system.

mv WEB-INF/lib/hive-common-0.8.1.jar     WEB-INF/lib/hive-common-0.8.1.ja_mv WEB-INF/lib/hive-exec-0.8.1.jar       WEB-INF/lib/hive-exec-0.8.1.ja_mv WEB-INF/lib/hive-jdbc-0.8.1.jar       WEB-INF/lib/hive-jdbc-0.8.1.ja_mv WEB-INF/lib/hive-metastore-0.8.1.jar  WEB-INF/lib/hive-metastore-0.8.1.ja_mv WEB-INF/lib/hive-service-0.8.1.jar    WEB-INF/lib/hive-service-0.8.1.ja_

[Connect to MongoDB With Authentication]

The MongoDB connector works well with authentication. That applies to iReport and to JasperReports Server. Can you post your version numbers?

[SubDatasets (lists inside lists) in json?]

This article was written with MongoDB in mind. But it should apply equally well to your JSON data source. Does that solve it for you?

[Newbie questions]

roshni,

You'll get a better reponse on the JasperServer forum (instead of the JasperAnalysis forum where this is posted). The front page of the Big Data Project links straight to it.

a) Cassandra 1.0
b) You write the parameterized CQL in a report definition. As the CQL JDBC driver improves, it should be possible to link Jaspersoft's metadata layer (Data Domains) to this. But it's not possible yet.

Refer to the Cassandra Connector documentation for more details.

Bonus question: "how can one publish the reports..."
Use JasperReports Server. It's downloadable from jasperforge.org or jaspersoft.com (Community Edition or Professional Edition respectively).

 

[JasperServer 4 Modify Navigation Menu]

I see what you're looking for. But I don't know the answer.

The problem comes from my sample JavaScript which uses "window.location.href". That's why it opens in the full browser page.

You should be able to take a look at actionModel.primaryNavigation.js to see how it is handled for standard menus. Then adapt your own. Sorry, I don't have more specific advice about this part. I haven't done this before, and I don't know Spring. Perhaps others will be able to comment on it.

Regards,
Matt

 

[Converting Collection parameter value to SQL-IN clause]

In most cases it is better to use this:

WHERE $X{ myCollection, myTableField, IN }

That way JasperReports takes care of converting the Collection into an IN clause for you. If myCollection happens to be empty, then "1=1" gets substituted in so that the next clause still gets ANDed correctly to it.

 

[Jasperserver login TimeZones does not show all the System TimeZones]

What is the exact change you made to applicationContext.xml?

[com-jaspersoft-ireport.jar Licensing]

Matt G already confirmed that legally you're perfectly fine.

I confirm what you had tentatively suggested as the technical requirement. You need com-jaspersoft-ireport.jar only at compile time. Your users will necessarily have it already in iReport at runtime.

Also, if you're looking for any tips, please note that the Big Data connectors have working samples of Query Providers. It might be interesting to grab the MongoDB or Hadoop HBase source to take a quick look. Those are in the Big Data Connectors project.

Regards,
Matt

[How to set the interval for time axis labels in a time series chart?]

In my answer to this question I point out a bug in iReport (along with the workaround). It sounds like you're hitting the same thing. You need to set the timePeriod to "Days". Give that a try and let us know how it goes.

Regards,
Matt

[Issues with the "Thin Sample Theme"]

I wrote that theme.

I'm really happy folks are looking at it. The theme is known to be buggy. That problem with administering users is one of the problems. When you try to create or edit a Domain... whoa, you'll find real problems. But most other things work well.

The basic problem in the case you are talking about is that the footer needs to be displayed. In most pages the footer just takes up space, so I removed it. But in some cases you need the footer because it has buttons.

I have occassionally tweaked my theme since then. I'll check to see if I have a solution to that particular problem. I'd also like to update the theme for our 4.5 release. There are sure to be some new issues cropping up.

Of course much of the reason for posting the theme is so that other people can reuse it and improve it.

Regards,
Matt