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

I would run the inserts one at a time and see if they throw errors. Either that or put in some dummy print statements to see which insert/select statement...

Here is the report... Hopefully my table/field names match yours. If not, I can share the table scripts too.

Just realized... I'm using 2012, so I may have to redo...

I think I sorted it out. The problem is that it requires a Calendar table/ table valued function in order to work (because you have to have all the...