Skip to Content
author's profile photo Former Member
Former Member

cannot extract UDF(Alphanumeric) in Crystal Report 2008 Add On ver


Customer is using 2007A PL30. Crystal Report Basic 2008 Ver We try to generate report using Crystal report add on but cannot find those UDF where data type is alphanumeric. In database, system is showing nvchar(MAX). We need to modify in SQL database into nvchar(10) before we can view and extract in Crystal report. It is impossible to change it one by one.

May I know any hotfix for this bugs. It is impossible to change field by field as this customer had many alphanumeric type of UDF.



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 15, 2009 at 01:57 AM


    Try to apply some service pack and hotfix, changing the UDF properties means might loss data from saved UDF from database.

    Refer to this link



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member


      An example of UDF in Business Partner(OCRD) is as follow:

      Title Description Type

      CustSpec CustSpec Alphanumeric(10)

      I got some information that we can add key in User Defined Field-Management but not all the UDF in Business Partner can be assigned with key.

      I always hit this message

      [Microsoft][Microsoft Native Client][Microsoft SQL] Cannot drop the index dbo.ACRD.IX4 because it does not exist or you do not have permission. User key description(OUKD).

      If possible any changes can be done through front end application rather than backend. Is Business Object going to fix this bug?


Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.