Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

pick multiple values from Parameter Field

Status
Not open for further replies.

ashark

Programmer
Nov 21, 2002
31
IN
Hi Group,
Is it possible to pick multiple values from Parameter Field in Crystal Reports 8.5 ?

For e.g.. When a company has 10,000 items and they wish to see the Sales report of some random 4 items,
then they should pick up just the required 4 items from the Parameter Field.
 
You can set a list of default values for a parameter field but this list is saved with the report (it will not be automatically updated when new items are added, removed or renamed)

If you want to populate this list with so many items, you will need to create a txt file of all the items and use the import facility. I have never tried defaulting so many items so don't know if there's a limit.

If you need the list to be dynamic, you will need to revert to code. Write a VB application which prompts the user for the parameter(s) and pass these to the report.
Steve Phillips, Crystal Consultant
 
If an item isn't in the list, they could just type it in. A list of 10,000 items would be difficult to maintain and probably difficult for the user to navigate. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB
- tek@kenhamady.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top