If a converted lead is just a property_id where there exists a move-in for that leadID, then you should be able to use EXISTS(), right?

Something like this:

SELECT lead_id

, property_id

, MIN(date_value)...

Buy a copy of Developer. It's basically the same as Enterprise, but the connections etc are limited. And it's super cheap for what you get.

If you create another calculated value in your dataset, you could do this:

=IIF(Fields!EnrollWeek.Value<=5,0

,IIF(Fields!EnrollWeek.Value<=10,6

,IIF(Fields!EnrollWeek.Value<=15,"11-15 days",16))

Because this returns an integer, you can sort on it (and it will work).

The only difference is...

WHERE fields.Name NOT IN ('sale payment', 'initial transaction')

You could do it by creating a calculated field in your dataset. Something like this:

=IIF(Fields!EnrollWeek.Value<=5,"0-5 days",IIF(Fields!EnrollWeek.Value<=10,"6-10 days",IIF(Fields!EnrollWeek.Value<=15,"11-15 days","16+ days")))

I had a dataset with numbers (EnrollWeek), so that that's what...

If your report is based on a stored procedure, it's not hard at all. Say your report is based on a parameterized stored procedure, something like

CREATE PROC GetReportData @Param1...

How would you determine which team is the "main" one for a person? Not sure how you would remove duplicates if you have a relationship like this:

Person---(1,M)--Membership--(M,1)---Team

unless you had...

Read this article[/url], it should explain what Calendar tables are and what you can do with them.

Yeah, what Luis said! That's what I meant! (suuuure!)

use a CASE statement to group the age ranges into two groups, then summarize on that. What have you tried so far?

I think I had to read this about 5 times before i figured out what you were asking... Took a bit to realize that the second invoice is a...

One option:

=Format(Globals!ExecutionTime,"dd") & "th " & Format(Globals!ExecutionTime,"MMMM yyyy") & ", " & Format(Globals!ExecutionTime,"hh:mm")

affectionate squid?

Again, the original query produces a list of "programs" that a "player" and or "member" from a particular family are eligible to register for. The result set needs to exclude...

I would probably do it by using a Calendar table. There are a bunch of articles around here this one: http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

You might have to add the column for Nth...