Hi,
We are working on the ACCORDION reports in WF.
However, instead of the horizontal expand, we need the expanded column vertically downward.
Eg.
All Contracted
+ England
+ France
...
All Expanded
- England
2000 4 DOOR BERLINA
2000 GT VELOCE
- France
B210 2 DOOR AUTO
COROLLA 4 DOOR DIX AUTO

My question is whether we can utilize the existing Accordion Report feature and customize it according to this requirement?
OR we would need to write our own JS code to achieve this functionality.
Any pointers would be appreciated.

Thanks
Syed

Syed,

I don't see how you can accomplish what you want with EXPANDABLE.

Maybe someone else can give you some js code...

Hi Daniel
Thanks for writing in.
Actually the accordion report feature in WebFOCUS makes me wonder why IBI could not have gone a step ahead and used javascript to provide the expand/contract the way I have mentioned in my previous post.
Nowadays, everyone seems to be asking about this kind of drill-down feature. I have worked on multiple projects, and in most of them, there was a strong need for such a drill-down (expand/contract) for several reports.
I personally feel that the next versions of WebFOCUS should have this feature!

Thanks
Syed

Syed,

There is an old-style way to do what I think you want to do and I used to have a fex to demonstrate it but I have deleted it. It consisted of generating a floating TOC that if I remember correctly would expand the report vertically. My old brain is having difficulty remembering but maybe someone else will recollect. I will continue thinking on this.

Syed,

I found it. Double-click on the little image to expand it.

TABLE FILE SHORT
PRINT PROJECTED_RETURN
BY CONTINENT
BY REGION
BY COUNTRY
BY HOLDER
BY TYPE
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET COMPOUND 'BYTOC 5'
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
STYLE=NORMAL,
$
ENDSTYLE
END

Nice!! Thanks Ginny, for posting this workaround.
Though I'm not sure whther the client will be satisfied with this approach, but this is certainly good to know.
It would have been much better if the same fucntionality is achieved on the same HTML page as the report is.
Ginny - Is there any constraints on the no. of records/rows for this approach?

Thanks
Syed

Ginny,

Good thinking "out of the box" to propose TOC!

Thanks, Danny.

Not that I know of, Syed. Experiment.

Sure.
Thanks for your help on this.
I'll play with this feature and see if there are any limitations.If I come up with any - I'll surely post them here for your information.

Thanks again
Syed