Report Builder display label

By Toledoh - September 26, 2019

Hey Guys.

I'm using Report Builder to display the activity of agents, and the part of the SQL below displays the agents.  However this displays the "num" and I want to display the "label".  In php I would saug $record['agentsNum:label'].  How do I do that here?

SELECT
agentsNum as 'Agent',
nlb_subscribersNum as 'Contact',
DATE_FORMAT(<?php echo $TABLE_PREFIX ?>notes.updatedDate, '%M %Y') as 'Date'
FROM <?php echo $TABLE_PREFIX ?>notes
GROUP BY Agent
ORDER BY Contact

Cheers,
Tim (toledoh.com.au)

By Toledoh - September 27, 2019

Perfect - thanks Daniel.

Cheers,
Tim (toledoh.com.au)