Is there a way to store a user’s condition panel SQL (Where this and that) in a variable that can be displayed in a report at run/refresh time.
John S.
Listserv Archives (BOB member since 2002-06-25)
John,
Without scripting, I think the closest you can get is the ‘DataProviderSQL’ function in a variable. You could also set up all conditions as prompts and capture the ‘UserResponse’ for each condition in a variable.
Jason Beard, AGD Computer Services
Listserv Archives (BOB member since 2002-06-25)
John-
If you are looking to display what the user responds to in the condition panel. You may use the UserResponse Function when creating a report variable.
This will display what the user responded to from a prompt within the query.
Hope this helps!
Pam
==
Tanti auguri-
Pam & Perry
_________________________________________________________ DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com
Listserv Archives (BOB member since 2002-06-25)