Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I have below table
Estate_Code | Block_Code | Core_Code | Cluster_Code | UPRN | Asset_Level | Address | Post_Code |
ACO701 | NULL | NULL | NULL | NULL | ESTATE | NW6 5BA | NW6 5BA |
ACO701 | ACO603 | NULL | NULL | NULL | BLOCK | NW6 5BA | NW6 5BA |
ACO701 | ACO603 | NULL | NULL | 23021986 | PROPERTY | THE TIN TABERNACLE 12-16 | NW6 5BA |
ACO701 | CAM510 | NULL | NULL | NULL | BLOCK | NW6 5BA | NW6 5BA |
ACO701 | CAM510 | NULL | NULL | 58015470 | PROPERTY | FLAT A 18 NW6 5BA | NW6 5BA |
ACO701 | CAM510 | C1CAM510 | NULL | NULL | CORE | NW6 5BA | NW6 5BA |
ACO701 | CAM510 | C1CAM510 | NULL | 58015472 | PROPERTY | FLAT C 18 | NW6 5BA |
ACO701 | CAM510 | C1CAM510 | NULL | 58015473 | PROPERTY | FLAT D 18 | NW6 5BA |
ACO701 | CAM510 | C1CAM510 | NULL | 58116205 | PROPERTY | FLAT B 18 | NW6 5BA |
I am creating a matrix report the get the hierarchy like
now in the expand button if estate is selected it should show address,asset leve and post code of the estate on drilling down it should show the address of block and so on to UPRN. that is property.
and if there is no core and cluster then the UPRN should come directly under block.
Any help is appreciated
Thanks in advance!
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
19 | |
14 | |
10 | |
7 |