Skip to Content

Link between 'Document' and 'Document rows' in Crystal reoprts

Dear All,

I have created a Document type table and Document rows table in SAP and the corresponding UDO has registered successfully.

I'm trying to create a report using crystal report (for SAP Business One and not in Visual Studio i.e SDK)

In Database expert, I was not able to link the Header table and child table, as the DocEntry fields are not even displaying in Link tab of Database Expert.

Whether it is the limitation of Crystal reports?

Now I'm managing by creating a View. Is there any other easier way for this?

Regards,

Bala

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 15, 2011 at 08:58 PM

    Please see Note 1226534 for why you can't use UDF in Linker.

    You can create a view, as you have done, or use the Crystal Add Command functionality. Only advantage to Add Command is you can import report into another database company and the command comes with it; no need to remember to rerun Create View in SQL.

    I just learned about this myself.

    For more details, please see my post "Linking UDF in Crystal Report, work around" from April 13.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 16, 2011 at 05:31 AM

    Bala,

    While in the 'Link' tab within the Database Expert you can only link fields that are the same type such as int to int, nvarchar(NN) to nvarchar(NN), etc. A field type nvarchar(max) is, in Crystal, a 'memo' field and cannot be linked to any other field, that would be why it does not appear in the display. You would either have to change the field type definition or, instead of using the table, create a command to execute a sql statement and converting the field(s) as needed.

    Ron

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Ron,

      Thanks for your reply.

      But in my case, I'm not creating the DocEntry field. System is creating automatically while creating the table as Document type and Document rows type. I believe that the DocEntry fields of the Document and Document rows are of same type with same size.

      Am I going wrong anywhere?

      Regards,

      Bala

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.