Solved

Optional Parameters - Discrete or multiple selection

Posted on 2004-04-02
6
530 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
  • 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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

856 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