Create a parameter with criteria

[vshapiro]

I have a parameter out of Staff_Table.Last_Name. This table has a field Staff_id.

I need to apply formula approx like this:
Select Staff_Table.Last_Name where
Staff_Table.Staff_ID = Project_Table.Staff_id and
Project_Table.Staff_Type = 01.

So, for my parameter I need only names with staff_type = 01 and this two tables connect through staff_ID


Thank you

 

[synapsevampire]

Please post technical information, such as Crystal version, database used and how you're obtaining data.

Also the use of the term parameter seems wrong, if you want to limit rows in the report use report->edit selection formula->record:

{table.staff_type} = "01"

Or if you want to enter the value to limit, create a string parameter and then use:

{table.staff_type} = {?Staff_Type_Parameter}

-k

 

[vshapiro]

Sorry. I am using Crystal 9.0, Oracle DB getting data with OLE DB.
But I still did not understand how to do it. Could you please give a little more details.
Thank you very much

Veronica

 

[IdoMillet]

It sounds like you need a way to limit the default values in the parameter list.

If the values should be populated once (static list), you can create a report, export to a text file, and then import the values into the parameter dialog.

If you need the parameter values to reflect data at the time the report runs, this functionality is provided by at least one of the 3rd-party crystal report viewers listed at:

http://www.kenhamady.com/bookmarks.html

Cheers,
- Ido




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

http://www.MilletSoftware.com

 

[vshapiro]

Thank you. Looks like I need to go to 3rd party.