Solved

Optional Parameters - Discrete or multiple selection

Posted on 2004-04-02
6
531 Views
Last Modified: 2008-03-10
Hi there
Using Crystal Version 9.0 onto a SQL database.
Users would like to be able select single or multiple parameters from below list:-
* Product Name (string)              - discrete
* Product ID (number)                - range
* Suburb/City (string)               - range
* Product Category (String)          - range
* Status (string)                    - discrete
* Expiry Date (date)                 - range
* Last edited (date)                 - range
Can I achieve a selection criteria like this in Crystal?
Must be able to accept 1 or multiple selections from list.
Thanks in advance.
0
Comment
Question by:iceruby
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
6 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 10740695
How will they be selecting?

Are you running from CR or from an application?

I have an application that does exactly that.  I built a form that allows the user to enter the selections some can be ALL then once they say PROCESS I check each parameter and build a filter or where clause that is passed to the report.  The users can select discrete, date ranges and like strings.  

mlmcc
0
 

Author Comment

by:iceruby
ID: 10741335
At this stage users selecting within crystal.

What does your application run within/require?



0
 
LVL 100

Accepted Solution

by:
mlmcc earned 250 total points
ID: 10745912
My application runs in VB6 and requires VB6, Crystal x Developer version (we are using v8), and some third party controls (we use Sheridan dropdowns rather than the VB ones.)

It could be written in C, Delphi, asp, html,Java.

I haven't done much with Crystal parameters but i think you can do a selection as you intend.  You need to build parameters for each and allow default values of ALL or *

mlmcc
0
 
LVL 1

Assisted Solution

by:srini_jg
srini_jg earned 250 total points
ID: 10746027
Hi

There is sample available in Crystal support site. the document is titled cr9_vb_rdc_parameter.
Download this from the business objects support site.

All the best

Srini
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question