Display of Variant hosed

[michaelcoleman]

I having an interesting problem. I have sql query which gets data and one of the fields is a variant. The variant field displays fine on cyrstal reports and also on my sql client. When I publish the report on a website, the value for these fields are displayed in ascii hex format...........?

Any ideas how to fix?

btw, I'm using ASP to display reports and also using ADO to retrieve data server side.

MJC

 

[michaelcoleman]

All,

nm, there is probably a better way but i decided to do a convert function to a view i created for this report.

convert(FLOAT,a.ResultValue)'ResultValue'

MJC