Hi I am using crystal reports version XI release 2
I have a "Teams" parameter in report which can take the multi values.I have a "Leads" field in the database.
The leads filed contain names of leads seperated by commas.
Since the leads can be more than one so we have stored the leads names in the Leads field seperated by commas.
Here is the sample data for Leads Field
'Mark roaster, John Italina,Raghu via'
'jack ride,jim clark'
'janu chin,joy ult'
Suppose the user has given these names in "Teams" parameter
Mark roaster
jim clark
Raghu via
Then the report has to select only the rows if they have alteast one of them.
so from the sample data we get
'Mark roaster, John Italina,Raghu via'
'jack ride,jim clark'
Any help is greately appreciated.
I have a "Teams" parameter in report which can take the multi values.I have a "Leads" field in the database.
The leads filed contain names of leads seperated by commas.
Since the leads can be more than one so we have stored the leads names in the Leads field seperated by commas.
Here is the sample data for Leads Field
'Mark roaster, John Italina,Raghu via'
'jack ride,jim clark'
'janu chin,joy ult'
Suppose the user has given these names in "Teams" parameter
Mark roaster
jim clark
Raghu via
Then the report has to select only the rows if they have alteast one of them.
so from the sample data we get
'Mark roaster, John Italina,Raghu via'
'jack ride,jim clark'
Any help is greately appreciated.