Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jcornelius
Starting Member
1 Post |
 Posted - 2010-12-13 : 17:55:45
|
| My organization is using Report Builder 3.0 (with SQL Server 2008R2) for ad-hoc reporting for our users. One of our users has reported a problem she is experiencing with Query Designer, wherein she is unable to set OR conditions on the queries she is trying to create. The 'Applied Filters' section of Query Designer allows a user to enter filter criteria for a query. However, when adding multiple filters, there is no way (that I have been able to find) for a user to dictate whether conditions should be 'AND' or 'OR' conditions. This is causing a real problem.I could train the user how to edit the SQL manually after they select their data and click OK to exit the Query Designer. However, this is not something I want to do with our entire user community at large. Besides, Report Builder is intended to be used by Report Users, not IT folks (I could very easily deal with this in Report Designer or BIDS).Is there any way for users to specify the conditions of elements in the WHERE clause (AND vs OR) without having to manually manipulate the SQL? Any help is much appreciated. |
|
|
|
|
|
Report Builder 3.0 - Using an OR condition in Quer