I can't get the SQL Query option to work when generating reports. I enter my query and click on execute and the system reports "Valid SQL Query". I then go through the steps but the resulting report are just a blank white screen. Not even the style I choose is there.
When using the "table" option it works 100% with no problems.
Is there anything specific I must do to get the SQL Query option to work cos I really need it ?
PS. I even used a simple query like : select * from tblname where columnname = 'criteria'; and still it doesnt work