I was under the impression that I could specifically restrict certain users (and Groups) from viewing reports through the Secuirty Manager, Layout and Layout Element Settings.

When I select a Report Layout, no elements nor Groups are available to change security settings on.  (It would be nice if I could select a report and assign access rights to individual users, not groups here).

So I was left with programming my REPORTS command button based on the user logging in.  Everything works the way it should as depending on the user, a pop up menu appears with only their available reports to choose from.  However,  I need someone to critique my programming style and offer any advice on how to make it more efficient as I am thinking that there is a better way to accomplish this through the use of stringarrays/loops (??).

Eventually things will get more complex in other databases as I progress.

Code pertaining to the users is as follows:

//Determines Users Choice of reports

     If sGroup = "ADMINISTRATOR" OR
        SGroup = "EXECUTIVE MANAGEMENT" OR      
        SGroup = "ACCOUNTING" OR      
        SGroup = "IT" OR      
        SGroup = "ADMIN" THEN
     {      
           vReport1 = "FP500 PROSPECT FOLLOW UP - CENTRAL (Preview);FP500 PROSPECT FOLLOW UP - EAST (Preview);"
           vReport1 = vReport1 + "FP500 PROSPECT FOLLOW UP - MISSISSAUGA (Preview);FP500 PROSPECT FOLLOW UP - NORTH (Preview);"
           vReport1 = vReport1 + "FP500 PROSPECT FOLLOW UP - SOUTH (Preview);FP500 PROSPECT FOLLOW UP - TORONTO (Preview);"            
           vReport1 = vReport1 + "FP500 PROSPECT FOLLOW UP - WEST (Preview);"
           vReport1 = vReport1 + "FP500 PROSPECTS - CURRENT STATUS - CENTRAL (Preview);FP500 PROSPECTS - CURRENT STATUS - EAST (Preview);"
           vReport1 = vReport1 + "FP500 PROSPECTS - CURRENT STATUS - MISSISSAUGA (Preview);FP500 PROSPECTS - CURRENT STATUS - NORTH (Preview);"
           vReport1 = vReport1 + "FP500 PROSPECTS - CURRENT STATUS - SOUTH (Preview);FP500 PROSPECTS - CURRENT STATUS - TORONTO (Preview);"
           vReport1 = vReport1 + "FP500 PROSPECTS - CURRENT STATUS - WEST (Preview)"
           vReports = @PopUpMenu(vReport1, "SELECT A REPORT")      
     }
     else

     If sUser = "CJW" then
     {
           vReports = @PopUpMenu("FP500 PROSPECT FOLLOW UP - CENTRAL (Preview);FP500 PROSPECTS - CURRENT STATUS - CENTRAL (PREVIEW)", "SELECT A REPORT")      
     }
     else

     If sUser = "RRK" then
     {
           vReports = @PopUpMenu("FP500 PROSPECT FOLLOW UP - EAST (Preview);FP500 PROSPECTS - CURRENT STATUS - EAST (PREVIEW)", "SELECT A REPORT")      
     }

As stated above, when you select A Report Layout, it does not give you an option to set any security settings such as groups and their respective Read/Write/Execute settings. 

It seems the Security Manager has been designed to only allow you to set security on the Forms and their respective individual layout elements, and not on reports.  Is this correct ?

Thanks,

Louis

Bob:

I would love to be able to control reports from there, otherwise, it will require extensive programming in some databases to deal with users specific reports.

Thanks,

Louis

I am encountering this problem now as I configure security settings for my databases.  Was a workaround ever designed, or perhaps this is something taken care of in 2.0?