Oh well, I liked the thinking anyway 🙂

Parameters don't have a hidden property as such do they? You've got the visibility option which is a radio button selection but there's nowhere to enter an expression.

Am I...

What have parameters got to do with it. Just take whatever expression you're using for the hidden property and use it's inverse as the filter property.

I generally use the filters rather than hidden because that explicitely excludes the row. Would that work for you?

Never actually quit but have thought about it once or twice. There's nothing worse than trying to "look busy" for 8 hours a day. Looking at Lolcats can...

I work in the U.S. My employer supplies the equipment, but they own it outright and are just lending it to the employee during their contract. Of course, contracters are...

Perry Whittle (10/26/2012)

--------------------------------------------------------------------------------

Brandie Tarvin (10/26/2012)

--------------------------------------------------------------------------------

Supply their own equipment? I mean, phones I get. But laptops?

This is quite common for contract staff

Not where I work it isn't. We have desk, cubicles,...

Sounds like a reasonable technique to me. Assumes 3D mental imaging skills that some people might not have, and which probably aren't applicable to most DBA/dev tasks, but that itself...

Wierdest interview I ever has was only about my second job after finishing my degree. The boss turned up an hour late and the only thing he seemed interested...

You will only get a column in the matrix if there's a row in your dataset that contains a value for that column. So if your dataset contains e.g.:-

Month...

I just had another thought. It's a fudge but it'll work. I've simply ammended the query for the main report dataset to return this field for the chosen...

I don't think that's what I'm after but I might be miss-understanding you.

To be clear, when the user picks e.g. row 8 in the drop down box, I want to...

Oooh, I like that. Yep, that'll do me.

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