create Drill-down in excel from Visual basic

[Elsje]

Hi everyone,

I need to create an excel with drill-down on 2 levels.
I give an example.

This is what I need to become when i open my excel.
+ header 1
+ header 2

If you click on + bij header 1 I want to get the following
- header 1
+ detail 1
+ detail 2
+ header 2

If you go deeper I want the following
- header 1
- detail 1
row 1
row 2
+ detail 2
+ header 2
and so on....

When i use an rdlc and I export it from there it makes the drill-down in excel. But I need to do this now directly to excel.
I hope someone can tell me how I need to do this.

Thanks in advance

Greetings
Elsje

 

[Bluejay07]

Since you are dealing with Excel, you may get a better response in forum707.

If at first you don't succeed, then sky diving wasn't meant for you!