Help Needed in Drill Down Report having more than one drill down level

Help Needed in Drill Down Report having more than one drill down level

Post by Natra » Tue, 22 Mar 2005 20:17:13


Hi All,

I have an issue with drill down reports.
I am having the following data in my table

ColA ColB ColC

A B Y
A1 B1 N
A2 B2 N
C D Y
C1 D1 N
C2 D2 N
E F Y
E1 F1 N

This might contain n rows.
Now i need to group on the column C if its value equals Y.
So, i want the report as same as in the following format.

+ A B Y
+ A1 B1 N
A2 B2 N
-------------------------------------------------------
+C D Y
+C1 D1 N
C2 D2 N
-----------------------------------------------------------
+ E F Y
+E1 F1 N
and so on .....


So, here i am having more than one drill down level.
So i am not sure how many groupings i should i make untill i hit the
database
Is there any way to achieve this type of functionality in a RDL file?

Can you please help me in this!

Any ideas or suggesstion would help me a lot!

Thanks in advance

Natarajan S


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system ( http://www.yqcomputer.com/ ).
Version: 6.0.859 / Virus Database: 585 - Release Date: 2/14/2005
 
 
 

1. Follow a relationship down to child level (drill down)

2. Drilling down to lower level records from Report

Hi Guys,

I would like to provide users with the ability to produce a report and then
click on the report to "drill" down and open a form displaying the record
source.

For example, using the sample template MDB, Issue Tracking, if the use
produces a summary report of all open issues, I want the user to be able to
"click" on the report issue # 10 and it will then display another "form"
showing more detailed information regarding issue # 10.

Can Access 2003 do this?

Regards
Greg

3. Sandisk Cruzer Drill Drill Drill

4. drill-down report to HTML in Crystal Reports

5. Need ASP/SQL data drill down help

6. In Report Builder, can you have a drill down that links to another report?

7. drop down lists and 'drill down'

8. drop down list that drill down

9. QBE Count across two "drill-down" levels

10. Remove A level of Drill downs

11. Control column header based on if the drill-down level is being shown?

12. QBE Count across two "drill-down" levels - thanks!

13. Can't get drill down report working...

14. Drill Down Reports

15. drill-down report