Take a look at the attached RDL file... It's a very simple layout so it should be a simple matter to "reverse engineer" it to see how it was constructed.

HTH,

Jason

I think a slightly more simplistic sample offers a better illustration of what happens with LAG & LEAD in relation to the order by clause...

-- Test Data --

IF OBJECT_ID('tempdb..#temp') IS...

You...

If you're getting into windowed functions in SQL 2012, I'd encourage to to also included "Window Frames" in your study.

Windowed functions are an extremely powerful feature, and 2012's inclusion of...

The following should get you what you're looking for...

SELECT

al1.RCDID,

al1.EMPLOYEEID,

al1.LOGDATE,

LEFT(al1.LOGTIME, 5) AS [IN],

LEFT(al3.LOGTIME, 5) AS [OUT]

FROM

dbo.AccessLog al1

CROSS APPLY (

SELECT TOP 1

al2.LOGTIME

FROM

dbo.AccessLog al2

WHERE

al1.RCDID = al2.RCDID

AND al1.EmployeeID = al2.EmployeeID

AND al1.LOGDATE =...

This should give you the results you're looking for...

/* ==================================================

Test Data

================================================= */

IF OBJECT_ID('tempdb..#FY1') IS NOT NULL

DROP TABLE #FY1;

CREATE TABLE #FY1 (

CustomerNo CHAR(4),

OrderAvg INT,

OrderCount INT

);

INSERT #FY1 (CustomerNo,OrderAvg,OrderCount) VALUES

('0155', 300,...

Jeff Moden (5/22/2015)

---

I was responding to the following...

The only reason to use a tablix filter is if you you have multiple tablix objects that are displaying subsets of a single,...

Jeff Moden (5/22/2015)

---

Jason A. Long (5/22/2015)

---

Lowell (5/19/2015)

---

look at the report design as well; as mentioned, make sure the underlying query/proceudre is effience and tuned of course, but check this...

FranciscoLUIPires (5/20/2015)

---

Hello,

In a nutshell, what I need to do is run reports that are on a 2008 R2 on a 2012 SP2.

Why? Because I need them to run...

Lowell (5/19/2015)

---

look at the report design as well; as mentioned, make sure the underlying query/proceudre is effience and tuned of course, but check this out:

i inherited a suite of...

Oh... Just a side note... If/when you make the jump to SQL Server 2012 or later, revisit this code. You'll be able to use the LAD & LEAD functions to...

jkalmar 43328 (5/22/2015)

---

Jason - that did it perfectly. Many thanks, if you're ever in Rochester, NY I owe you a beer (or other beverage of your choice as long as...

SQLRNNR (5/22/2015)

---

Jason A. Long (5/22/2015)

---

Grant Fritchey (5/22/2015)

---

Question for the crew since this is a fairly international audience, plagiarism

I understand that some cultures look at it very differently than most Western...

Using just the base test data (w/o the updates)

; WITH CTE AS (

SELECT

t.KitID,

t.SubjID,

t.VISIT,

t.VISITNUM,

t.LBDTC,

ROW_NUMBER() OVER (ORDER BY t.SubjID,t.LBDTC,t.KitID) AS rn1,

ROW_NUMBER() OVER (PARTITION BY t.VISITNUM ORDER BY t.SubjID,t.LBDTC,t.KitID) AS rn2

FROM

#testing...

Grant Fritchey (5/22/2015)

---

Question for the crew since this is a fairly international audience, plagiarism

I understand that some cultures look at it very differently than most Western European-based ones do. There's...