Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameter group 1

Status
Not open for further replies.

quesnell

Technical User
May 14, 2003
4
0
0
GB
I would like to create a group that uses a single value in the parameter to filter the report on a list of values.

Any Ideas would be useful.
 
I don't know what that means.

A group is something inserted into Crystal to combine data based on the entities within that group, as is the case for a group in SQL.

How could a group influence a parameter (an entity chosen prior to determining any groups)?

Try posting software version, database, example data and the expected output.

Descriptions often fail to convey much to anyone else.

-k
 
You can do a formula field that applies different tests based on a parameter, e.g.
Code:
(@Param = "M" 
 and {your.value} in ["Tom", "Dick", "Harry")
or
(@Param = "F" 
 and {your.value} in ["Mary", "Jane", "Sally")
Put this beside the unselected data, where it will say True or False, to check that it works as expected.
Then put the formual field name in record selection, where records will be chosen only if they match.

PS. It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top