When to use SQL Views?

Do you mean SQL Views in PHPRunner or SQL Views in the database? How are reports and charts relevant here?

I mean SQL Views in PHPrunner

I followed to example but I don't know how to insert variable {all_field_search}. Also, even my stored procedure shoudl return all records without using WHERE clause in the stored procedure. When I add the SQL View in the Dashboard and run the application, I cannot see anything on the Dashboard. Not know why the SQL View does not return any data

As a rule of thumb, you can use a SQL View when you need to use a SQL query that normal PHPRunner tables do support, i.e. a stored procedure call.