471,599 Members | 1,390 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,599 software developers and data experts.

passing wildcards to crystal report

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.

Nov 17 '05 #1
1 2380
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.

Nov 17 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Mariame | last post: by
reply views Thread by lewindha | last post: by
2 posts views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by Anwar ali | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.