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

One way is to just add a Page Header to your report and put the textbox in it.

So using T-SQL isn't an option, because you're using SSRS?

If you can use T-SQL, something like this should work:

SELECT HeatNo, MAX(Frame) AS MaxFrame, MAX(Window) AS MaxWindow

FROM (

SELECT 1 AS...

dates are numbers, so change the formatting in the textbox properties.