Hi!
Here's my problem: Each week, my company receives two emailed files from UPS. One is a PDF, usually two pages, that is an overview of their weekly invoice. Then, we receive a flat file containing the details of the shipments included on the invoice. I load that data up into SQL and then print out a Crystal Report that emulates a regular, detailed UPS invoice.
The problem is that our AP clerk has to print two files in order to see the complete UPS invoice. That's silly! I can't see any reason why I shouldn't be able to put these together into a single file. I just can't figure it out.
I thought I could store the PDF that UPS sends us in a SQL Binary field and then just include that field on my detailed invoice report, perhaps as the Report Header. The first problem is that I just can't figure out how to that that PDF into a field in SQL. I'm just not sure how to code that. And, I've tried just creating a hyperlink on the report, which doesn't work because someone has to click on it.
My theory is that I should be able to include the PDF at the top of the report somehow, even though it's two pages. Perhaps all I need is some guidance as to how, within VB code or through SQL Server DTS, to store the PDF file into a field in SQL. That's assuming, though, that I could access that field and print it from within CR 10.
Again, all I want to do is print out a two-page PDF document at the top of a Crystal Report. My theory is that it shouldn't be this hard! If anyone knows of an easier way to do this, please let me know. Any guidance would be greatly appreciated.
Thanks,
Karen Grube
klgrube@yahoo.com
Here's my problem: Each week, my company receives two emailed files from UPS. One is a PDF, usually two pages, that is an overview of their weekly invoice. Then, we receive a flat file containing the details of the shipments included on the invoice. I load that data up into SQL and then print out a Crystal Report that emulates a regular, detailed UPS invoice.
The problem is that our AP clerk has to print two files in order to see the complete UPS invoice. That's silly! I can't see any reason why I shouldn't be able to put these together into a single file. I just can't figure it out.
I thought I could store the PDF that UPS sends us in a SQL Binary field and then just include that field on my detailed invoice report, perhaps as the Report Header. The first problem is that I just can't figure out how to that that PDF into a field in SQL. I'm just not sure how to code that. And, I've tried just creating a hyperlink on the report, which doesn't work because someone has to click on it.
My theory is that I should be able to include the PDF at the top of the report somehow, even though it's two pages. Perhaps all I need is some guidance as to how, within VB code or through SQL Server DTS, to store the PDF file into a field in SQL. That's assuming, though, that I could access that field and print it from within CR 10.
Again, all I want to do is print out a two-page PDF document at the top of a Crystal Report. My theory is that it shouldn't be this hard! If anyone knows of an easier way to do this, please let me know. Any guidance would be greatly appreciated.
Thanks,
Karen Grube
klgrube@yahoo.com
