stevennorris Posted January 10, 2011 Share Posted January 10, 2011 I need to have an option to choose between two options:Option1: Date is equal to ?Option2: Record Number is equal to ?I know I can use the parameters to generalize my SQL statements, but since my two options are not connected, how can I have two sql statements and once my option is selected i set the correct SQL for the report. If option 1 is used then I would like to use SQL1, or if option 2 is used I would like to use SQL2. Any ideas would be greatly appreciated.Regards Link to comment Share on other sites More sharing options...
phantastes Posted January 11, 2011 Share Posted January 11, 2011 You need to be more specific. Give us an example. Magnus Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now