Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Table joins in crystal report

I have imported two tables into crystal report and I know how to link the tables based on the columns. But I have a column in table 1 whose size is 4 and in another table whose size is 2.

Ex:

Table1:

Column

0101

0102

0103

0201

0202

0203

Table2:

Column

01

02

03

04

while linking these tables how can i take sub string of table1 column. Do i need to use SQL expression after linking the tables? if yes how can i map the SQL expression to the field.

Please suggest

Tags:
Former Member
replied

Right-click the Subreport > Select Change Subreport Links > Move the formula field/database field from the pane on the left to the pane on the right > From the drop-down at the bottom right that says 'Select data in Subreport based on field', choose the corresponding field from the drop-down.

-Abhilash

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question