Consider this best way
creating a column
Std_Roll_Number
in the table
Record_Student
OR
creating a column
Short_Roll_number
in the table
Record_Roll_Number
Store appropriate values(on additional column) when you store data in tables.
After done any of the above, you could join the tables in query & generate desired output.
Crystal reports requires the tables with matching datatypes of columns(When you do relationship in reports designer).
Besides you'll get additional benefits from this way.
EDIT
---------------
Quote:
This is a simple way, i don't like to implement this method, i want to apply simply a join from crystal report, it is the requirement from my client, so help me to perform this using crystal reports.
You don't like the simple way? Anyway I'll give you an another option.
Are you using Database connection for your reports? IF yes then go with this way.
C# Crystal Reports from SQL Query[
^]
In this way you need to do changes in query like below. Bind one datatable using this query & another datatable with other query.
SELECT LEFT(Std_Roll_Number,10) Std_Roll_Number, other fields FROM Record_Student
If your reports not using database then go with this way.
C# Crystal Reports without database[
^]
Same way(above sql query way), you need to bind one datatable with extracted
Std_Roll_Number
.
That's it.