mdahlman

Ahh... Then my next guess is that you're not using the driver that you want to be using. The iReport drop down shows "The APP driver": IBM DB2 (COM.ibm.db2.jdbc.app.DB2Driver) But you probably want "The Universal driver": com.ibm.db2.jcc.DB2Driver The iReport GUI is very confusing in this regard. But you can just type in the correct class and things will work as they should. Give this a try. Regards, Matt

Sonata is correct. To expand on that slightly: A Domain can use only a SQL data source (someday this should change... but that's how it is in JRS 4.1). But a Topic can use any custom data source. Therefore you can still use Ad Hoc reporting with custom data source as long as you use topics. Regards, Matt

JRS's ability to set input controls' default values is pretty weak. Step 1: if you're a paying customer, be sure to log a case with technical support asking for this to be improved. That will raise its priority. Next, for your simple example you probably need to attack it like this: 1. Param_Year is a text field or query or whatever is appropriate. 2. Param_First_Day_of_Last_Year is a SQL query like this: SELECT Date( $P!{Param_Year} || '-01-01' ) - ( INTERVAL 1 Day) as the_day (That's not valid SQL... but the pseudo code should be clear enough.) Now the input control Param_First_Day_of_Last_Year will be a drop down with the value that you want. Granted, this is pretty kludgy. For a more elegant solution, see step 1. (Sorry) Regards, Matt

arpanbaruah, I see that you posted a different thread first. In that thread it looks like you hadn't deployed the Hive connector to JasperReports Server. Please list out the steps that you've done so for so that we can make a better guess at where the problem is coming from. Regards, Matt

sszretter & dronk, Can you provide sample queries indicating what you're trying to do? I'd like to understand what query you might run in the MongoDB command line to get the result set that you want. Or would you need to run multiple queries? If you can provide a more detailed sample, then I think we can find a solution for you. For example, include the table definitions, a tiny bit of sample data, sample query, and an explanation of what the report should include (image, words, whatever makes the requirement clear). Regards, Matt ravi2801, As far as I can tell, your question has nothing to do with the other posts in the thread. Please create a new thread and add quite a bit more detail to make your question clear. Regards, Matt

What version of the Hive connector are you using? What version of Hive? What version of JasperReports Server? Did the report work correctly in iReport? The most common mistake I have seen is that users accidentally use the query language "SQL" when what's needed is "HiveSQL". Any chance that you're doing this? Regards, Matt

That is indeed an odd bug. I haven't seen anything like it before. What makes you think it's related to Oracle? Have you confirmed by pointing the same JRS instance to a MySQL repository? If not, that would be a great test. It feels more like a CSS bug. I guess (without looking to confirm) that the message "this report contains no data" is always present in the page. In most situations it is not displayed. When there is no data then it is displayed. Somehow you're getting it displayed at all times. You could take a look using Firebug to confirm this idea. If that's true... well then I'm not really sure what to do next. But somehow we could track down _why_ it gets displayed all the time. Regards, Matt

It sounds like you made reasonable changes to get it working. Be sure to log it with technical support. It seems there is definitely a valid enhancement request: 1. It should be possible to default to "hide detail rows" by making a config change (no recompilation should be required). And based on your post, it seems like there could be a bug: 2. The initialization value for showTableDetails in AdhocUnifiedState.java (in gyroscope.jar) is ignored. I cannot confirm #2. Perhaps you've made a silly mistake. But it sounds like you've done things correctly. In any case, support should be able to assist. Regards, Matt

It seems like today is Font Extension day. There have been a few posts about getting fonts working in PDFs. Use Font Extensions. CP1252 doesn't sound good for Chinese. I think you'll need "Identity-H". Likewise, Arial may not work. But "Arial Unicode.ttf" should be good. Good luck, Matt

Search on Font Extensions. You need font extensions to load fonts correctly. My article might help... but it's not targeted exactly at a JR developer like yourself. Regards, Matt

There were some bugs around the display of labels in pie charts. The exact version of JR in use will be important to figure out what's wrong. You may just need a different version. Regards, Matt

Interesting problem. According to TextWrangler and OpenOffice.org, your CSV is exported correctly to UTF-8. I can view the Thai characters correctly in both applications. I confirm your results that it cannot be viewed correctly in Excel. I don't know why Excel treats it differently... but it seems more like an Excel problem than a text file problem. I see the same problem in your PDF as you describe. It seems like it's a font problem. I realize that this really doesn't make sense... since AngsanaNew is specifically created as a Thai font. But I get a good export of the same text when using MS Arial Unicode. I don't have Angsana to test with that. Review that you're using Font Extensions correctly. Maybe you are already... but I don't have other ideas. Regards, Matt

Dates are hard to work with in Java. In general my recommendation is to use the Java Commons Lang library. It makes date manipulation much easier. I wrote an article about dates in JR and JRS in the past. Good luck, Matt

In the JasperReports Server web GUI you can select a report unit and copy it. Then paste it to another directory. Pasting it into the same directory and getting an appropriately renamed version would be really useful. But it's not possible today. Be sure to log that in the tracker if that's what you were looking for. Otherwise you could get what you wanted with: 1. Run js-export 2. Make appropriate tweaks to the exported files 3. Run js-import Clearly there's a significant bit left to the reader in determining the exact details of "make appropriate tweaks". But it's another way to attack the problem. Good luck, Matt

Try creating a new datasource of type "Database JDBC connection" rather than "NetBeans Database JDBC connection". Given that you have already set the classpath correctly (in Tools->Options->Classpath), this datasource should work immediately. Regards, Matt

The attached report contains no SQL query. iReport does no parsing of the SQL query. It just passes the query to Oracle. I think it's likely user error. Consider this from your query: WHEN1 = 1 It's not valid. It needs to be this: WHEN 1 = 1 If you're sure that you can find a problem, attach a report that reproduces it.

This isn't an iReport issue. It should be closed and opened as a JasperReports issue. When doing that, consider threads like this one: http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=64230 It's not really clear what HTML ought to be generated to handle rotated text. If you can provide example HTML/CSS code to show what you want it would be a big benefit.

"i was a little rusty" You're too modest. You found an valid bug. Reports all worked fine (that's why we didn't notice the bug). But having to enter fields yourself is a hassle. It turns out that this is a documented bug in Hive. HIVE-2062 I re-built the iReport plugin with a new copy of hive-jdbc-0.7.0.jar containing a patch. Now the Fields Provider works correctly in the new report wizard and in the query editor. There are no changes at all to the Jaspersoft code. But I incremented the version of the Hive connector anyway just to be clear that version 0.5 has the updated .jar file included and therefore solves this problem. It's available now: http://jasperforge.org/projects/bigdatareportingfornosqlandhadoop/downloads Regards, Matt

No, it cannot be done today. You could create a filter to leave out all individual expenses less than some value. But you cannot filter on the aggregated totals. You could achieve this by editing the report in iReport. The limitation isn't on domains; the limitation is on the Ad Hoc GUI. Regards, Matt

Yes, when you click on the map it can trigger a hyperlink. They hyperlink can include a field like "state" or "country", so the drill down can be parameterized based on which part of the map the user has clicked on. Regards, Matt

No, that's not quite right. Look here: http://jasperforge.org/projects/ireport/code You don't want the "ireport" repository, you want the "ireport-nb" repository. Alternatively, you can get the source all packaged up on sourceforge.net: http://sourceforge.net/projects/ireport/files/iReport/iReport-4.0.2/ Regards, Matt

There should be an error in the JasperReports Server log that will give you more information. I guess that the server isn't connecting correctly to your SQL Server database. (But iReport is able to connect to the database just fine.) Regards, Matt

AB, I see a problem in the Hive connector that slipped through. The Fields Provider isn't working correctly for me. The Fields Provider is what gets called when you click the button "Read Fields" in the query editor. (It also gets called frequently if you have "Automatically Retrieve Fields" checked in the query editor. Be sure to deselect this, or it will make you miserable.) It also gets called in the report wizard. This appears to be where you're hitting it. It used to work. I'm not sure when we could have broken it. Please try this test: 1. Create a new report without using the report wizard. 2. Paste in a valid SQL query. Be sure the query language is HiveSQL (not SQL!). 3. Manually add at least one field to the report. (Normally the button "Read Fields" does this for you automatically.) 4. Drag that one field into the report layout. 5. Run the report. This should work. It works for me. That's why it slipped through our tests. The reports still run fine. It's just the Fields Provider that has a problem. Let us know your results from this test. In the meantime we'll figure out what went wrong. Regards, Matt

In general a dashboard shouldn't require scrolling... but this idea of hiding scrollbars at all times doesn't seem very good. You should probably log a bug for it. In the meantime, take a look at this file: .../WEB-INF/jsp/modules/dashboard/dashboardViewerCommonImports.jsp You'll find this inline CSS: .column.decorated.primary, .column.decorated.primary>.content, .column.decorated.primary>.content>.body { top:0; bottom:0; left:0; right:0; overflow:hidden; margin:0; } Change the "overflow" option to "auto" and you should be all set. Regards, Matt

See this post: http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=84079