Drill Through Help

[cottrera]

Hi 

I have model of individual properties and also a parent property (Block and the flats / appartments within the block)

The individual dwellings / appartments have a unit reference and the main block for which these dwelling appartments are in ha an associated stock reference.

I have a report with a main page, first drill through page and a second drill through. The end user will be drilling to the second drill through via the first drill through. 

So the main page will drillthough into addtional details page (first drill through)  relating to the Unit ref, this works fine. See

example of main page and first drill through

Main Page
Unit ref	Associated stock ref	Address	Highest # repairs	Comments
5260	3432	xxxx	58	xxxx
8631	3433	xxxx	83	xxxx
10560	4654	xxxx	111	xxxx
4343	765	xxxx	37	xxxx
11883	8765	xxxx	106	xxxx
10230	8765	xxxx	122	xxxx
9607	3564	xxxx	87	xxxx
7912	3536	xxxx	120	xxxx
11904	465346	xxxx	25	xxxx
10365	8765	xxxx	26	xxxx
7381	67545	xxxx	27	xxxx
3797	34579	xxxx	49	xxxx
11786	64789	xxxx	38	xxxx
11707	548737	xxxx	106	xxxx

First Drill Through
Unit ref	Associated stock ref	Job Ref	Trade
5260	3432	3523454	PLUM
5260	3432	65463436	PLUM
5260	3432	5646475653	PLUM
5260	3432	6753456	PLUM
5260	3432	785634	ELEC
5260	3432	897653345	ELEC
5260	3432	6745456	ELEC
5260	3432	7654234	ELEC
5260	3432	6543234	CARP
5260	3432	654	CARP
5260	3432	34567654	CARP
5260	3432	3457	CARP
5260	3432	987876	ALARM
5260	3432	76554	ALARM

However when I am in the first drill trhough page and I would then like to drill through to the second drill through page to view the Associated stock ref details. The page retains the original filter Unit ref.  

Below is an example of the second drill through page

Second Drill through from first drill through
Associated stock ref	Unit ref	Job Ref	Trade
3432	5260	68714	PLUM
3432	4949	76609	PLUM
3432	4559	68348	ALARM
3432	5225	70956	ALARM
3432	4554	73515	ALARM
3432	4821	77978	ALARM
3432	5015	73406	ALARM
3432	5139	66207	ALARM
3432	5067	76412	ALARM
3432	4895	75972	PLUM
3432	4693	67658	CARP
3432	4824	66503	CARP
3432	4804	69725	ALARM
3432	4882	76529	ALARM
3432	4588	75763	CARP
3432	5333	66540	CARP

Hope this make sense

RIchard

[cottrera]

Hi Pragati

Your solution worked 

thank you

Richard

[Pragati11 · Accepted solution]

HI @cottrera ,

On what column is your second Drill-through page created? It should be on Associated stock ref.

So from 1st drillthrough page, when you right click on a row, it should take you to 2nd drill-through page showing information for relevant Associated stock ref.

Thanks,

Pragati