Hello all,
I’m new to Crystal, I’m trying to do a Free hand SQL report on Crystal XI but I have tried all and cannot find the option to create one… can you help me?
yodito (BOB member since 2009-09-10)
Welcome to B:bob:B!
I’m going to move this to the Crystal XI forum. ‘About BOB’ is just used for questions about this website, as opposed to questions about the tool.
Nick Daniels 
(BOB member since 2002-08-15)
Welcome to B:bob:B! [Moderator Note: Moving to Crystal XI - Jansi]
P.S: I’m sorry, Nick. We both reacted at the same time. 
Jansi 
(BOB member since 2008-05-12)
Hi Yodito,
If I understand what you’re asking for, then you can create a report based on a custom SQL command by going file\new\blank report and when the database expert opens up either create or select your connection and expand the list of schemas, at the top directly under the connection name, you should see an “add new command” option, select this and click the right arrow to add it to the selected tables and you’ll be prompted to enter your SQL query.
Andy.
andyherm (BOB member since 2008-09-26)