Adding stuff to a report

Hey guys,

I work at the ecommerce department in my universities bookstore and we get orders through a really shitty system called winprism.
It creates reports in Crystal reports, but we need to add some items to the report but we do not have access to edit the reports and the software company has a very bad support system.

We have been trying to add a box to an empty space in the report that identified who printed it, who charged it, the date it was charged and a barcode for the order number for easier filing purposes.

There are a couple of ideas I had:

Print it to a virtual printer and then add the items from another program in the form of a stamp and then print a physical copy from that software, but i dont know if any such programs exist.

Is there any way to program in VB6 a virtual printer that imports the document into VB6, add the box and barcode and then print it from there.

The most immediate problem I see is that when trying to print to a virtual printer such as the XPS document writer is that it wants to save each document and asks for a name but we print up to 50 orders at a time.

Can anyone help me with this or suggest a software that does this for you.

Mathemagician,

I had a similar issue sometime back. The DB was archaic and the info was not all in in one place.
Question 1. My assumption is that all the info who printed, who charged, etc.. is stored somewhere in the DB right?

Question 2. Can it be exported to excel? If so you may not have to go through so many steps to get your required results..... Before i go into a possible fix let me know the answer to the first two questions.

Quote:

---

Originally Posted by noobi

Mathemagician,

I had a similar issue sometime back. The DB was archaic and the info was not all in in one place.
Question 1. My assumption is that all the info who printed, who charged, etc.. is stored somewhere in the DB right?

Question 2. Can it be exported to excel? If so you may not have to go through so many steps to get your required results..... Before i go into a possible fix let me know the answer to the first two questions.

---

noobi,

No, it is not that complicated, who printed and and who charged it are usually physically written on the printed copy, so there fore it will not require a connection to a DB.

No, it do not think it can be exported.

I made a quick program in VB that replicates a the kind of report that we print and added the items i need to add to it.

i have attached a screenshot of it.

the barcode under the order number is one of the items i want to add

and the box within the customer box that says charged by print by is also what i want.