I don't know if it works or not. But you can try to create a calculated field with the 'iif' expression.

And include sum(new calculated field) into the textbox...

For 2nd table, what is the expression for showing year where error occurred ?

I mean there are 3 years from 2009 to 2011. So which of them are you trying...

Which parameter did you remove ?

The best thing to do here is, Run SQL Server Profiler to get the exact query with parameters being passed to the database engine.

And run...

Yeah. That's the only way to overcome this performance issue.

Thanks

Hi,

I think 93.33% maybe the right answer because the average is being calculated in the scope of the whole year or whatever months (Jan-June) included.

While your expectation of the answer...

You can check this

And also this

i have done that on OLAP database. Don't know if that is possible in relational db.

Maybe some kind of sorting trick will get the data in a sequence as you...

create dataset for 1st parameter (i.e., chapter) containing distinct chapters.

For Example: select...

Under which section is the 'top' property located for a textbox in SSRS ?

I am not getting it.

Is it under Location section which is not editable ?

By concept, Multi select parameters can't be auto submitted.

So you need to select what ever chapters you need, and those values must be passed to the capacity parameter so that...

Multi select Cascading parameters...

Never tried on SSRS... worked easily in Cognos...

Check out this example

You can join your selected values together...

davdam8 (10/8/2012)

=Lookup(Fields!ProjectGUID.Value, Fields!PROJ_UID.Value, Fields!STAGE_NAME.Value, "DataSet2")

I'm not getting the right data.

BIDS gives me a warning that says:

The Value expression for the textrun ‘Textbox21.Paragraphs[0].TextRuns[0]’ uses a lookup function with an expression that...

Maybe try using LookUpSet function for one-many relationship...

Thank you for this Information.:-D