Does anyone how to diasble the "move to detail" option for a MS Access DAP
pivot table? I want to allow people to use pivot fields that are in the
pivot table's Page and Column Fields but restrict them from moving fields
into the Detail area (to minimize security issues with underlying data).
Because I still need them to be able to have limited pivot ability to move
fields from the Page and Column Field areas (and vice versa), this means that
the changing the "Allow Filtering" and "Allow Grouping" options in the DAP
Pivot Control properties to "FALSE" will not work. Can anyone suggest a
solution for my issue?
|
Similar Threads
