Dear coders,
I wish to add a dynamic title to the Excel Reports I download, is this possible? I wish the titel to include the week.
on from .'Planned Purchase Orders'.'Lines'
select
'Supplier Name' : text "Growers Packers BV" as text
// 'Delivery Address' : text ^ ^ ^ > 'Order'.'Type'?'Sale' : 'Delivery Address' as text
'Week' : text : 'Week' as text
'Kind of Produce' : text : 'Kind of Produce' as text
'Size' : text : 'Size' as text
'Colli Type' : text : 'Colli Type' as text
'Class' : text : 'Class' as text
'Packaging' : text : 'Packaging' as text
'Total Colli' : number : 'Total Colli' as number
'Price/Kg' : number : 'Price' as decimal -2
'Departure Date' : number : 'Departure Date' as date
'L-Code' : text : 'L-code' as text
'T-Code' : text : 'T-code' as text
where
//- ^ ^ .'Day' in ( ?'Today' ?'Tomorrow' )
// - > 'Activity'.'Report End Time' > & 'Starttijd' // TODO: add <= and >= to the language
// - ^ ^ ^ > 'Order'.'Delivery Date' == & 'Delivery Date'
limit 1048576 // Excel row limit
Is this the correct documentation?
https://alan-platform.com/pages/docs/auto-webclient/yar.11/query/grammar.html