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.
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.
Abhilash Kumar 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.