Hi, I have looked up accordian and tree strcuture , but could not find a solution to my problem. I have a parent child hierarchy defined in a synonym and a simple FML report on it. The report displays hierarchy with indents but I would like a have a + sign on the FOR field that I can expand the children. I have tried ON TABLE SET EXPANDABLE ON, but doesn't work. Here is the report and output,
TABLE FILE ENTITY_HIER SUM AGENTNUMBER NAME FOR CHILDID '&ENTITY' WITH CHILDREN ALL WHEN EXISTS AS CAPTION LABEL NAME ON TABLE PCHOLD FORMAT HTML ON TABLE SET BLANKINDENT ON ON TABLE SET HTMLCSS ON
REPORT OUTPUT ( I put dots to preserve spaces)
UNITED SOLUTIONS ALLIANCE..............US001...IMO ....IGANTE,CHARLES W...........................US002...Principal .......DUNN,GERALD L..............................US014...Agency ...........MENDENALL,ROBERT A................US015...AgentThis message has been edited. Last edited by: Kerry,
App Studio Version 8202 windows Platform SQL Server 2008/2012
September 16, 2009, 06:48 AM
Anmol
getit, you should get the required output from the following code, i am able to output the tree structure...using "on table set expandable on" Try using this code....you will getit.....
TABLE FILE EMPDATA
SUM
SALARY
BY DEPT
PRINT
SALARY
HEADING
"Accordion Report"
-*ON TABLE SUBFOOT
-*"<callJS "
-*" "
ON TABLE SET PAGE-NUM OFF
ON TABLE SET EXPANDABLE ON
ON TABLE NOTOTAL
ON TABLE SET ONLINE-FMT AHTML
ON TABLE SET HTMLCSS ON
ON TABLE SET AUTODRILL ALL
let us know if any issues....still there...
regards, anmol......
WebFocus7.6.2, WebFocus 7.1.1,Windows HTML, PDF and Excel
September 16, 2009, 10:50 AM
getit
I know this code works.. but my issue is, I need expandable on a FOR field. Ex: FOR CHILDID which is a hierarchy field in FML.
App Studio Version 8202 windows Platform SQL Server 2008/2012
September 25, 2009, 08:20 AM
Kathy P
Why not make the FOR field a drill down field?
Kathy Phillips Web FOCUS 8.2.05.14, 8.1.05, 8.08, 8.0.7, 8.0.5,8.0.2m, 7.6.10,7.7.03 Windows
September 25, 2009, 09:24 AM
Hua
getit, are you talking about the FOR field panel not being able to expand when you designing your FML? I have the similar problem if I am not mistaken.
Hua
I realized my problem is different than what is posted here. And found the cause of my problem - when I turn off the qualified names, the tree structure showed up in the FOR field panel. Sorry for the disruption.This message has been edited. Last edited by: Hua,
Developer Studio 7.6.11 AS400 - V5R4 HTML,PDF,XLS
September 25, 2009, 10:42 AM
Kathy P
When I did this back in 2004, I could not show the actual plus/minus sign, but instead did a drill down report on the value they wanted to see the children for, so it was another heirarchy report. The report showed the level of children you wanted to show for the value you clicked on. They could go back and forth. They would click on the back button to go back to the first report and select a different value to expand (which actually would be the same drill down, just a different value). Also, the first report only showed the highest level. Hope this helps.
Kathy
Kathy Phillips Web FOCUS 8.2.05.14, 8.1.05, 8.08, 8.0.7, 8.0.5,8.0.2m, 7.6.10,7.7.03 Windows
September 25, 2009, 10:47 AM
Kathy P
report sample
FOR FIELD --------- Bank One ........ Bank Two ........ Bank Three
Each of the above banks are a for field and they are a field that you can click on and drill down. Say you click on Bank Two, the next report would show
Bank Two Office one Value center.... Office two value center 1 value center 2 etc.
Then you could click on the back button and it owuld take you back to the first report. The second report would only be for the value clicked on. IBI doesn't support hierarchy within a hierarchy that I know of. Would be nice though. Regards, Kathy
Kathy Phillips Web FOCUS 8.2.05.14, 8.1.05, 8.08, 8.0.7, 8.0.5,8.0.2m, 7.6.10,7.7.03 Windows