We're aiming to embed a select statement into a crystal report that has been created just using the database expert. We were wondering whether this is possible using crystal itself or whether we need to write the sql query first and then base a report on the query.
Our sql would be something like:
(select fkey from notes where created = max(created).....). and we want to in bed this as a column in another sql statement created by crystal using the database expert.