Idea for Drill Down Reports -- Will it work?

[kgentile1010]

Hi,

 

So, I've come up with this design for drill down reports. It's a lot of work and not easily extensible. Can one of the forum admin look at my ideas and let me know if there is a better way, (please I hope).

 

So, I read somewhere in the forum that to implement the drill down, we need to

 

-- create the report

-- have each dimension field be a url to a subreport/newreport

-- the subreport/newreport would be a 'drill down' version of the same report.

 

===================================

Here are my ideas and problems

 

For each drill down depth/level, I create a report. To illustrate, my dimension is locations -- corp -- division -- store..

 

My first report would be a list of locations and counts at the top corporate level

 

Corp Office 1

Corp Office 2

Corp Office 3

 

When I click on the Corp Office 1 - as a link, it would run a NEW report that would return data and counts for Corp level and the Division level.

 

The report would be built to return the data as follows

 

Corp Office 1

Division A

Division B

Division C

Corp Office 2

Division D

Division E

Division F

Corp Office 3

Division G

Division H

 

THEN, to display only the level 2 fields under the Corp Office 1 section, I thought I could use

a PrintWhen expression to NOT print the other level 2, I can use the 'parentlocation_id' to filter

on that.

 

At this point, the Division Field data would also become links, and then clicking them would go to the servlet,

pass in the parentlocation_id and then run a new report that would show level1, level2, and level3.

report. Which would show the following

 

 

Corp Office 1

Division A

Division B

Store 123

Store 234

Store 345

Store 456

Division C

Corp Office 2

Division D

Division E

Division F

Corp Office 3

Division G

Division H

 

Again I'd try to use the PrintWhen expression to only print the data for Corp Office 1, DivisionB, stores

 

 

====================================

 

My questions --

 

1) will this work? and

2) is there an EASIER way.

 

this is gonna take us a lot of work. Are there any shortcuts? Or any other ideas?

 

Are there ways I can work with the data to do this?

 

================================================

[skronline]

Hi kgentile1010,

 

I am also looking for a solution on this. Did you get any solution? pls help me.

 

 

With thanks and regards,

skronline