Re: HELP in Crystal report
BarCodes are nothing more then a font applied to a textbox control. So when you bind your numbers to the textbox it will be viewable in a barcode format. ;)
For the report you would need your db table and recors in it. Then create a query to select the transaction id and its related records for the purchase.
Re: HELP in Crystal report
I know about barcodes buddy. but i wanted to know how to retriew all 24 items..when i tried only 2 barcode appeared releating to the product 10001 and 10002!!!!!
Re: HELP in Crystal report
Well you didnt give any info on your db structure and related tables so until then I cant be more specific. ;)
Also, how are you connecting to your db via your report (ADO, ODBC, etc) and how are you viewing you report (VB6, VB.NET, ???)?
Re: HELP in Crystal report
First Thanks, for the respond.....
Let me tell you about the table structure.
I retrive data from just one table called stock which contains item_code, price, description, quantity. Item code is the one which i'll be needing barcode. but thats not the problem. I want to print inventory tags which will be attached to garment. So i need to print the tags according to the quantity in the inventory for each item. also i want to print them in a A4 sheet. I guess each A4 sheet shoud at least contain 4 columns. furthermore im using ODBC with SQL SERVER
Re: HELP in Crystal report
So basically your sql query will be calling the stock table and retrieving the quantity. This quantity will be the number of barcode prints.
You may be able to write your query so it takes the inventory quantity and dynamically create multiple records for whatever quantity. It would probably be a self join but I'm not 100% sure I know how to write that part.