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!

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

Prompt Issue

Status
Not open for further replies.
nikol

nikol

Programmer
Apr 12, 2005
126
US
Hi,
Is it possible to use two Dynamic Prompts with (EITHER-OR) in a report.
EITHER
( Parameter_name1-- Country/Region/city )
COUNT Clients for particular City
OR
(Parameter_name2-- Country/Region)
COUNT Clients for particular Region
 
Sort by date Sort by votes
I don't know of a way. Why not use two parameters?

[yinyang] Madawc Williams (East Anglia, UK) [yinyang]
 
Upvote 0 Downvote
Better, three parameters. The first to say which type of selection you are doing. Then one for cities. Then one for regions. Then select using a formula that picks up the value selected for by the first parameter.

[yinyang] Madawc Williams (East Anglia, UK) [yinyang]
 
Upvote 0 Downvote
It might be possible.

Provide an example of what you want to achieve, with a little dataset. Your version of Crystal and anything you've tried so far with results would be helpful too.

Naith
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

supportsvc
  • Locked
  • Question
Date prompt use in Formula with DatePart? 2
2 3
Replies
42
Views
977
pmax9999
pmax9999
smmt2207
  • Locked
  • Question
Crystal sub report shared variable issue
Replies
2
Views
165
lbass
lbass
J33
  • Locked
  • Question
Parameter Field range value issue
Replies
4
Views
260
J33
J33
Cpreston
  • Locked
  • Question
Right Issue 2
Replies
6
Views
180
IanWaterman
IanWaterman
MK_USF
  • Locked
  • Question
Prompt Question
Replies
6
Views
176
MK_USF
MK_USF

Part and Inventory Search

Sponsor

Back
Top