Hello,
I have the following problem;
I have a report that has a link to a URL column. This column displays an edit icon for the link. The report displays a list of records dependent on the users privileges. A user can have the privilege SELECT or EDIT for all or some of the records. Additionally I would like to display an icon only on the column for the records where the user has the privilege EDIT. I want to put a conditional statement on the edit icon that looks something like this;
Conditional Display > Exists (SQL query returns at least on row) > SELECT id FROM table_name WHERE id = #ID#
I note that the record can be referred to by the substitution string #ID# when making the column a link column for downloading an uploaded document. But the above method (Using the #ID# substitution string) returns an error.
So the report would look like the following, an icon would only display on a record if the user has the privilege to EDIT.
ID EDIT
-----------
1 ICON
2
3 ICON
4 ICON
So the record for ID = 2 the user would be able to SELECT but they would have no EDIT rights on it, and so would not be able to link to the edit form.
Thank You
Ben
Edited by: Benton on Oct 5, 2009 11:31 AM