CR XI - SQL Server 2005 - Field not showing on links screen

[ReportDr00]

Hello

I am trying to find a column that i can use to join to other table but it is not showing, but the column appears when i try to drag and drop it on the report.
The column type is crystal is showing as Memo and in sql server it is ntext. I see the column in sql server and also under database fields but not under links why?
I think it is the column type that is causing the issue i guess?
how can i show that column on links so i can use it to link it to other table.


Regards

 

[Turkbear]

Hi,
CR wil not show memo fields in the linking expert but you may be able to link by that field if you use a Command Object to create your Query instead of having CR create it..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[ReportDr00]

Ok

Thanks