Report Model with SQL Uniqueidentifier data type

Report Model with SQL Uniqueidentifier data type - I can't filter on them.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve MunLeeuw - 14 Jul 2008 21:58 GMT

I am trying to filter a resultset from a report model that contains columns
that have a sql uniqueidentifier data type. When I attempt to use one of
these columns in a filte expression I get the following error. I haven't
been able to modify the report or model to accept this data type in a
filter. Anyone using Report Model with UniqueIdentifier data type?

Thanks,
Steve MunLeeuw

Reply to this Message

Steve MunLeeuw - 14 Jul 2008 22:09 GMT

One way to filter by uniqueidentifier is to use views in the report model
data source view with cast statements. I don't want to do this, because
then I need to recreate all of my relationships in the datasource view.

Thanks,
Steve MunLeeuw

Reply to this Message

Steve MunLeeuw - 15 Jul 2008 20:29 GMT

I kept my table with all of it's relationships, then just added a query view
where I did a cast and aliased the field. I then joined this to my base
table and rebuilt the model. I now have some other errors to work through,
but I was happy with this approach.

Thanks,
Steve MunLeeuw

Reply to this Message