CR8 Select Expert will not see text fields in SQL Datbase

[mark929]

I have an ASP.Net web form populating a SQL database. The form includes checkboxes, optionbuttons, and 3 textboxes. In CR8, the select expert does not see the 3 text box fields. I am using the select expert to filter out empty record fields. This works fine in everything but the 3 text boxes (which are set to "text" data type). Any Ideas why the text fields are not visible.

Thanks

Mark

 

[synapsevampire]

Crystal 8.5 and below only supports <= 254 character fields.

You can create a SQL Expression and parse out the first 254 characters if you'd like, or even perform whatever function you need on the database side and return the result:

SQL Expression:

substring(MyField,1,254)

Now base the comparison on this SQL Expression (it will show up as a field in the report).

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com