I am using crystal that is integrated into an ERP system called MAS500.

I have a request to combine the part number and a unique field with 6 digits on the report that will count the number of prints requested.  These numbers must not duplicate.

For example, I have part number 666.  I want to print 10 of this report.  The numbers would be as follows: 666000001, 666000002, 666000003.........666000010.

How do I set this counter up?  I have looked at adding a Summary, but didn't see how I could make it relate to the number of prints.


Thanks in advance for your help.

Thanks for the suggestion.  One other thing is that the whole printing process takes place outside Crystal, in the ERP system.

The client brings up the report module in their mobile system, and tell it from the handheld device, how many to print.  It is not like printing a report as usual where you hit print, tell it 10 copies and then Crystal prints them.

It is all controlled from the handheld device.

Basically I create the reports and they are assigned to a part number in the ERP system.  The report is then printed for the individual part numbers from the handheld device to a printer.  You tell the device how many copies, not actually Crystal.


Maybe this changes the above suggestion, IDK.

This is the first time I have used Crystal Reports where I am not printing from the App itself.

I am still a little confused. 

I have added an excel file called PrintNumbers to the report.  All that is in the excel file are numbers 1-500 in column A of sheet 1.

In Database Expert, under Access/Excel (DAO), I have the file location on the server (C:\PrintNumbers.xls. 
Under that, I have Copies$.

I add Copies$ to the Selected Tables.

I try and create Command Object.
I tell it new object.  In window that comes up, I enter the following:

select * from ITEMS cross join COPIES where COPIES.COPIES < {?copies}
I create the parameter inside the object.  I have it created outside the object but it is not available to me when I am typing the command query.

I hit enter, put in a number for copies, and get a syntax error in the from clause.

Now where do I go?

Can someone please help me to figure this out?

I really have done work on trying to fix it but cannot make it happen.

I need help pretty bad.


Edited by gloworm - 05 Dec 2011 at 7:48am

its ok.  thanks for offering the suggestion.