Security Code to RAS based report

[dhgrrg]

I've got Identical reports for three locations (Report1,Report2,Report3). The only difference is Location which is hard coded in the Select Menu.

I want to set up 3 security codes

Location 1 = 116 Allows Report1 to run
Location 2 = 272 Allows Report2 to run
Location 3 = 433 Allows Report3 to run

Any other security code entry causes report to fail.

Basically for Report1
if (entered security code = 116) then 'run report' else 'reports does not run'

I can't enter it as a parameter so how do I enter it

This will keep other managers from getting to other property reports

How do I accomplish it.

 

[IdoMillet]

You can do all of this in a single report:

1. Create a parameter called security_code.

2. In the record selection formula add a condition that looks like:
-------------------------------------------
({?security_code}=116 AND {Location}=1)
OR
({?security_code}=272 AND {Location}=2) OR
({?security_code}=433 AND {Location}=3)OR
-------------------------------------------

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com