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!

Checking 2 parameters

Status
Not open for further replies.
CognosNewbie99

CognosNewbie99

Technical User
Jul 13, 2011
13
US
I am writing a Cognos report which involves 2 different date fields and a status field. There is a parameter of a date range, begin date and start date. I need the report to only pull the info that has (date1 in date range) OR (date2 in date range and status = completed or closed). I put this in the query for the parameter/filter, but it does not pull the correct info. It skips the status check and only pulls in certain dates. How can I make this work?
 
Status
Not open for further replies.

Similar threads

deborahyr63
  • Locked
  • Question
how to code for service year milestones in 2020
Replies
0
Views
151
deborahyr63
deborahyr63
damzi
  • Locked
  • Question
using 2 measures as one measure in cognos transformer
Replies
0
Views
62
damzi
damzi
NicolaTesla1
  • Locked
  • Question
Framework Manager - JOIN between 4 query subjects (in 2 diff. name spaces)
Replies
0
Views
43
NicolaTesla1
NicolaTesla1
Starfish2201
  • Locked
  • Question
Can we add OR condition in drill through parameters?
Replies
0
Views
59
Starfish2201
Starfish2201
khdavis
  • Locked
  • Question
Crosstab Report - Need to Group Columns by 2 Different Date Fields
Replies
1
Views
55
blom0344
blom0344

Part and Inventory Search

Sponsor

Back
Top