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!

Only want Odd IDs rows to display

Status
Not open for further replies.
capronton

capronton

MIS
Jun 28, 2013
159
US
How can I only show Odd IDs rows in my report

if ID mod ID = even then do not display record.

Can someone help with this?
 
Sort by date Sort by votes
Conditional suppression on the detail section. Section Expert, chose the formula workshop for Suppress. Put in if RecordNumber mod 2 = 1 then false else true for the formula. So unless I got the if backwards, it should work.
 
Upvote 0 Downvote
Try the following in the Record Selection formula:

Code: 
{Table.RowID} Mod 2 = 1


Cheers
Pete

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Only Select certain rows 1
Replies
7
Views
296
Cpreston
Cpreston
cursedkorok
  • Locked
  • Question
Transpose Columns into Rows?
Replies
1
Views
230
hilfy
hilfy
D
  • Locked
  • Question
Running total from a subreport only showing last value
Replies
4
Views
409
doodledump
D
Cpreston
  • Locked
  • Question
Select Top 2 rows where field = 2,3,4 and 5
Replies
1
Views
183
Cpreston
Cpreston
mmck1964
  • Locked
  • Question
Using "OR" to select data
Replies
4
Views
318
mmck1964
mmck1964

Part and Inventory Search

Sponsor

Back
Top