COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: NDP on 23 Oct 2008 11:52:04 AM

Title: multiple selection
Post by: NDP on 23 Oct 2008 11:52:04 AM
i need really a bad guidence for this case----

here is my data field

A/C_No       date          track_no          Name
123            jan-1          01                  tom
456            jan-2          10                  david
648            jan-3          11                  tek
569            jan-4          25                  drew
789            jan-5          25                  tony
425            jan-6          25                  mike

requirements--

I need to get the A/C_no and NAME which must has track_no=25

If I select date range from Jan-1 to Jan-6 and within those date all track_no are 25 the NULL (no value)

If I select date range from Jan-1 to Jan-6 and within those date, last date DOES NOT have any track_no25 then NULL(null value)


If I select date range from Jan-1 to Jan-6 and within those date range last date = track_no 25 then I need information about 1st occurance of track_no25,in this case that must be
            NAME-Drew
            Date-Jan-4
            A/C_no-569


plz some advice

thank you

 
Title: Re: multiple selection
Post by: NDP on 23 Oct 2008 01:52:16 PM
???
Title: Re: multiple selection
Post by: pooja on 27 Oct 2008 09:53:31 AM
no idea
Title: Re: multiple selection
Post by: DanSev on 27 Oct 2008 03:42:59 PM
Why aren't you filtering directly on track_no. Track_NO = 25 and forget the data range? -- Hold that, I got it - the date filter is exclusive -- Jan 2 - Jan 4 when you use a between clause. Is that the issue?