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 IamaSherpa 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
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

dawnanne
  • Question
Loop through rows in an SSRS table
Replies
0
Views
91
dawnanne
dawnanne
Theresajn
  • Locked
  • Question
Collapse all Datasets in Report Data Pane
Replies
0
Views
654
Theresajn
Theresajn
Tom_2023
  • Locked
  • Question
SSRS wrapping text in Excel
Replies
0
Views
710
Tom_2023
Tom_2023
nomi_ssrs
  • Locked
  • Question
xml column from sql server - used in ssrs
Replies
0
Views
677
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
288
Mr Wonderful
Mr Wonderful

Part and Inventory Search

Sponsor

Back
Top