Dataman

create a report parameter add the new parameter to the "report parameters" tab add the parameter name to your sql in the Query box $P!{PARAMTER_NAME} On Wed, Oct 18, 2017 at 8:10 AM, imane enami@users.sf.net wrote: Hi , I didn't know how to create a report with parameter using sql query? if someone can help me with example . Thanks Creating first report with parameter using sql query https://sourceforge.net/p/oreports/discussion/187722/thread/9a7c93ee/?limit=25#8132 Sent from sourceforge.net because...

Give the fields new names: projects.name AS project_name,trackers.name AS trackers_name, Then the entire original SQL in a outer query: SELECT * FROM ( put original sql with the new field names here) ; On Wed, Oct 18, 2017 at 5:26 AM, imane enami@users.sf.net wrote: 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...