1. Export a copy of your custom report template
2. Zip it using WinZip
3. Attach it to your reply
4. Include in your reply the exact Field Name you are attempting to change the date/time display on and what detailband it is in - so that I know exactly which you are referring to.

p.s. I've moved this topic to the AyaNova v3 Printing & Report Templates section of this forum as this is in regards to designing report templates

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

Because this is an original report template, I can not import it without deleting the original report.

Please provide what this report template was called before it was renamed so that I can delete the original and than import this report template you have provided.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

There is not a grid in AyaNova called Progress

But I clued in that this is the original sample report template Custom Fields from the Custom Fields grid in the Service navigation pane.

Because this is a summary report template (as only summary report templates can be created from the Customm Fields grid), you can not use the FormatString setting for the datafield.

You would use as per the example in the topic http://forum.ayanova.com/Topic2271-100-1.aspx because this is a summary report template.

I do not have your data here to know exactly what you have set for the custom fields, but am assuming from your support request and the fields in this report that the field under "rec'd" has been set to the datatype of Date or Date/Time.

I've attached a copy of your report template following the steps in the above forum topic for the field xrLabel4 which is bound to the data WorkorderServiceCustomList.LT_WorkorderItem_Label_Custom1

Import this report template, select the field xrLabel4, and see the script I have copied from that forum post into the OnBeforePrint script, and how I have set the FormatString property for that field.

You can refer to this  field, copying the same script to the OnBeforePrint property for the other custom fields that you want to have show only the Date, as well as setting the FormatString property for the other fields.

Let me know this gets you going.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

	Post Attachments
	KeishaCustomFields.zip (2 views, 13.55 KB)