**SLSO is a Self-Hosted Organization**
Similar to how (None) is an option, is it possible to have (All). Here is what I am working with:
I am about the change that where clause after I post this because we now want to include households and individuals as options, but my question here is about a way to select all available options in the parameter dropdown without having to click on every one.
Any thought?
Ashley Elliott
Database Administrator
St. Louis Symphony Orchestra
314-286-4198
ashleye@slso.org
Ashley,
As John says, it's about how you write your stored procedure. For example, I have written reports for our Development team which have Funds as a parameter. This parameter is allowed to pass a NULL value and the SQL in the stored procedure handles this. Happy to show you how this works - feel free to email me at martin.keen@nida.edu.au if you would like an example.
Martin
Thank you! Email sent.
Ashley