Why doesn't RD return row key when remove duplicate rows is checked?
We have a report definition with remove duplicate rows checked, when this option is checked RD doesn't return any row keys. Hence, we cannot open this work objects. What is the reason behind removing the row keys? and what other option do we have to allow the user to open this work objects?
Have you include .pzInsKey as an explicit field in the RD.
Removing duplicates wont return Row Keys as each record is now an aggregate of multiple rows; in this case which row key should it return?
If the duplicate removal is to aggregate joined index or class data then, nclude the InsKey in your selections explicitly so that it forms part of the duplicate aggregation. i.e. each case will be represented uniquely.
We tried to add pzInskey in the RD columns and could see the PZInskey in the clipboard, but still couldn't open the Work objects. So looks like as soon as you check Remove duplicates option there is no way to open that case from the report view. We have opened SR-A20555 to track this issue