Home
Analytics
Drill Down Report
anveshkona
Hi Friend,<br />
<br />
I have created two reports. One is Pie Chart and Second one is Table format.<br />
<br />
Ex:The Pie chart contains slice that shows number of licenses of particular group(like group1,group2,group3 etc). Table Contains All the columns which display all the users of above specified groups.<br />
<br />
<strong class='bbc'>My requirement is that. if you click the pie chart slice it opens only those numbers of selected particular groups only. It will be the great asset for me if you can help me.</strong>
Find more posts tagged with
Comments
mwilliams
So, you want to click on multiple slices and open the details for all of them or just click on a single slice to get to the details of a single group? Maybe I'm misunderstanding. Let me know.
anveshkona
yes. you are right. if i click one slice(number of users in group), i want to display those users belongs that particular group(slice).
thanks for replying.
mwilliams
You should be able to simply set up a drill through on your pie chart to pass the group value to your table report and use the value passed to limit your query or to filter you data so that only the desired values show.
anveshkona
How to pass group value from the chart to table of another report.
EX: I created one report which display chart. In that report i mentioned drill down and create hyper link and select the one more .rptdesign file which displays table.
could you please how to pass group value from chart to table in the above senerio.
anveshkona
Yes. I got it. thanks for information.<br />
<br />
But i am facing one problem. In my project it is allowing to add one .rptdesign file. if i add one file to this file it is giving some error like.<br />
<br />
<strong class='bbc'>org.eclipse.birt.report.model.api.JointDataSetHandle cannot be cast to org.eclipse.birt.report.model.api.OdaDataSetHandle </strong><br />
<br />
and is there any way in same file: if you click chart it opens table format for the specified condition.<br />
Or is there any way option.
mwilliams
What's your BIRT version? I'll make you an example of drilling to a table and of a possible other option using a single report.
anveshkona
Sorry. I got it. it is copy paste problem. once i created new join data source, it has come. thanks a lot.
mwilliams
Great! Let us know whenever you have questions!
anveshkona
<p>Hi Sir,</p><p> </p><p>I am facing the problem</p><p>Functionality is : when you click pie chart(permission group) it displays the details of the persons of selected permission group in the same .rptdesign file.</p><p> </p><p>I developed as following way.</p><p> </p><p>1. i created one data source for pie chart(by permission group category).and giving the hyperlink (By using internal bookmark)</p><p>2. i created one more data source for table format (details of the persons in selected permission group). table is created and <strong>bookmark</strong> is created for the "<strong>permission group"</strong>.</p><p>3. now propblm is when i click the slice it displays the all the persons of the all permission group.</p><p>4. now i want to filter that is i want to person details of selected permission group.</p><p>5.how can i solve this problem. plz let me know.</p><p>6. how can i get the value of selected slice.</p><p>plz help me.</p>
mwilliams
<p>Any way you can create a sample report that shows your issue using either the sample database or another source type that I'll be able to run the report from?</p>
