Viewing 15 posts - 211 through 225 (of 237 total)
Most importantly as I have discovered, the field or calculation must be a String or the tooltip just won't work.
Note that with BIDS on 2008 R2, you don't need...
February 20, 2012 at 7:14 pm
You can teach an old dog new tricks! Mythbusters proved that one 🙂
Coming from an Oracle background, I always use semi-colons, but strangely SSRS (using BIDS 2008) removes them automatically...
February 1, 2012 at 10:40 pm
The Count(*) will count all rows. Is that the intention? The original uses count(productid) which will skip NULLs.
I think its also sensible to drop temp tables when you're done with...
December 14, 2011 at 3:45 pm
Hi, in a matrix there are both column and row groups.
Where you have the "=fields!FISCAL_YEAR.value" , (I can't tell because the matrix is not highlighted) but it's either a...
November 30, 2011 at 6:49 pm
Can you post a shot of the Design view rather than the preview.
To me it looks like the top row might be all merged cells, and aligned right.
If you...
November 29, 2011 at 3:34 pm
For future reference, these are the steps required:
http://technet.microsoft.com/en-us/library/ff406382.aspx#
The article above is written very frankly and is by the scripting guys. I was going to write my steps but...
November 28, 2011 at 11:18 pm
Hi,
I had this problem recently using OpenQuery to a linked Oracle 10g server from SQL Server 2005.
I had this error
Msg 7347, Level 16, State 1
OLE DB provider 'OraOLEDB.Oracle' for linked...
November 28, 2011 at 6:40 pm
Yes sorry, I've checked facts and Strumpet is a lot older than Shakespeare. It's still a great olde insult!
November 6, 2011 at 9:45 pm
I agree, swearing is unecessary in the workplace.
However, Shakespeare has his fair share of foul language, well far more than that given how many words he invented.
He had some quite...
November 6, 2011 at 3:27 pm
Hi,
I can't really think of another way other than this:
WITH Member [Measures].[Sales Last Day of Month] AS
(
[Date].[Calendar].CurrentMember.LastChild
,[Measures].[Sales Amount]
) ,FORMAT_STRING = "Currency"
SELECT
NON EMPTY
{
[Measures].[Sales Last Day of Month]
...
October 11, 2011 at 8:51 pm
Ah thanks this one works well
IIF(CoalesceEmpty(Field,0) = 0, True,False)
September 28, 2011 at 1:29 am
Or, use Mladen Prajdic's SSMS tools pack and set up a "SQL Snippet" with a shortcut e.g.
"se"
To use it, Press se then the enter key and it will write...
September 21, 2011 at 11:46 pm
Format painter ! I wish for that daily. Stylesheets, maybe , but format painter at the very least.
I don't mind the group pane view. At least when you click on...
September 5, 2011 at 11:12 pm
In Australia, HAYS is the largest recruiting firm.
They are in a good position to provide an accurate salary survey which breaks down well across the IT sector.
July 24, 2011 at 9:04 pm
Viewing 15 posts - 211 through 225 (of 237 total)