Drill down reports

0

 Hello,

I have a requirement to create drill down reports.  Can anyone give me pointers on how to accomplish this?

Examples:

I have a pie chart categorized by category.  I want to drill down on the category to get the pie chart for its subcategory.

I have a line chart by month.  I want to drill down on the month value to see a line chart by day for that month.

 

Thanks in advance.

jeanjenkins's picture
Joined: Mar 23 2011 - 11:41am
Last seen: 10 months 3 weeks ago

11 Answers:

0

The hyperlink type "ReportExecution" is a feature of JasperReports Server (JasperServer) which does exactly this. Search the JasperServer forum.

Regards,
Matt

mdahlman's picture
1708
Joined: Mar 13 2007 - 2:43am
Last seen: 2 years 9 months ago
0

I had the similar requirement and I am able to do it .

Now I am facing a issues , the drill down report is getting displayed in the same report area. I want both the report main and drill down report to show at the same time in a dashboard.

Please let me know the way , I think I have to so something in Hyperlink target ,which is currently referring to self. but dont know what . Please let me know what to do in order to display 2 reports individually at the same time in dashboard



Post Edited by dev_1312 at 05/24/2011 17:29
dev_1312's picture
Joined: May 23 2011 - 8:03pm
Last seen: 6 years 3 months ago
0

dev_1312,

Clicking on one panel to update another panel is a really reasonable request.

Bad news: JasperReports Server doesn't have that feature yet.

Good news: You can achieve it with some pretty straightforward customizations.

Better news: There is sample code available here from a webinar that demonstrated this. (Search on the webinar page for "dashboard" to find the recording.)

Good luck,
Matt

mdahlman's picture
1708
Joined: Mar 13 2007 - 2:43am
Last seen: 2 years 9 months ago
0

Thanks Matt,

I saw the demos and will let you know how far I have reached

Thanks Again

~Dev

dev_1312's picture
Joined: May 23 2011 - 8:03pm
Last seen: 6 years 3 months ago
0

Matt,

I tried doing the way as you showed in the webinar , but stuck at TargetFrames number .

"javascript:window.parent.replaceManyFrames('/reports/MegaDashboard/tabs@@/reports/Fusion/bars@@/supermart/details/TopFivesReport@@/reports/Fusion/pie@@/reports/MegaDashboard/parameters','View="+$P{View}+"&top=1@@View="+$P{View}+"&top=1@@View="+$P{View}+"&top=1@@top=1@@top=1','1@@3@@6@@4@@2')"

where I will see the TargetFrames number? How I will assign the TargetFrames number to the reports ?

Any pointers will be helpful

¬Dev



Post Edited by dev_1312 at 05/26/2011 05:02
dev_1312's picture
Joined: May 23 2011 - 8:03pm
Last seen: 6 years 3 months ago
0

Hi Matt,

Please let me know what is target frame means ? where I will get the values of it . I tried creating the dashboard using the reports u used for showing MeGa Dashbard. But when I do preview , Things won't work for me like updating the other report, but If I use the demo used by you I works .

Is there anything I need to do apart from writing the javascript command in hyperlink section in Ireport ( as shown in webinar) and dropping the java script file in the folder.

Regards,

Dev

 

 

dev_1312's picture
Joined: May 23 2011 - 8:03pm
Last seen: 6 years 3 months ago
0

Matt,

Could you please provide me pointers on the this function Target frames .

function replaceManyFrames(TargetReports,TargetParameterStrings,TargetFrames)

replaceManyFrames('/reports/report1@@/reports/report2','Country=France@@StoreID=4','2@@3')

It is very urgent for us as we have to showcase jaspersoft capabilties to client for BI implementation . Please help me.

Regards,

Dev

dev_1312's picture
Joined: May 23 2011 - 8:03pm
Last seen: 6 years 3 months ago
0

I am done with this .. Thanks Matt  !

dev_1312's picture
Joined: May 23 2011 - 8:03pm
Last seen: 6 years 3 months ago
0
Hello,
Can you please provide some sample for drill down report made with jasper/ireport. I'm trying to achieve a drill down in a table.

Thanks,
Anita
anitasri1's picture
Joined: Feb 5 2011 - 7:27am
Last seen: 6 years 6 months ago
0

Hi Anita,

Please go through the webniar mentioned by Matt, Download the mega_interactive_dashboard example and look at the last 2 functions of the javascript.

Play around with these 2 functions and you must be able to achieve the drill down on other report in the dashboard.

If your requirement is to display the drill down in the same report then just use the hyperlink feature .

~Dev

dev_1312's picture
Joined: May 23 2011 - 8:03pm
Last seen: 6 years 3 months ago

I have a report Pie Chart,and detailed view report. So i need to call above function
i.e. replaceManyFrames(TargetReports,TargetParameterStrings,TargetFrames)

So for TargetReports i gave -->"/public/Samples/Reports/test_detailed_view"
TargetParameterString --> productName [this one i need to take dynamically]so i gave as $F{productName}
TargetFrames ------> I dont know what i have to give.

Can u please explain?

nageshit2011 - 4 years 1 week ago
0

 

I have a report Pie Chart,and detailed view report. So i need to call above function
i.e. replaceManyFrames(TargetReports,TargetParameterStrings,TargetFrames)

So for TargetReports i gave -->"/public/Samples/Reports/test_detailed_view"
TargetParameterString --> productName [this one i need to take dynamically]so i gave as $F{productName}
TargetFrames ------> I dont know what i have to give.

Can u please explain?

nageshit2011's picture
Joined: Jul 22 2013 - 3:04am
Last seen: 2 years 4 months ago

Hi,
'm trying to invoke this function from my report (5.5 pro) but getting hit by the below exceptions... can any one suggest the correct method to invoke the js function (in hyperlink --> Reference from a report)
TypeError: window.parent.replaceManyFrames is not a function
or TypeError: localContext.replaceManyFrames is not a function

Thanks,
Sure

sure919 - 3 years 5 months ago

figured out what i was doing wrong!!! Thanks!! had to update the .js file mentioned in http://community.jaspersoft.com/wiki/creating-interactive-dashboards-usi...

sure919 - 3 years 5 months ago

TypeError: localContext.replaceManyFrames is not a function

i have updated dashboard.runtime.js file but i am getting same error .

h.aulakh89 - 5 months 2 weeks ago
Feedback
randomness