Skip to Content

Linking Reports With Different Data Type Fields or Formula

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.

1 Comment
You must be Logged on to comment or reply to a post.
  • 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