Hi,

Is it possible to join tables in Crystal Records by using not simple and usual field A = field B but something more complex like:

select * from table1 inner join table2
on table1.A=2*table2.B

or

select * from table1 inner join table2
on ASCII(table1.A)=ASCII(table2.B)

By way of explanation, in Crystal a Command is just a SQL Select statement that will pull all of the data that you need for your report.  Joining a Command to tables or using multiple Commands is not recommended as it will significantly affect the speed of your report.  If you need to use parameters with a command, DO NOT create them in the report itself - instead create them in the Command Editor and use them in the SQL.