Skip to Content

Linking Reports base on different data type of fields or formula by using following steps in SAP Crystal Report:

1. Main Report ItemCode Field with VARCHAR Data Type

/wp-content/uploads/2016/03/ddt_901101.png

2. Sub-Report ItemCString Field with INTEGER Data Type and Formula ItemCFormula

/wp-content/uploads/2016/03/ddt_1_2_901103.png

3. Click Insert Menu > Insert Sub-Report. Now Select Field to link and leave Select data in sub-report based on field option unchecked.

/wp-content/uploads/2016/03/ddt_2_1_901102.png

4. Preview Main Report and Double Click Sub-report to open its preview. Then go to Report > Select Expert > Record > Add Formula for manual linking with main report.

/wp-content/uploads/2016/03/ddt_3_901104.png

5. Use formula to link sub-report field or formula with different Data Type to main report field manually.

/wp-content/uploads/2016/03/ddt_4_901107.png

6. Save and close and Preview main report.

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Alisia Gor

    Hello,

    Thank you for the detailed explanation. I followed the instruction but I am getting an error “String is non-numeric ” How can I fix it?

    Thanks

    Alisia

     

    (0) 

Leave a Reply