Best way is table/view

Hello guys,
Thanks for you kind help in advance.
Actually I want to know, which is the best way to develop a report is.
From a view or from table.
And how can I edit query (from show query)?
dipitI prefer to use views, mostly because if the database structure or table/column names are to change it is easy to modify the view so that the reports are unaffected.

I find it gives more flexibility, and selections/projections can be performed on the database side - I try to avoid using Crystal to perform joins where possible.

I haven't looked too much into the "show query" until now; however the Select [column names] probably comes from whatever has been dragged onto the report, while the Where [clauses] come from whatever you have entered into Report -> Selection Formulas -> Record.