We have a report that is drillable but have, by mistake typed over the heading cell with a name. This name should change when we drill down but the heading now stays with the words typed in. We have tried typing in =NameOf([variable name]) but when drilling this stays as the top level variable name.
Any ideas to get round this will be much appreciated as we have drawn a blank so far and would rather not build the report again.
Thanks in advance.
Rob.
robbiebha (BOB member since 2004-08-05)