Hi all,
I am trying to build an accordion report like a business tree.
The first level has departments heads their demographics like name age sex etc.
The second level has the employees who report to these department heads.
The third level has those who report to second level.

I tried the D3 charts - Datatables but accordion is not working.

Can anyone help me out.

This message has been edited. Last edited by: FP Mod Chuck,

Accordion is a feature of Reports not Charts.

Hi Babak,
The datatables has a option for accordion.
https://datatables.net/examples/api/row_details.html

But the one in webFOCUS do not show this option.

If this is wrong.
Can you tell me how i can build a report with accordion as per my requirement

Have you tried the documentation?

WebFOCUS 8.1.05M

Search for "accordion" and find WebFOCUS Release 8.1 Version 05M > Reporting Language > Creating Reports With WebFOCUS Language > Navigating Within an HTML Report.

If you're using InfoAssist, create a REPORT not a chart with all the columns in it, then click the Format Tab, click Accordion and Run to see if that's what you're looking for.

The D3 charts you can currently use are here: https://github.com/ibi

In addition to what Babak said, make sure your 3 fields you want to accordion are sort fields in the report..

Thank you all
I tried the documentation.When i use accordion in WF it first shows just the customer name.
but my requirement is different.

My requirement : https://ibb.co/m7DHpn

The image is my requirement.

Hi Siva1925

The accordion report will not display the detail fields until the + sign is clicked on the row you want to expand.

Thank you
Is there any way to build a report like this in webFOCUS?

siva
if you are looking for creating a plain accordian report then use the below option in the appstudio ribbon while creating a report.



if you are looking for the exact look and feel of the report in your sample below. then you have to hold the report as a html and then make the styling at the HTML level.