Skip to Content
0
Former Member
Jan 18, 2012 at 02:00 PM

Dynamic EVDRE expansion

67 Views

Hi All,

we have a requirement of dynamic expansion of evdre based on the user selection.

Out of 6 dimension, user may select as many as he wants, and based on the selection we need to expand the evdre and generate the report in a different sheet.

We tried to give the dimension from the excel reference, but due to the unselected dimension in selection sheet, we received EVDRE error.

When we tried to restrict the the EVDRE range cells, we received the below error:

"runExpand: RowKeyRange<>RowExpandOptions wks:Sheet1".

Please suggest on it and provide a workaround to achieve the requirement.

Thanks and Regards,

Umesh Jethwani.