Pie Chart with drilldown to display another library page

[tekhong]

Hi all

I which to display a pie chart and enable a drill down on the pie chart slice to display a common library page with a grid section to display the records representing the clicked slice of the pie chart

May I know how this can be achieved with the Chart section?

Your advice is much appreciated

Thanks & Best Regards

[josipradnik]

Hi, Tekhong,

Explore if this can help you for your case:

For example, generate a background report when a bar is clicked:

////////////////////////////////////////////////////////////////
// Event delegate for 'click' event
proc page1_section1_click(arg)

// Position on the correct Employeeid using SEEK()
if seek(val(arg),employees)
// Refresh the Employees Section
Lianja.getelementbyid("Page1.section2").refresh()
// Generate and print a report on the employee's orders
// using a hidden WebView Section and the Library report.rsp
myreport = createObject("webview")
myreport.url = "lib:/report.rsp?database=southwind&table=orders";
+"&fields=*&filter=employeeid=employees.employeeid ";
+"&heading=Orders for Employee {employees.employeeid}"
myreport.refresh()
myreport.print()
endif
endproc

http://www.lianja.com/documentation/...on-with-charts


Josip