jtomson
March 16th, 2010, 03:28 PM
I am very new to Crystal Reports and am trying to figure things out as I go along.
My question is, can I make CR automatically print an excel file based upon a part number coming from our database?
I was able to make it dynamically update the image path for images we wanted to show up in the job traveler.... but the same method isn't working for an excel file. It will show an image of the excel file I originally created the OLE object from, but never updates it based on part number like the images.
The formula that I've been using is:
"\\server\Data\Shared Files\Traveler Attachments\Customer Images\" + {JobAsmbl.PartNum} + "\1.jpg"
The path changes a little for the excel file, but the idea is the same.
I don't know enough about it to know if it even supports doing that, or if it only works with images but I've been pretty stumped.
Basically, we have excel files that we would like printed out at the same time as the job traveler and I'm trying to figure out how to tie it together automatically. If I have to convert the excel files to another format that will work I'm fine with doing that.
I'm sorry if this makes no sense. I am having trouble figuring out how to phrase it.
Thanks for your time.
My question is, can I make CR automatically print an excel file based upon a part number coming from our database?
I was able to make it dynamically update the image path for images we wanted to show up in the job traveler.... but the same method isn't working for an excel file. It will show an image of the excel file I originally created the OLE object from, but never updates it based on part number like the images.
The formula that I've been using is:
"\\server\Data\Shared Files\Traveler Attachments\Customer Images\" + {JobAsmbl.PartNum} + "\1.jpg"
The path changes a little for the excel file, but the idea is the same.
I don't know enough about it to know if it even supports doing that, or if it only works with images but I've been pretty stumped.
Basically, we have excel files that we would like printed out at the same time as the job traveler and I'm trying to figure out how to tie it together automatically. If I have to convert the excel files to another format that will work I'm fine with doing that.
I'm sorry if this makes no sense. I am having trouble figuring out how to phrase it.
Thanks for your time.