Problems using view-time selection formula and proc. ext. simultaneously
We are experiencing problems with our in-house developed .NET 3.5 solution. Our report uses a processing extension for managing row-level security (we cannot use filters, since we need real-time security checks for CR instances).
However, when we try to apply a view-time selection formula on the report in our .NET application, it never takes effect for reports that also use the processing extension.
Example: There are 1000 rows in the report instance. For the curren user, the processing extension filters away all rows but 100. Among the remaining 100 rows, the view-time selection formula is to select only 10 of those rows. However, even after setting the view-time selection formula, there are still 100 rows visible to the user.
The very same code works fine when the processing extension is disabled. Have anyone else experienced this problem, or know what we should try to fix it or work around the issue?