Custom Report security

rbuser

I have developed an accounting package with multiple modules -- GL, AP, AR,
etc. Users have access to various modules based on their user profile. I
currently have implemented a custom designer for all users but want to
restrict certain data and reports according to the user's profile -- ie,
user 1 could access AP reports but not Payroll, user 2 could access AP, AR
and Payroll, etc.

Anyone with any thoughts on how to do this?

Thanks,
--
Bill Skelton

Landmark Data Systems, Inc.
Two Old River Place, Suite L
Jackson, MS 39202-3435
601-362-0303

nardmoseley

1. Add a security profile field to the rbItem table used by the
ReportExplorer.

2. Connect the ReportExplorer.ItemPipeline to a qryItem dataset that
contains a SQL where clause to limit the items based on the user's security.


--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com