String fields are not visible while using query

[shridhargune]

I have designed a query in Crystal query designer to union three paradox tables. And using this query in report designer. I am not able to access string fields in formula editor or group selection tab.

 

[kenhamady]

Are any of these string fields are VarChar or Memo? If so, see the FAQ on this issue. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[shridhargune]

These are string fields of maximum length 20
more details on this issue :

I am designing a query in crystal SQL designer. Its like :

Select * from Table1.db
union
Select * from Table2.db
union
Select * from Table3.db

I am using this query in CR designer. But I am not able to view any string field in formula editor or group selection tab.

But if i give a query like :
Select * from Table1.db

then I can access all string fields.

 

[kenhamady]

If they appear in other field lists, but they don't appear in these two lists, then they are probably being read as memo fields by Crystal. Find them in another list and "browse" them to see what data type Crystal is picking up.

Do all of the tables have the exact same settings for each field?

Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal