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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.