Skip to Content
0
Jul 04, 2014 at 04:33 AM

Implementing Drill Down...

23 Views

Dear All,

I'm working on SAP Crystal Reports for Enterprise 4.0 SP 6 Patch 2 and my goal is to design a Sales Review report using this tool. My Data Source for the analysis will be Universe.unx. Following is my scenario for the report:

1. First Level: National Sale: ( it can be visualized using Column Chart (Quantity will be analysed against time (Calendar year/month))

2. Second Level: Regional Sales: (Quantity will be analysed against time (Calendar year/month))

3. Third Level: Zonal Sales: (Quantity will be analysed against time (Calendar year/month))

4. Fourth Level: Customer Sales: (Quantity will be analysed against time (Calendar year/month))

National Sale and Regional Sales should show on first page and when a user click on any Regional Sales Chart it will show next level Zonal Sales of the Regions and on Zonal Sales Chart when user click on any chart of Zonal Sale it should take the user to final level of Customer Sales of selected Zone.

1. How can I accomplish this goal?

2. Do I need to use drill down? if yes then how?

3. How the queries with prompts or same prompts be linked or provided with prompts values?

4. Should I use column chart for this analysis or should other objects be used?

I will appreciate your reply a lot!

Many Thanks!!!

Tariq Ashraf