In a SSRS 2008 report, I will have between 1 to 30 different small ssrs reports that will be executed in a specific order. All the reports will pass the...

What's the rule about the 52 weeks? Do they start at the first of the year, or is there some other rule for that?

I figured that since he was new, I would be nice and show him how to set up the problem so that people could help...

to the OP - if ...

Turns out I did that same thing when I first tried it... You have to wrap the units in double quotes, because this is .NET, not SQL (so the rules...

If I use the same column names in my underlying database tables, is it possible to use them in an existing report to refresh data for new quarter without wiping...

I would like to call other reports based upon selections that users make and/or possibly calling the other reports based on values stored in a table in sql server 2008...

Does this work for you? (Seems not).

Set up some tables/data for folks to use...

USE TempDB;

GO

CREATE TABLE #WorkHours (

ID int

, PersonnelNo int

, WeekEnding date

, WorkedHours decimal(4,2)

, ContractHours decimal(4,2)

);

Insert some...

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