Thanks for the quick response. The error message is 

Done: 1 processed of 1 total; 1 errors (see screenshot below)

Also, this is the output of my Calendar Code

SSRS 2008 does not recognise Chrome as it didnt exist when 2008 was created. Although Firefox did exist the more recent version are completely different from older version.

just do what...

Thanks for the replies, I don't want the structure report to pass values to the unlying report I want it to prompt the user to select the parameters an then...

You have two options really, if all three tables are using the same data set then combine them into 1 table (on different rows) and use an IF statement on...

Hi lowell

I've managed to sort it now, figured it out about 2 mins after posting. Having a blond day today.

In the THEN clause I just -7 after the calculation....

Hi lowell

I've tested the code and it worked beautifully. I need a little help though, I got the logic wrong when I explained the issue originally. There should never be...

Thanks Lowell, I'll have a look first thing.The more I think about it, the more I think it'll work. Thanks, your a legend 🙂

Like this ?

WITH CTE(reference,StartDate,Pattern,PatternLength) AS

(

SELECT 'TestRef-AA',convert(datetime,'01/01/2013 10:45'),' 1111 111 11','15'

SELECT 'TestRef-AA',convert(datetime,'10/11/2013 09:00'),'11 11 111 ','12'

SELECT 'TestRef-AA',convert(datetime,'09/09/2013 13:00'),'11111 11 ','9'

SELECT 'TestRef-AA',convert(datetime,'02/08/2013 12:00'),'1 ...

I didn't mean the code was wrong, just that I didnt post the requirements correctly 😀 lol

I have altered the example data I originally posted. The first one has 3...

Lowell, JamesM said it, that's a brilliant solution, now that I've seen it, I don't know why I didn't think of it 😀 lol

The code you posted I think...

Thanks for the response, what do you mean use POWER? I'm not aware of that function.

How would the code look ?

There an issue around the If. I get the error, expecting ID?

Hi Sean

That wont work. The course name has AS or A2 at the front so joining on game wouldn't help, same goes for level.

I gave the output as an...

Essentially I need the enrollment data from the previous years AS on the same line as the A2. see below for an example

CourseNameLevelse_referenceAcademicYr1112Enrollments

ChemistryA211A2CHEM121-1Y-1Y-D78112

ChemistryAS10ASCHEM121-1Y-1Y-D1400

Basically I have two common table expressions, one that works out the number of people that have moved from a AS course to a A2 course and one that works...