Conditionalized Parameters???

[5timesnc]

Good Morning,

Our company has multiple offices. 90% of the time the users will only need information for that office, which we can set through views and the select statement. In some cases, management will need their own office, and in others will want all offices reported. Is it possible to have a parameter only display for them (management) based on one of the tables in the report, such as a user group we have defined, or is it necessary to display that parameter for all users.

Thanks in advance!

 

[Thadeus]

How are the end-users running the reports? Do they each have Crystal on their desktops or are you using some front-end?

Thadeus

 

[Ngolem]

you can certainly do this

Your parameter would guide the user as to which choice

this is the only tricky part. If there are only a few of them then you could provide a pick list of choices from which to chose....if the offices have an ID number of some sort that is well known that could be the choice...or you could have them type in (least wanted option) the office location

Make the Main office your default for the parameter and advise your user to type "ALL" for all offices

In the record selection formula would have something like this

if uppercase({?Office}) = "ALL" then
True
else
{table.office} = {?office};


Jim Broadbent