Limiting data access 1

[paulcedarhill]

We have a sql database run with an Access ADP project for all our sales reps contact info. Within those we have multiple levels of permissions so that reps only see their contacts and managers can see everything.

Is there a way to push those permissions into Crystal Pro ver 9.2? Just having them enter their user name as a parameter will not satisfy management without password protection.

Currently I have a report in each reps personal folder on the windows 2K terminal server and have set permissions there. But that means I have 10 versions of every report that I have to keep updated.

The reps each access the terminal server through CITRIX Metaframe with unique user names

 

[hilfy]

You could write a program that would extract data to a separate dataset based on the user info and run the report based on that. Another option would be to write a program that the user would log-in to that would automatically set the parameters based on who the user is.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[Madawc]

In SQL, you can create a 'view' that gives just some of the fields (columns) of a record. Useful if users need some of it but should not see everything.

Ask in the SQL forum if you need advice on how to do this. (You'll find it listed if you click on my ID.)

Madawc Williams (East Anglia, UK)

 

[paulcedarhill]

Great Quote Dell,

Would you recommend a batch file to run this, will Crystal support command line entries for parameters?

I am a semi-intelligent end user, not a programmer, what type of Program is best to set these parameters?

 

[paulcedarhill]

Madawk,
I can filter the views fine within SQL but the problem becomes in filtering the records available from the crystal report. Management does not want reps to see each others customer base. I currently use a selection criteria parameter that only contains the reps user name, although some of them have more than one account for different product lines.

 

[hilfy]

No, you can't run it from a batch file. You would have to write a program (or have someone write it for you). I do most of my work in Delphi, although we're in the process of moving to C#. The easiest way for you to do this, though, might be through Visual Basic - there are examples in the Knowledgebase for how to do this.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.