Thanks, Sean... that's what I was thinking!

Okay, you can filter your dataset so that you can only see the current year.

SELECT <column list>

FROM <table>

WHERE YEAR([SomeDate])=YEAR(GetDate())

(Not sure that's going to perform well, but one problem at a...

I would think you could use this article[/url] and use a job to write daily to a table... You could just need to grab the date the records were...

I must be getting better at this! <g>

I don't think you need most of this in your query:

SELECT d.name, a.dealer_code, b.last_name, b.city, b.state, b.phone

, COUNT(CASE WHEN MONTH(c.Funded_date) = 1 THEN...

If you're using SQL 2012, you can use LAG:

SELECT Category

, Code AS CurrCode

, LAG(Code) OVER (ORDER BY Category, StartDate) PrevCode

, CASE WHEN LAG(Code) OVER (ORDER BY Category, StartDate)<>Code THEN 'Changed'...

Sounds like you're using a tablix instead of a matrix, which it sounds like what you should be using. If you did this with a matrix, then the month...

Yes. Instead of just this:

;WITH CTE AS

(SELECT

row = ROW_NUMBER() OVER(PARTITION BY custID ORDER BY (Geography::Point(geo.latitude, geo.longitude, 4326).STDistance(geography::Point(prp.latitude,prp.longitude, 4326))/1609.34) asc),

ld.custID

prp.property_name,

distance_miles = Geography::Point(COALESCE(geo.latitude,0), COALESCE(geo.longitude,0), 4326).STDistance(Geography::Point(COALESCE(prp.latitude,0),COALESCE(prp.longitude,0), 4326))/1609.34

FROM

...

You add a parameter...

I think you have to do the TOP in the stored procedure, not in SSRS. If you can do it in SSRS, I have no idea how.

SELECT TOP (@NumRecords)...

Maybe like this?

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/5efe07a6-1ff3-4bfa-baf3-717f7f431c6f/open-url-in-a-new-window?forum=sqlreportingservices

If you had a column in a table for the Category that indicated if it were a debit or credit. then it would be really easy:

create a calculated column, I'll...

Can you explain what the trigger was supposed to accomplish? I didn't write your code, so I'm not sure what it's intended to do. If we had that,...

Exercise your GoogleFu skills...

Schedule a job in T-SQL

Even better answer...[/url]

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...