R,
No wildcards as such. You have several options, though,
a) If the parameter values are to be used for selection of rows (WHERE
clause of the query), consider using the RecordSelectionFormula property
instead of parameters. You in C# read the values of the params, and generate
the selection formula to pass to the report.
b) Send the parameters to Crystal as they are, and use one of the Crystal
Reports formula languages (VB-like or Pascal-like) to specify the selection
formula for the records. This is more powerful in general, but might be less
eficient as it may imply that Crystal will read all the records of the
original tables and do the filtering on the client machine (in this case the
web server).
Regards - Octavio
<ra***@hotmail.com> escribió en el mensaje
news:11**********************@g47g2000cwa.googlegr oups.com...
Hi,
I'm running a website with Asp.NET, and on one of the pages i have a
crystal report with 3 user-populated parameters. However, not all
params might be selected. Example:
Parameters:
1. EmployeeID
2. First Name
3. Last Name
Sometimes the report will be generated with all 3 params populated,
sometimes with only 2, or 1. Is there any way to pass a wildcard
character for any params that aren't explicitly set by the user? I
tried passing '%' for strings, but that crashed, saying "Input string
was incorrectly formatted" or something of that sort.
I appreciate any suggestions or workarounds.
Thanks.
Rafael Zavulunov.