Drill down from Pie Chart with boolean parameter giving error

Hi,
I have 2 report each having a Pie chart. I want to drill down on pie slice from the first report to 2nd report. On the pie chart formatting, i choose interactivity -> mouse click -> hyperlink, then drill down option. I specified the report name and passed the boolean parameter 'testParam' to the next report.

But when i click on any pie slice, it gives exception saying "org.eclipse.birt.report.exception.ViewerValidationException: The parameter "testParam" is invalid. The value "96500.0" is invalid with the type "boolean"." .

Can any one help me out in this issue?

I am attaching 2 sample rptdesign file in which you will be able to see the exception. Please suggest, how to fix this issue. I am drilling down from "drill down L1.rptdesign" to "test drill down L2.rptdesign".

My main intention is to send a boolean parameter from 1 report to another report, via pie chart. I am able to pass the parameter from a table entry, but with pie chart i am seeing this exception.

Find more posts tagged with

Comments

mwilliams

When you set up the interactivity in the chart in the first report, put the '_' in the title of the report rather than spaces like the report is saved as and it should work as expected.

pratim

I renamed the report with no space in their name, but that did not worked. 
 
But i got a workaround for now, if i set the "hidden property" of the 'testParam' as false in the L2 report, it's not giving any exception. So, i guess this is a bug in BIRT. What's your opinion? 
 
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="75077" data-time="1301322033" data-date="28 March 2011 - 07:20 AM">
When you set up the interactivity in the chart in the first report, put the '_' in the title of the report rather than spaces like the report is saved as and it should work as expected. </blockquote>

mwilliams

I didn't get any exception when I ran the above reports after correcting the naming of the report. Can you reattach reports that definitely have the exception? Also, what is your BIRT version? Maybe I ran the reports in a newer version than you and did not get the same error.

pratim

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="75177" data-time="1301415029" data-date="29 March 2011 - 09:10 AM">
I didn't get any exception when I ran the above reports after correcting the naming of the report. Can you reattach reports that definitely have the exception? Also, what is your BIRT version? Maybe I ran the reports in a newer version than you and did not get the same error. </blockquote>
Hi Michael, 
 
I am using BIRT 2.3.2. 
 
I tried renaming the report but the error still exist. Then i set the testParam's hidden property to false, and the error goes away. 
I am uploading the modified reports. Now, i am facing one more problem. I am trying to pass the parameter testParam from L1 to L2, and printing the value in both the reports. If i check the checkBox in L1 report, and then try to drill down from any Pie Slice to the L2 report. The value of testParam is showing as False in the L2 report. This value is False in the L2 report, although in the L1 report i chose the testParam value as 'true'.

pratim

<blockquote class='ipsBlockquote' data-author="'pratim'" data-cid="76590" data-time="1304500564" data-date="04 May 2011 - 02:16 AM">
Hi Michael, 
 
I am using BIRT 2.3.2. 
 
I tried renaming the report but the error still exist. Then i set the testParam's hidden property to false, and the error goes away. 
I am uploading the modified reports. Now, i am facing one more problem. I am trying to pass the parameter testParam from L1 to L2, and printing the value in both the reports. If i check the checkBox in L1 report, and then try to drill down from any Pie Slice to the L2 report. The value of testParam is showing as False in the L2 report. This value is False in the L2 report, although in the L1 report i chose the testParam value as 'true'. </blockquote>
 
Here are the attached files,

mwilliams

The passing of the incorrect boolean parameter value looks like it was a bug back in your version. This works correctly in 2.6.2. I don't get an error in either version though, so I'm not seeing the error.

pratim

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="76687" data-time="1304699785" data-date="06 May 2011 - 09:36 AM">
The passing of the incorrect boolean parameter value looks like it was a bug back in your version. This works correctly in 2.6.2. I don't get an error in either version though, so I'm not seeing the error. </blockquote>
So, you are not able to see the error with 2.3.2 version as well. If it's a bug, then what should be the next step, do i need to file a defect in somewhere, or can i get a fix for this?

mwilliams

I do not see an error message in 2.3.2, but I do see the issue with the boolean being passed incorrectly. As far as filing a bug for this, they'd just dismiss it because it's fixed in newer versions. You'll probably have to upgrade to fix it, doubt there is a patch. You may not have to go all the way to 2.6.2 for the fix, it could be fixed in an earlier version than that. Something you could do as a workaround possibly, if the issue was only with boolean type, in your version, would be to pass an integer value instead of a boolean, 0 for false and 1 for true. Then, in your drill through, you could convert the 0/1 to the false/true for use in your report.