Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Or condition in dataset filter

Status
Not open for further replies.
BB45

BB45

Technical User
Feb 3, 2005
42
0
0
US
SSRS 2008
SQL 2005

I do most of my filtering on the SQL side but I need to add a filter on the report side for this one field and cannot figure out the syntax needed.

I have tried variations of the following but the report always retuns no rows when using the parameter default. Can you help me with what I need to put into the dataset filter?

Here is what I am trying:
=Parameters!RecordID.Value or (Parameters!RecordID.Value = -1)
 
Status
Not open for further replies.

Similar threads

Theresajn
  • Locked
  • Question
Collapse all Datasets in Report Data Pane
Replies
0
Views
145
Theresajn
Theresajn
Tom_2023
  • Locked
  • Question
SSRS wrapping text in Excel
Replies
0
Views
163
Tom_2023
Tom_2023
nomi_ssrs
  • Locked
  • Question
xml column from sql server - used in ssrs
Replies
0
Views
152
nomi_ssrs
nomi_ssrs
Mr Wonderful
  • Locked
  • Question
SSRS Dataset query all Oracle Tables/Columns;Return the maximum length of data values in each column
Replies
0
Views
84
Mr Wonderful
Mr Wonderful
dbsql
  • Locked
  • Question
SSRS2019 not able to connect Oracle19
Replies
0
Views
153
dbsql
dbsql

Part and Inventory Search

Sponsor

Back
Top