Didn't see a final solution here, was this resolved? I'm having the same issue. All permissions appear to be set correctly, but I can't see the cube itself when trying...

Using any one of the functions provided in this discussion that returns a table containing the multi-value selections, its a simple query to check the count..

SET @PARMCNT = (SELECT SUM(1)...

We found a pretty easy to use and reliable way of doing this using a split function we built that returns the parameter array as a table. This way, we...

No impact at all on performance that we've seen and we have some pretty large and complex reports that utilize this function ALOT.

We use a piece of custom code that is inlcuded in our report templates so the engineers no longer have to continue to write these IIF statements. Anytime they have...

Couple of things, first look at your parameters, they seem a bit confusing:

I think this is what you are looking to filter on:

>= 0 - All in ...

Ok, here's how I resolved it. First I change the format of the initial query to return the data as 1 record per day per id and code. ID/Code is...

I've created a solution for this. I'll post it shortly.

Look at the dataset filter option. You can filter the returned results there using parameter values, or you can use the filter options in the table Group definintion. It sounds...

In your query, you should be able to do something like the following:

@ParmValue = passed in parm value

Select

ID

,sum(value)...

Thanks Kerrie. I've tried taking it apart, changing the evaluation, changing the true/false order etc. Each piece works fine independantly, but when put together, the IIF returns an error. I...

It is a positive number if the evaluation condition is met. If the evaluation condition is not met, it should just display the DivisionName.Value and not attempt to do the...

I'm having a strange problem with IIF and InStr. Below is the actual statement being used:

=IIF(InStr(Fields!DivisionName.Value,

"Division")=0,Fields!DivisionName.Value,Left(Fields!DivisionName.Value,InStr(Fields!DivisionName.Value,"Division")-1))

I'm checking the DivisionName.Value in order to...

Another way to handle this is with a simple case statement in the WHERE clause. We use this alot as most of our sp's run with multiple, non-required paramenters. We...

Here's how we code our stored procs now that used to be created as dynamic SQL based on parameters supplied by the users. We haven't seen a measurable impact on...