I have been following the exported file name thread. Our client is wanting to change the exported file name on several reports. I have been looking for a resource to give me some direction. On the PO I tried doing
=Format( 'PurchaseOrder {0} {1}',[@OrderType],[POOrder.OrderNbr],[Vendor.AcctCD])
And it would not give me the vendorid in the file name. Are there directions or examples that I might follow?
Best answer by craig2
View originalThat worked great. Thanks Craig
+1
A good way, not that I’m aware of. I’ve had to wrestle with that same issue several times.
But try something like this for that last parameter:
CONCAT(Day([ARInvoice.DocDate]),Month([ARInvoice.DocDate]), Year([ARInvoice.DocDate]))
You should be able to rearrange, add spaces, etc. as needed.
It worked well. Of course the problem is going to be the format of the date. Is there a good way to format the date to just be the date and not the time?
=Format( 'ARInvoice {0} {1} {2} {3} {4}', IsNull([@DocType],''),IsNull([@RefNbr],''),[Customer.AcctCD], [ARInvoice.RefNbr], [ARInvoice.DocDate])
The results
Thanks for the tip. It worked well. I will continue to add fields the same way
+1
Good morning,
Try this, it looks like you are missing your third Format parameter (even though it’s a 2):
=Format( 'PurchaseOrder {0} {1} {2}',[@OrderType],[POOrder.OrderNbr],[Vendor.AcctCD])
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
