found here - basically used the syntax from the Filter syntax.

appears to hinge on the keyword 'EMPTY', e.g. below....

IF(myField = EMPTY, "its null", "its not")

tested with success on RB1.0

HTH,

Ok, may be completely missing the exact location for usage here, but taken from MSDN example for Expression Examples (Report Builder 2.0) -->

Test the value of the PhoneNumber field...

Definitely Vista machines not Win7? Saw a similar issue on Win7, where a security dll was being affected by (of all things) the Messenger Login Helper Service (or similar...

brackets (or for ppl like me, 'square brackets') for member names and dimension names --> [steve]

braces (or curly brackets/braces) '{' for sets --> {mySet}

parentheses (or 'round brackets' for...

5) Only when we have datawarehouse, then I can use the SSAS to designed and create my "CUBE" with multidimensional report?

That's correct. Cube is 3 dimensional representation of your data...

Subset would work, but personally I'd use the range. The issue is not so much 'how' to select the actual years you're looking for, but more that you need...

Have you done a test using a scripting method to send the msg (see here)? If this was to work, it would point to either a connection manager issue...

I think the Year() function is one provided by the VBA lib rather than being a native MDX function, so the format of that datestring may be the cause of...

What do your member names look like for the years? Is it like [Dim Month Year Monthly Deck].[Calendar Year].[2010] ? Or is it like [Dim Month Year Monthly...

When you say this doesn't work as you'd thought it would/should, what does it return exactly?

A simple test you could try, to see...

Not wanting to be disparaging but making a user use a dimension to select the measure aggregation method rather than selecting a measure that physically aggegates differently, seems a little...

Is your cube partitioned? If so, approx how many rows per partition? Do you have aggregations on the partitions? Could you post a sample of the query...

You possibly want to look at adding the Except to the where clause (ie after the 'FROM <cube_name>'). In using the Except where you are, you're trying to say...

You'll probably want to slightly reformat that date - you can't created a windows file with any of these characters in the name: / \ : * ? < >...