[How to create two or more lines in one Line Chart?]

The quickest solution is to do everything in a single SQL query:

SELECT items.name AS item_name, trends_uint.clock AS  trends_clock, trends_uint.`value_avg` AS mem_total_value_avg 

FROM items, hosts, trends_uint 

WHERE  items.itemid = trends_uint.itemid AND items.hostid=hosts.hostid AND  hosts.host='vsrvlab02' AND items.key_='vm.memory.size[total]'

UNION ALL

SELECT items.name AS item_name, trends_uint.clock AS  trends_clock, trends_uint.`value_avg` AS mem_total_value_avg 

FROM items, hosts, trends_uint 

WHERE  items.itemid = trends_uint.itemid AND items.hostid=hosts.hostid AND  hosts.host='vsrvlab02' AND items.key_='vm.memory.size[available]'

There are other (better?) ways to write the SQL. But this one is certain to work since it just UNIONs your 2 existing queries together.

[Lost JasperAdmin Password]

There's no need to restart the app server. Setting the password to the empty string like this is definitely the simplest solution. (Setting it to NULL would not work.)

[Domain creation for ROLE_USER]

First, you should enable the menu Create -> Domain for non-admin users. Edit the file .../jasperserver-pro/WEB-INF/actionModel-navigation.xml. Find this near the end:

                        [/code]

Second, you need to enable the relevant flow. Edit the file .../jasperserver-pro/WEB-INF/applicationContext-security.xml. Find line 558:

createSLDatasourceFlow=ROLE_USERdomainDesignerFlow=ROLE_USER[/code]

That should give you the ability for ROLE_USER to create domains.

From there you can improve on the solution. Maybe you only want a few users to have this option. You could instead create ROLE_DOMAIN_DESIGNER and use this so that not everyone with ROLE_USER gets this permission. Also, my first change enables Create -> Data source as well. You may not want that. It should be pretty easy to tweak my suggestion to enable only Create -> Domain.

[Domain creation for ROLE_USER]

Please advise on how to have domain creation permission without having admin role in Jaspersoft AWS.

[Posted on behalf of a customer who wasn't able to post directly]

[AWS JasperServer using RedShift - no OLAP features]

I confirm that OLAP is not available in the Jaspersoft BI for AWS offering. For a point-by-point list of differences between the offerings, refer to this page:

https://www.jaspersoft.com/editions

To have OLAP features you would need Jaspersoft BI Enterprise, which you could run on EC2 or on premises (or whereever you like).

[The conflict between the MaximumBarWidth and the ItemMargin]

The image helps a lot. It looks to me like you have too many categories defined. There are null categories creating the extra space.

[Is iReport an enduser Tool?]

Nope, iReport is not intended as an end user tool. It might work for some superusers, but in general it's much too complex for them.

Ad Hoc reporting in JasperReports Server is intended for end user reporting and analysis.

[html5 charts are not available in the pallette]

The text of your question does not contain a product name (or a question). 

But it sounds like you're looking for iReport Professional and JR Pro or JRS Pro. You can get iReport Pro for a 30 day evaluation here:
http://www.jaspersoft.com/thanks-download-30-day

[SQL Server 2008 as the JasperReports Server Repository]

No.

The GUI installer (also called the bundled installer) supports only PostgreSQL. Use the war file installer for SQL Server or Oracle or MySQL or other DBMS technology.

[another problem with ireport]

You'll need to clarify. It seems like you're saying the new report fails, but the new report succeeds. The error doesn't appear to be related to JR.

[Not sure which version of Ireport Designer will work for Stat 5.6.2, can you help?]

What is Stat 5.6.2?

[Welcome to Jaspersoft BI for Amazon Web Services (AWS)]

Hi,

This isn't a real question... but instead it's a welcome message with a few best practices about asking questions related to Jaspersoft Business Intelligence for Amazon Web Services (Jaspersoft BI for AWS).

Some questions may really be specific to the Jaspersoft BI for AWS offering. Those should definitely get tagged with "AWS". (There are folks at Jaspersoft specifically monitoring questions that get tagged like this.) A large percentage of these users will be working with Amazon Relational Database Service or Amazon Redshift. Be sure to tag the questions appropriately with RDS and MySQL or SQL Server or whatever the database technology is.

Most questions about Jaspersoft BI for AWS will be more general questions about JasperReports Server or iReport. So you should post those as standard JRS or iReport questions linked to those projects. BUT... please also tag the question with the "AWS" tag.

Thanks!

By the way, for anyone who comes across this post and has no idea what Jaspersoft BI for AWS is. You can read about it on the page Jaspersoft for AWS.

[Pie chart labels can't be removed]

I added a screenshot to show what I meant. First, does that clarify it? Second, does that solve the problem?

[How can I link an existing Input Control in Jaspersoft Studio]

Important detail: Linking input controls fails for me. (Linking other types of objects works well.) I logged it: http://community.jaspersoft.com/jaspersoft-studio/issues/2743

[How can I link an existing Input Control in Jaspersoft Studio]

That leads to the ability to create a new input control, of course. But it also leads to the choice "Link" which is what you want.

[How can I link an existing Input Control in Jaspersoft Studio]

Right-click the report unit and choose "New".

From there it will be obvious. (But I understand why you wouldn't think of it at first.) It a different way to think of things, but I think the new flow is better once you're used to it.

EDIT: Based on baumgaro's comment, it's clearly not as obvious as I claimed. But you need to choose "Link" when your goal is to link to an existing input control (or link to another type of object).

[Hive connection - Data Preview/Read error]

Impala is not tested with the Jaspersoft Hive Connector. Impala "works like Hive". So in principle it should just work. Your test was reasonable. But it's easy to imagine the possibility of version conflicts with these technologies. Jaspersoft will certainly test with Impala, but an exact timeline is not established yet.

[chart refresh two times in report that has two pages]

I had the same behavior. In my case it was because I had "Page 1 of N" in the page footer. Because of this, JRS behaves like this:

1. Renders first page as quickly as possible (including chart). Footer displays "Page 1 of"
2. It calculates the full report.
3. It updates the first page (includeing chart). Footer displays "Page 1 of 2".

In the case where step 2 takes 60 seconds... this behavior is great. You see page 1 very quickly, and then you see the updated version after the rest of the report is calculated.

But in the case where step 2 takes a few milliseconds... the report just appears to render twice. It's annoying. My immediate solution was to remove the Total Page calculation from the first page. That might work for you too.

You should log an enhancement request. (I already did, but it definitely adds to the urgency if community members log requests as well.)

[Pie chart labels can't be removed]

It could be a problem with the chart theme setting labels.

Try setting the label to "null" without the quotes. That may give the results you're looking for.

[Encoding in jaspersoft studio]

Can you post a sample report with the problem? In general UTF-8 should be great for working with accented characters. And in practice it's working well for me (and others) with accents, Japanese, etc. So there must be something unusual going on.

[Problemin printing Hindi data in pdf ?]

Use font extensions.

[Handling null values in charts]

You need to post this new question as a new question. Please don't post it as an answer.

[How I can combine two datasets using iReport 5]

Maybe you'll need to add some sample data to make it clear. You have two datasets that don't match. It's not clear to me what the BI tool could do.

[Connect JasperReports Server 4.7.0, iReport 4.7.0 to MongoDB 2.2.1]

Great! Note that the MongoDB plugin is already available in JRS 4.7 and iReport 4.7. so you don't need to install it separately.

[How I can combine two datasets using iReport 5]

You need to add some more details for someone to be able to answer. Why can't you run a single query that is simply "query1 union query2"?