Man, talk about wood for the trees. I was so focussed on fixing the problem by using converts and casts in the upper part of the formula I didn't see...

In those cases I pre-set the text box in the SSRS design area to be big enough to fit in all the text. That way it turns up in Excel...

Hi - here's a copy of a "how to" blog post I wrote a month or so ago. Using multiple value parameters is easy once you've done it once, but...

If the user is clicking on a bar to find the detail inforamtion, the better terminology for what you want is a drill through report (sub reports are permanently imbedded...

Yes, but if you're asking a user to click on bars I assume it is drill through reports you want them to go to.

Simply right click on one of the...

Absolutely, but I didn't solve it, Lutz did. He's posted the solution on the thread. I was just replying to say thank-you and that the solution worked.

That's it.

During all the complicated things I've tried, I had this deep-seated feeling there was an easy, elegant answer out there somewhere - which of course just made me more...

That's it.

During all the complicated things I've tried, I had this deep-seated feeling there was an easy, elegant answer out there somewhere - which of course just made me more...

Oh, this is a complex select query? I posted it as I thought it would be a fairly easy solve for someone cleverer than me; I didn't want to take...

They're in a another building and I don't know any of them personally.

And it's not really about the database structure as such, the data is there in a fine...

Hi

By DDL do you mean the following:

[Call Priority] is (int, null)

[Call Logged Month Relative] is (int, null)

[Call Status] is (varchar(3), null)

Please excuse my ignorance, I'm not a DBA, simply a...

Hi

I've attached a 97-2003 format of it to see if that helps. I'm not zipping it this end, but it is is 82 pages long, would the SQLServerCentral Server be...

Hi guys

Just thought you would like to see the finished fishbone respresentation of the data your SQL cte query returned.

The graphic was created using MS Publisher for the roundy...

That's it. Exactly.

Thank-you so much. Only modifications I made were to add in some filters that are needed on our prod system and the data and results based on last...

Hi

I read the link and had a lot of fun with the code bringing back lots of interesting results but none unfortunately exactly as I needed it.

Problems are:

1. I need...