Hi All,
Can We have tree view drill down in webfocus tabular reports.

when the report is displayed , + sign will be displayed against the each row of the first column text. Upon clicking on the + sign all the records pertaining to the data are shown below (like drilling down)


eg

colmn1
+A
+B


after expanding
Column1

-A
..A11
..A22
..A33
+B

A tabular report similar to the above should be generated. Can any one suggest me some ideas.

Thanks,
Srinivasan M

Srinivasan

try this code

TABLE FILE CAR
SUM RCOST DCOST
BY COUNTRY
SUM RCOST DCOST
BY COUNTRY
BY CAR
SUM RCOST DCOST
BY COUNTRY
BY CAR
BY MODEL
ON TABLE SET EXPANDABLE ON
ON TABLE SET HTMLCSS ON
END

Frank,
Thats really great, exactly which I wanted. Thanks a lot.

Srinivasan

can we have the expanded list at the bottom instead of showing it adjacent to the field


Thanks,
Srini M

Srini,

That you would have to code yourself e.g. no param on EXPANDABLE to do it. If you search through the posts using the search facility (top right) you should find some examples that people have posted that will achieve this for you.

WARNING You have to know the number of levels that you will have in your report and the code can get a bit messy.

T