Where Can I enter sql query in Crystal Reports 2008

[Former Member]

I need to read fields from two table and some of the 1 of the fields is common between two table and also need to add where clause for time picking.

Thanks

[Former Member · Accepted solution]

Hi Zuber,

Do you want to add a command or use the tables diretly by dragging them?

You can add the SQL command after creating the connection go to Add command and paste the SQL query, you can also add the where condition to it.

Hope this helps.

- Nrupal

[nscheaffer]

If I am understanding your question correctly, I believe you need to add a Command to your report.  See this video on how to do that.

http://www.youtube.com/watch?v=BHNHsIUbcn8

Noel