Crystal Reports How to amend field in access?

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: How to amend field in access?

Post Reply

Post New Topic

Author	Message
Oxfire Newbie Joined: 03 Apr 2009 Location: United Kingdom Online Status: Offline Posts: 2	Topic: How to amend field in access? Posted: 03 Apr 2009 at 7:20am
	Does anyone know how to amend a field in an access database file through a crystal report? For example i want to change the data in this field {Customer.OrderID} to "e"? Grateful if anyone can help
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 03 Apr 2009 at 7:41am
	create a formula field: if isnull({Customer.OrderID}) then "" else "e"
	IP Logged

Oxfire Newbie Joined: 03 Apr 2009 Location: United Kingdom Online Status: Offline Posts: 2	Posted: 03 Apr 2009 at 9:21am
	thanks, but can you actually physically alter the data held in the database, in the Customer.OrderID field? i need to do this to "tag" invoices after ive sent them
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 03 Apr 2009 at 9:46am
	I don't believe you could do that from crystal. Perhaps you can create a process to export the orderID into a spreadsheet and use that to update your DB? You could use a sub report within to only show that data and make sure that the ID's mtach to your main report that is creating the invoice... Anyone else have other ideas?
	IP Logged

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum