Which was what? use an aggregate function in a control at the bottom of the report?

Must be the Alzheimers... I know I have read a few.

Yeah, answering based on flawed sample data will do that to you...

It looks like this works:

SELECT MedRecNum, VisitID, VisitDate, MAX(Answer) AS MaxAns

FROM

(SELECT 123 AS MedRecNum,7777 As VisitID,'03-14-14' AS VisitDate,1 As Answer

UNION ALL

SELECT 123,7777,'03-14-14',0

UNION ALL

SELECT 123,8888,'05-21-14',0

UNION ALL

SELECT 123,8888,'05-21-14',0

UNION ALL

SELECT 456,3333,'03-20-14',1

UNION...

Oh, I'm sure. Gail's was just the first I remembered. And if the boss can't take their word for it then all bets are off...

Not sure what to say. If you dig around here even a little, you'll find Gail Shaw's explanation of what NOLOCK really does. You might need to make...

I think he's talking about something more like this, but this is PowerView in Excel 2013...

http://office.microsoft.com/en-us/excel-help/maps-in-power-view-HA103005792.aspx

Luis,

Outer apply... I should have figured. Still trying to get my head around that one... I mean, I know what it does, but remembering to use it... I...

That's what I was thinking at first, but the two values are not in the same record. That's why there's all the weird coding...

This seems to work... If you post consumable data (create table scripts, and inserts), it's a lot easier for people to help you - since you've set up the...

DECLARE @InputString VARCHAR(15) = '1.234;0;0;0;0;0;0;0';

PRINT LEFT(@InputString,(CHARINDEX(';',@InputString,1)-1));

Not much to go on here, but there are two parts to filtering a dataset if you are using report-level parameters that you define yourself (as opposed to inheriting them...

What type is the parameter? Should be an integer. then you can do something like

=Parameters!EndWeekNo.Value + 1

I would put it all in the stored procedure, and if you can avoid using the view, do it. Think about what would happen if your view got dropped...

The only way I can think of doing it is by adding a parameter that prompts for Export format, and then hiding the tablixes you don't want exported. maybe...