I have a linked report for editing some of the values in the row, but on the popup that appears I want to show some uneditable values from the row. Is there a way to disable the fields so the user doesn't think they can change them?
The stored procedure ignores the values passed into it from the popup so there's no fear of the user accidentally changing a value. But I don't want the user to think they should be able to change those values and submit bugs when they cannot.
For example, the
items table has
price. The user can change an item's name and price but not the ID. However, products are known by their item ID and so I want to show it on the popup. Is this possible?
select 'dbr.report', 'sp_DBR_Tier_Edit', '[ID]', 'popup', 'inItemId=[ID]', 'inName<=[Name]', 'inPrice<=[Price]'; ^
= causes the parameter to be hidden, and the
<= allows the parameter to be modified. Is there another form that shows and disables the parameter?