Skip to Content
Author's profile photo m fahim

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.

Assigned tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Alisia Gor
      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