Select Expert will not see text fields in SQL Database

[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. Any Ideas why the text fields are not visible.

Thanks

Mark

 

[dgillz]

I suspect these are not text fields, but memo or blob fields. This is the nature of a memo or blob field. It cannot be used in any formula.

If you look at the filed through the field explorer with the top right icon depressed, it will show you the data type and length of the field.

If you have the option, change the data type to text (254 character maximum in CR v8.5) and then verify your database in CR, and then you can use it in a formula. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[mark929]

dgillz,

Thanks for your response. I re-checked the data type and it is "text", although it defaults to 16 char and I seem to be unable to change it. If anything else comes to mind, please let me know.

Thanks

Mark

 

[bdjb]

Mark929,
I had a similar issue with CR9 not seeing blob fields, Crystal's fix was to apply the latest patches, and the database and driver update ( DBEX90drvr1002_EN.exe ). This allowed me to use the fields. (I could see them in field explorer, but use them in the report).

Hope that helps,

Bob

OK, so what's the speed of dark?

 

[mark929]

I hope to upgrade from CR8 to CR9 soon, and that should eliminate some of my problems.

As for this one, I have changed my 3 "text" datatypes to "nvarchar" and set the length to 255. This enables me to see the fields in the Select Expert, Formula Editor, and anywhere else they were not visible as "text". I just hope this doesn't cause any problems anywhere else. As of now, everthing seems to be working fine.

Many thanks to all who responded.

Mark