EPM 10 SP 10 NW
I have a report with zero suppression on rows. Also i have two columns as local members in columns one for epmsavecomments formula while the other column is for comment entry.
As the report expands the comments formula replicates allowing user to enter and save columns in the corresponding cell next to it.
Issue: When report expands to 10 rows , user enters 10 comments. On selection change if the report renders only 3 data rows, additional 7 comments from earlier rendering still remains on the report after refresh.
How do you configure to clear those redundant comment cells as the report expand and shrink based on report data .. i am sure i must be missing some configuration setting on the report.
Please see attachment for details