Achieve Mulitlevel Drill down in Crystal Reports 1

[pko123]

Hi,
We have a requirement where we need to create mulitlevel drill down report along with summary numbers

For example
first level we want to show report for ITEMS
lets say

[ul]
[li]item A[/li]
[li]item B[/li]
[li]item C[/li]
[/ul]

if user click on itemA, that should expand

[ul square]
[li]item A[/li]
[ul circle]
[li]item i[/li]
[li]item ii[/li]
[/ul]
[li]item B[/li]
[li]item C[/li]
[/ul]

if user click on itemA & item B then only these two items should expand and item C remain the same

[ul square]
[li]item A[/li]
[ul circle]
[li]item i[/li]
[li]item ii[/li]
[/ul]
[li]item B[/li]
[ul circle]
[li]item i[/li]
[li]item ii[/li]
[/ul]
[li]item C[/li]
[/ul]

at last level if user click on item i under item A then that should expand further

[ul square]
[li]item A[/li]
[ul circle]
[li]item i[/li]
[ul square]
[li]item 1[/li]
[li]item 2[/li]
[/ul]
[li]item ii[/li]
[/ul]
[li]item B[/li]
[ul circle]
[li]item i[/li]
[li]item ii[/li]
[/ul]
[li]item C[/li]
[/ul]

Is it possible to create such a report in crystal or xcelsius or webi.
Please let me know if anybody knows.

thanks in advance

 

[lbass]

If you hide successive groups in Crystal you can drill down on selected group instances; however, each drilldown opens a new window, so you must navigate between windows. You cannot change the view in one window only in order to get an overview, which is what you appear to want to do.

-LB

 

[kenhamady]

This is called "in-place" drill-down and can only be done (AFAIK) in one way, using a third party viewer called DataLink Viewer. It also requires that you construct the report in a specific way. See the LINKS page on my site for more info on DLV.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/

 

[IdoMillet]

You can see a video demonstration of in-place drill-down with a Crystal report using the tool suggested by Ken at:

http://www.milletsoftware.com/datalinkBenefit.htm

hth,
- Ido

view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com