Using SQL Views in Crystal

[dkeller]

I created a view over an SQL table that selects out only certain record types. The view includes 3 columns.
Record Type
Record ID
Value
The original Table contains many Record types that I need to access seperately so I created a seperate view for each record type I need, each view containing only one record type.
I wrote a Crystal Report over the view that includes the Value field on it - no problem. The problem comes when I try to use the Value field in a selection statment. The Value field is not valid as a selection field.
Any idea why would I not be able to use this field in a selection statement? Is this a limititation of SQL views?

Thanks!!!!

 

[Krickles]

The Value field is not valid as a selection field.

Do you mean in CRs or actually in the SQL query?

Krickles | 1.6180

 

[dkeller]

Krickles,

Thanks for the response but I think I have it figured out. I was unable to use the field as a selection field in CR. The field is defined as a charvar with a length of 2000. In the view I just pulled out the number of positions that I needed (10 Pos.) with a substring and I was then able to use the field in Crystal.

Thanks, Dan