Active X Viewer & Multiple Value Parameters

[justatad]

I am trying to set up a report that will be used with Crystal's Web Viewer (Active X).

In this report I would like to select multiple values per perameter (pop-up window in the viewer).

Is there a way to add multiple values (either in the creation of the report, or the end-user entering in a character that crystal recognizes means multiple values)?

[example: value1&value2&value3 - this would filter based on these three values]

Thank you my fellow reporters!

 

[bjrollet]

I you are using ASP, add the following method after you open the report object and set its .Name property:

Session("oRpt").RecordSelectionFormula = "{Table1.Field1}='Smith'"

 

[bjrollet]

Actually, for multiple values, it should be like this:

Session("oRpt").RecordSelectionFormula = "{Table1.Field1} in ['Smith', 'Jones', 'Rogers']"

A good tip to see the selection formula is to go into CR and choose the Select Expert, then click on Show Formula, and you will see the correct syntax you need to pass in.

 

[justatad]

Thank you.

---
Here is a look at the Crystal formula (without parameters):

{x.abc} in ["0", "1", "2", "3"]

Here is the way it would look if I just wanted to enter based on 4 parameters:

{x.abc} in [{?parameter1}, {?parameter1}, {?parameter3}, {?parameter4}]

---

However, I don't think that this solves my problem altogether even with the asp. I would like (when prompted) the user to type in "0", "1", "2", "3" (to infinity) instead of writing seperate reports (with parameter variations).

Any ideas?