views:

12

answers:

0

Hi,

I'm writing an SSRS 2005 report based on our cube that contains a prcoedure dimension. I need to setup the report such that it contains only those patient records that has one or more defined procedure codes.

My research thus far has pointed me toward creation of a query parameter in my report's dataset. Would this be the correct appraoch? If so, what expression would I use to define the parameter (I tried =Fields!ProcedureCode.Value in ( and I get red squiggly under the word in).

The gist of the logic is that if the patient has one or more of 30 listed procedure codes, that record should be included in the query.

Ideas, syntax suggestions and assistance are much appreciated.

Thanks, Sid