build report using sql query

hi,

i am using crystal report 8.5 and oracle 9i as database.

can i build report using SQL query rathere then selecting tables and join them in relation..



thanks

Should be able to use the select expert in Crystal. Did you try that?

yes i try that...
i want to ask that if u use oracle report with formula column...
is there any thing like that in this ?????

thank you

You can also use an ADO recordset as the DataSource for the report.