This will get you the date for last sunday:-

SELECT DATEADD(wk, DATEDIFF(wk, 6, GETDATE()), 6)

This will get you last sunday - 52 weeks

SELECT DATEADD(wk, -52, DATEADD(wk, DATEDIFF(wk, 6, GETDATE()), 6))

so this...

Yeah, I did think of that. But what would that mean if the user selects "Show None" and "Chart A"? I could arbitrarily say that Show None always...

I'll come at theis from a more 'plain language' point of view.

SSAS is great for producing highly flexible information for reasonably technical users. Financial Analysts for example. These...

Now that's some good lateral thinking and will probably resolve my issue 😀

the report will go ahead...

It's still supported and probably always will be since it's made up of the most basic elements of sql (tables and where clauses). To stop supporting it would mean...

Right, Here you go. Here's a dummy report that exhibits the problem. (Why didn't I just do this in the first place:doze:)

I've had to change the file extension...

I'm using 2008 R2 and using Visual Studio 2008 as in IDE.

One thing that occurs to me, is it possible to upload rdl's as attachments? I don't see it...

To get data from T1 that's not in T2 try:-

Select *

From T1

Left Join T2

ON T1.C1 = T2.C1

AND T1.C2 = T2.C2

Where T2.C1 IS NULL

to go...

Hi Daviscollective and thanks for a useful reply

Just to respond to a couple of your suggestions up front:-

I'm wondering why this is a problem because you've already stumbled on the...

I think I'd agree with the above. Leaving the keys in place might make the migration a bit more of a pain because it'll thrw up any data integrity...

Yep, that's why I said you couldn't do it.

Look, we're arguing semantics and really not helping the OP at all.

Well, that's a query within a query... so I'd call it a sub-query.

The point I was making making was that you couldn't do something like:-

Select * From MyTable...

Whenever I've tried a comparison (which is admittedly only on half a dozen occasions and not in any particularly scientific way) I get an identical execution plan. I've never been...

In the other tablix where you only want to see specfic subtype, can you not change the grouping on that tablix to group by type and subtype1, then do a...

Sorry, I obviously wasn't very clear. The sql query is going to have to return me all the data, regardless of SubType1, because it is all used elsewhere in...