×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

conditioning Parameters in Crystal XI

conditioning Parameters in Crystal XI

conditioning Parameters in Crystal XI

(OP)
Is there a way to condition the prompt of parameters?. for example I need a Parameter to either prompt for a date or an amount. in my case the same report should be able to run by date range or by amount range so I 'm thinking:
parameter 1 "Report Type" values "Date Range" or "Amount Range"
If the user selects "Date Range" Parameters for Begin Date and End Date should appear.
If the user selets "Amount Range" then parameters for "from amount" and through amount should appear.
I want to avoid all the parameters prompted if they are not needed, i.e if "date range" is selected, only the date parameters should be enabled.

Is there anyw way to do that?

Thanks in advance
Mpoblete

RE: conditioning Parameters in Crystal XI

Unfortunately, there is no conditional control over whether or not parameters appear. Any parameter that exists will appear every time (unless you want to program your own custom front end in .net or something else).

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks
http://www.kenhamady.com/

RE: conditioning Parameters in Crystal XI

Of course (depending on what version you have of CR) you could use optional prompts and have default values if necessary.

RE: conditioning Parameters in Crystal XI

True, and that might allows the user to skip some parameters, but Marco should note that the optional prompts will still appear in the parameter list.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks
http://www.kenhamady.com/

RE: conditioning Parameters in Crystal XI

(OP)
thank you guys, I'll have to find a workaround to achieve my users needs
MP

RE: conditioning Parameters in Crystal XI

Or you could write an application using either the .NET or Java SDK and have the application control the prompts and set them prior to running the report.

-Dell

Senior Manager, Data & Analytics
Protiviti
www.protiviti.com

RE: conditioning Parameters in Crystal XI

If the report doesn't contain subreports, you can create a main report with 2 on-demand subreports. Each subreport would have a variation on the parameter logic.

If your called subreport contains a subreport, the approach above won't work (a subreport cannot contain a subreport). But at least one 3rd-party viewer (see list on Ken Hamady's web site) provides a solution. Users of that viewer can double-click in one report to trigger another report. This avoids the subreport limitation. It also allows passing login and parameter info from the calling report to the triggered report.

- Ido

view, export, burst, email, and schedule Crystal Reports.
www.MilletSoftware.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close