Answer:

IIF(Fields!PRODUCT_LINE.Value = 1 OR Fields!PRODUCT_LINE.Value = 2 OR Fields!PRODUCT_LINE.Value = 3, etc, etc)

Mess with it long enough the answer will just come!

Thanks for the quick response guys.

I guess after mashing my face on the keyboard my vision was too blurry to notice I didnt give an alias 😀

It's working meow!

Thanks again!

CP

Thanks for the quick response!

I'll let you guys know how it goes!

Thank you all for your input!

We are going to move forward with TFS 2008 with the Team Explorer 2008 for accessing TFS. We plan to integrate this into BIDS...

Great, I'll check this out.

By the way, we are using SSRS 2008 (BIDS 2008)

Thanks!

I was able to find a solution to my problem and everything is working now. Apparently my data-source contained certain data types that caused the issue. Any data containing...

I have a DataReader Source using ODBC driver(ADO.NET) for a connection that links to an outbound flat file destination. I use to have a data conversion step, but took it...

Thank you for the response!

I do have a data flow that I watch, it shows the correct column names at the top but the data being populated is all...

bump