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!

Parameter as part of a Formula/Query

Status
Not open for further replies.

mmemon

Programmer
Nov 21, 2002
46
US
I created a parameter field that asks the user a question. Now what I would like to do is if the user picks Yes from the list, I want to query Table A and if the user picks No from the list, I want to query Table B.
Is this possible?
Thanks
Michele
 
What version of Crystal, and what database/version are you using?

It's very simple if you're using a Stored Procedure, in the SP you pass it and an IF would decide which select to use.

Another solution would be to place a subreport which is suppressed based on the value of the parm, if it's yes, suppress the main report data, if it's no, suppres the subreport data.

-k kai@informeddatadecisions.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top