[Is it possible to have 2 variables in a single Bar line in a Bar graph?]

I am trying to implement a Bar Graph in Jasper similar to the attached screenshot. Can anyone help me to find out how to implement it?

Thanks in Advance

[How to eliminate extra white space in a test field bottom side]

I am facing an issue that lot of extra white space is there in a text field cell. I need to eliminate the bottom white space coming extra. I have added border for text filed but bottom padding is 0. Any help would be appretiated. Screenshot is attached here.

Thanks in advance,

[Border missing when exporting into PPT]

Hi friends... any idea about this issue?

[Border missing when exporting into PPT]

Border is missing when exporting into PPT. I'm using Frame and Text Fields in Sub report. The issue is happenomg when a row content is extending to next page. But borders are coming corretcly when report is running from Application. Only problem is when exporting to PPT. Can anyone help me on this.

 

 

 

[Substracting between 2 Row Groups in Cross Tab]

Can anyone help me on this?

[Substracting between 2 Row Groups in Cross Tab]

Hi,

Is there a way to substract between 2 row groups of Cross tab in Jaspersoft? I need the data like this.

Thanks,

Justine

[Design issue with Cross tab]

Can anyone help on this?

 

 

 

[Design issue with Cross tab]

Any idea about this issue?

[Design issue with Cross tab]

Hi,

I have developed a Jasper report using cross tab. Report is running fine and data is showing correctly. But when I am scrolling towards right to see the data upto December, the headers are disppraering. I am facing the issue in both IE and firefox. Can anyone please help me? Below are the screen shots of report before and after scrolling.

 

Thanks.

[Surrounding a subreport with a border?]

Bottom border is missing when the subreport expands over many pages. Can anyone suggest for a solution?

[how to add borders to a subreport?]

If the sub report exceeds 1 page, the botton border is missing during the page break. Can anyone help me?

Thanks,

Justine

[Page breaking leaving splitted frames without borders]

Can anyone please answer for this issue?

[java.lang.IllegalArgumentException: Illegal pattern character 'r']

While searching for any report in Jasper Library, I am getting this error :" java.lang.IllegalArgumentException: Illegal pattern character 'r'". Everything was working fine until yesterday. Any idea about this?

[net.sf.jasperreports.engine.JRException: Byte data not found at]

Any one have idea about this error?

[Incorrect Tooltip]

Can anyonehelp me to resolve this problem?

Thanks,

Justine

[Incorrect Tooltip]

Hi All,

I have developed a Pie Chart Jaspersoft. Everything is good except the tool tip. When hovering through each color area, it is showing like this, Low High : 3, Medium High : 5, High High : 2.

But actually it shpuld be like this, Low Count : 3, Medium Count : 5, High Count : 2. ie "High" should be replaced with "Count". I didn't do any custom code for tool tip and couldn't find any option for that. I don't know how "High" is came in every tooltip because no where it is predifined in my report. How can I get the correct tool tips?

Thanks,

Justine

[Color in Pie Chart]

Hi,

I need to implement specific color for each values in a Pie chart as, High=Red, Medium=Yellow, Low=Green. I tried with this code, but it is not working.

<dataAxis axis="Rows">
                                <axisLevel name="Level1">
                                    <labelExpression><![CDATA["Level Label expression"]]></labelExpression>
                                    <axisLevelBucket class="java.lang.Comparable">
                                        <bucketExpression><![CDATA[$F{priority}]]></bucketExpression>
                                        <bucketProperty name="color"><![CDATA[$F{priority} == "High" ? "#CC0022" : $F{priority} == "Medium" ? "#FFBB44" : $F{priority} == "Low" ? "#559911" : "#E8EBF2"]]></bucketProperty>
                                    </axisLevelBucket>
                                </axisLevel>
                            </dataAxis>

Can anyone please help me?

 

[Issues with Passing Multi select parameter from main report to subreport]

Thanks.. It worked.

[Issues with Passing Multi select parameter from main report to subreport]

"Define ProjectID as bigdecimal and use the $X{IN, , } function in both the main and subreport."

I tried this and still getting the same error. I think it is because from front end it is passing as multi parameter.

[Issues with Passing Multi select parameter from main report to subreport]

Thanks. Report is running in that case. But I am not getting the desired report output. Each time all the array list is passing to subreport. It is wrong.

Means, Suppose I am passing 2 Projects P1 and P2 as parameters from main report, the result now I am getting is,

1st page

Main report data P1, Sub report data P1, Sub report data P2

2nd page

Main report Data P2, Sub report data P1, Sub report data P2

But, the desired result should be like this,

1st page

Main report data P1, Sub report data P1

2nd page

Main report Data P2, Sub report data P2.

 

Any idea for getting this result?

 

[Issues with Passing Multi select parameter from main report to subreport]

I have a main report from which parameter ProjectID is multi select. The main report is working fine. But after adding the subreport I am getting an error

"java.lang.ClassCastException: java.util.ArrayList cannot be cast to java.math.BigDecimal"

In Main Report

Query part :  where $X{IN, i.id, ProjectID}

Parameter Name : ProjectID, Class : java.util.Collection, Nested Type : java.math.BigDecimal

In Subreport

Query part :  where i.id=$P{ProjectID}

Parameter name : ProjectID, Class : java.math.BigDecimal

Can anyone please help me to resolve this problem?

 

Thanks,

Justine

[Passing the values of multi-select query input control in jasperserver]

I tried this way and used Integer instead of collection in parameter. Now I am getting a new error

java.lang.ClassCastException: java.util.ArrayList cannot be cast to java.lang.Integer

Can anyone help me resolve this issue?

[Parameter type not supported in query : ProjectID class java.util.Collection]

I am using MS SQL query to generate Jasper Report. I need to use a multi select parameter for selecting projects. I have a query already for fetching projects and I have created an input control using that querBt when I reied to run the report it is showing the error as "Parameter type not supported in query : ProjectID class java.util.Collection". ProjectID is my parameter. Initially it was of integer type and everything was working fine. Now in order to provide multi select parameter I used collection type and changed the query part.

The where condition in query is like this : AND    $X{IN, i.id, ProjectID}. Can anyone help me to resolve this problem?

[using $X in the query, Parameter type not supporte]

When I use AND    $X{IN, i.id, ProjectID} in my MS SQL query part it showing the same error Parameter type not supported in query : ProjectID class java.util.Collection. How can I resolve this problem? I need to implement a multi select parameter in jasper report using a dynamically generated query which I already have.