May 8, 2017 at 1:36 pm
I am using "Microsoft SQL Server Report Builder 3.0" on "SQL Server Reporting Services 2012". As I am passing some parameters from main report to drillthrough report I have to use Graphical Query Designer to generate SQL query.
In WHERE clause of SQL there are conditions like: .... WHERE condition1 AND condition2 AND (condition3 OR condition4 OR condition5 OR condition6)
I know how to add AND/OR conditions by using appropriate "Operator" from Graphical Query Designer but I can't find a way to add parenthesis after AND.
How can I do this using Report Builder 3.0? Is "Report Builder 3.0" capable of doing this or my only options is to use "Business Intelligence Development Studio"?
Note: Was posted few days before on SO as well but didn't get any response 🙂
May 8, 2017 at 3:43 pm
SqlServer300 - Monday, May 8, 2017 1:36 PMI am using "Microsoft SQL Server Report Builder 3.0" on "SQL Server Reporting Services 2012". As I am passing some parameters from main report to drillthrough report I have to use Graphical Query Designer to generate SQL query.In WHERE clause of SQL there are conditions like:
.... WHERE condition1 AND condition2 AND (condition3 OR condition4 OR condition5 OR condition6)
I know how to add AND/OR conditions by using appropriate "Operator" from Graphical Query Designer but I can't find a way to add parenthesis after AND.
How can I do this using Report Builder 3.0? Is "Report Builder 3.0" capable of doing this or my only options is to use "Business Intelligence Development Studio"?Note: Was posted few days before on SO as well but didn't get any response 🙂
When you are in the query designer, click on Edit As Text in the top left. You can type queries in the text based query designer window that opens.
Sue
May 8, 2017 at 4:16 pm
Thank you Sue. It solved my problem. Somehow I didn't notice it and assumed that while passing parameters I can't use "Edit as Text".
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply