Well, what was it? C'mon then, share!

Matt.

Mike,

thanks for the clarification, I'll let you know how I go.

Regards,

Matt.

Hmmm... Thanks Michael, though I am not certain that this will give me the behaviour I require. Though I'm pretty keen to try out that technique for things like turning on/off...

Hi Terry,

what you are looking for is the 'navigation' tab in advanced properties for the object you want to click on to launch the other report. (I am guessing Cust_ID)....

Hi. I haven't used AS2k5 yet, as I am stuck on AS2000. But from what I have read, what you are proposing sounds like a need for 'Role Playing Dimensions',...

Hi,

I don't have a lot to say about this, except that I think this idea is brilliant in its simplicity. I've been using Reporting Services for about 2 years now,...

Stephen, sounds to me that what you have built is not a datawarehouse, rather a collection of source systems (clinical trials) on a level playing field in terms of storage...

StevefromOzbutwannabeUS , Yukon helps with a LOT of problems we have at this client, particularly multi-role dims and especially properly 'heirarchy aware'...

Yeah, it's annoying, isn't it? To get around it, I am afraid you'll need another dimension, which is pretty much the same as your 'TimeByMinute' dimension, and use that in...

Things get even worse if you have a report that doesn't export to PDF or Excel because of an RS bug relating to matrix tables that have subtotals. Print options...

Or, if you need your results on the same row, then...

select sum(case when OrderDate between @DateStart and @DateEnd then Orders else null end) as ThisYearOrders,

sum(case when OrderDate between DATEADD(yyyy,...

Hi Jamie, thanks for the article. I am yet to try out 2005, but am particularly interested in SSIS. I don't have a broad range of ETL experience, but the...