Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE development » Framework » Screen/Report - calculated/concat fields
Screen/Report - calculated/concat fields [message #5597] Thu, 02 June 2016 11:55 Go to previous message
htManager is currently offline  htManager
Messages: 415
Registered: May 2014
Senior Member
Can I display two or more field values as 'calculated' fields like this in a report (and/or in a screen):

$structure['title'][] = array('text' => 'CONCAT(vereine_kuerzel, \' - \', mannschaften_id)',
'width' => 100,
'align' => 'left',
'x' => 45);

I tried it with the SQL_FROM statement with a LEFT JOIN in the script file too but with no success.

$sql_from = 'training_plan_kopf '
. 'LEFT JOIN orga_mannschaften ON ('
. 'training_plan_kopf.vereine_kuerzel = orga_mannschaften.vereine_kuerzel AND '
. 'training_plan_kopf.mannschaften_id = orga_mannschaften.mannschaften_id) '
. 'CONCAT(vereine_kuerzel, \' - \', mannschaften_id) AS verein_id ';

The SQL statement brings up an error. You see an ending ')' behind the WHERE clause but no beginning one.

Or is there a better way?
 
Read Message
Read Message
Previous Topic: Task ID/Script ID
Next Topic: Convert date ccyy-mm-dd to dd.mm.ccyy
Goto Forum:
  


Current Time: Thu Mar 28 18:18:57 EDT 2024

Total time taken to generate the page: 0.00798 seconds