Hi, what is the process to purchase OpenReports Professional Version? best regards, Mehmet
what is the process to purchase OpenReports Professional Version?
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...
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.
Does column alaising work? SELECT projects.name as project,trackers.name as tracker, issues.subject , issue_statuses.name as status 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 On 18 October 2017 at 21:26, 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...
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...
Je suis absent(e) du bureau jusqu'au 16/08/2017 Please contact David Bouet (68.27) for any urgent topic. Remarque : ceci est une réponse automatique à votre message "[oreports:discussion] Compatibility of Open Report 3.0 on Windows 2008 Sp2" envoyé le 7/26/2017 4:28:11 PM. C'est la seule notification que vous recevrez pendant l'absence de cette personne.
Hi all, I would like to know if Open Reports 3.0 is compatible with Windows Server 2008 Sp2. Thanks in advance. Regards,
Hi all, I would like to know if Open Reports 3.0 is compatible with Windows Server 2008 Sp2. Thanks in advance. Regards,
Hi all, I would like to know if Open Reports 3.0 is compatible with WindowsWindows 2008 Sp2. Thanks in advance. Regards,
Dear, How to include current date in email subject when we schedule reports. I am...
Hello, to access to OpenReports, I use this URL http://127.0.0.1:9002/openreports/,...
Hi again; My SQL is: SELECT name, surname FROM rapor_f_kisa rf . . . WHERE master_id...
Hi; Do you know passing user_id parameter in jxls report. I try OPENREPORTS_USER_EXTERNALID,...
There is no custom groups !
New bug, Time Format bug; 0 clock in the morning, not 12 clock
openreports version 3.2.0
Unable to new report
How to schedule excel report as not editable in open reports.
First of all hello to the community and this was the second most ideal place I think...
How to Schedule a report in csv format