I have this working now, but need to figure out how to find records that fail - say an email address we have on file has been mis-typed or is...

Jeffrey,

In Visual Studio on my parent report, I go to my textbox properties > Action > Go To Report  ---> specify my child report and the parameters that are needed...

Just another note - I can see and use the "Back to Parent" button if I'm in Visual Studio > Preview...just not when viewing on a web broswer.  Tried Chrome;...

The screen shot was from my drill to report...

I can use the "back button" on the URL, but I'm not a fan of using that, so was hoping for an...

Jeffrey - I don't have that last "back" button that you do

My browser header area looks like the following

We are running SQL Server 2014

with Reporting Services version:

thank you

Thanks - this is what I needed....great work!!

Sorry about the primary key issues on the CustomerInfo table - for my scaled down data example, the primary key doesn't need to be on this.

I will try to explain...

The insert statements above should be:

INSERT INTO dbo.CustomerInfo (ID, CustomerStatus, StatusDate) VALUES (1, 'A', '20100801')

INSERT INTO dbo.CustomerInfo (ID, CustomerStatus, StatusDate) VALUES (1, 'X', '20100809')

INSERT INTO dbo.CustomerInfo (ID, CustomerStatus, StatusDate) VALUES...

Sean, sorry here is some table scripts - hope this helps, if you need more info I will gladly supply.

CREATE TABLE dbo.ReportDate

(

dt...

Thank you all very much - its working.

Do you have any website that can help explain the ROW_NUMBER() function...this one is new to me, and I'm not totally understanding it.

THANKS!!

OK this works and I thought all was good until the following was added to the equation:

ID COLOR DATE

1 red 5/1/09

1 blue 5/1/09

1 green 5/23/09

2 red 5/10/09

2...