imane

Hi , I didn't know how to create a report with parameter using sql query? if someone can help me with example . Thanks

column alaising don't work also i tried it before.

Hi im new with openreports, i wrote an sql query wich successifuly retreive data from mysql console , but the same query didn't want to work with open reports below the sql query SELECT projects.name ,trackers.name , issues.subject ,issue_statuses.name FROM projects,trackers, issues,issue_statuses WHERE projects.id=issues.project_id AND trackers.id=issues.tracker_id AND issues.status_id=issue_statuses.id when i execute it in open reports it has like a confusion with the column name 'name' . One more...