hi there i am using sql server 200

[nat35]

hi there
i am using sql server 2000 sp and cr7 to create a report
how can i show fields in report for particular user
example if user from account group he is able to see fiels
invoice no and amount if user is other -then not
report has published on citrix program neighbourhood
thank you
nat

 

[chelseatech]

Use a View to retrieve only records for the current user and then use SQL server security to retrict your suers to using the view rather than the raw table. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm