Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

enduser explorer and permissions

edited December 2002 in End User
I have a enduser explorer and i want to be able to show the reports that
certain users are allowed to - permissions. some users should not have the
ability to view certain reports - how do i manage this?
Our users run the reports from the report explorer. how can i manage user
specifc issues like showinmg the report that a certain user can see in
report explorer in the same DB .. from rb_item. i store my reports in the
DB.
thanks

Comments

  • edited December 2002
    Add an ID field to the database table for the folders and items so that you
    can add a filter on the folder and item datasets when the user runs the
    application. That would be the easiest away to do it.

    Here's and example of configuring the report explorer with read-only added
    to it:

    http://www.digital-metaphors.com/tips/ReportExplorerWithReadOnly.zip

    Cheers,

    Jim Bennett
    Digital Metaphors

  • edited December 2002
    I have a filter but when i do that, i am not able to post anything that is
    design the report - i get an error. is that possible.. designing as well as
    viewing.
    thanks

  • edited December 2002
    to be precise i get a recod/key deleted error.
    thanks

  • edited December 2002
    Did you try running the demo I posted a link to? The demo is in RB 7
    format. There is some info about how to do it at the top of the form of
    that project:

    {This ReportExplorerForm has been modified to support a ReadOnly field in
    the
    rbItem table. This field allows you to prevent users from modifying
    certain
    reports. When the ReadOnly field contains a 'T', and the report is
    selected
    in the Report Explorer, the following items are disabled:

    Main Menu:
    File | Open
    File | Delete
    File | Rename

    Popup Menu:
    Delete
    Rename

    Toolbar:
    Open

    In order to achieve this, a variable and method were added to the form:

    FReadOnly - which tells whether the currently selected item is read only.

    UpdateReadOnlyStatus - which is called each time the selection changes.
    This routine updates the value of FReadOnly and disables the various
    user interface options as appropriate.

    One final tweak was necessary in the ppmReportsPopup event handler (the
    method that fires when the ListView is right-clicked). The Rename popup
    menu option had to be enabled based on the value of FReadOnly, instead of
    just being set to True.

    Finally, the Template.OnSaveEnd event has an event handler assigned in
    the myEURpt form. Anytime a new report is created, it is automatically
    set to Read Only.
    }


    Cheers,

    Jim Bennett
    Digital Metaphors

  • edited January 2003
    THis is kind of what i want - but i dont them to able to preview it even so
    a lot of modifications have to be made.. i am starting to implement it - if
    i have more issues will contact the newsgroup.
    thanks

  • edited January 2003
    thankyou !! it works like how i want it to,,,

This discussion has been closed.