Hi.
I created an ASP page that uses the 'ExportToFile' command to allow a button to appear to Export the contents of my query.
It works fine - however, for some odd reason, it overwrites my date field with an invoice number field.
The only thing that I can think of, is the name of the field is called Invoice #.
Is it possible that the '#' is the cause of this behavior of overwriting a field when the ExportToFile occurs?
As well, where is it exactly that I can see in the system logs the action of an ExportToFile to determine if this is the real cause of the issue?
Here is the Invoice # header that appears on the screen:
Here is the Export to File content in CSV within excel:
Notice how the Invoice # is duplicated instead of having the date appear.
---
One more thing - where is it that you can change the name of the header? I checked in the view, and there is no alias - the actual name of the field is invoice.
I'm confused how the Invoice # is appearing when the view it is based on doesn't have it. Is it possible to rename a header in a block?
Let me know,
Thanks,
Steph