Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Print Multiple of one label 1
- Thread starter crachic
- Start date
- Thread starter
- #3
-
1
- #4
- Thread starter
- #5
- Thread starter
- #7
I am adding to this thread a problem I am having.
I have gone through faq767-3227 and thread149-1374954 and am using a "REPEATER" table to get the desired quantity of labels on my sheet.
The problem that I've run into is that some of the items I am working with are purchased in bulk and sold individually
Purchase_Measure = 25pack
Sales_Measure = EACH
On my label it is of course only giving me the 'ordered_quantity'.
What i have been trying to do is work with a formula to get the report to show quantity as "Sales_Measure x Purchase Measure x Quantity Ordered". I can get the number, but it only shows up as the total number (25) instead of repeating the label 25 times (or 50 times if it is ordered twice etc...).
Anyone worked with something like this?
As I said, I have the label repeating properly for the quantity ordered, but need it to reflect if there are bulk packs ordered and make the appropriate # of labels.
Thanks,
Robert M. A.
I have gone through faq767-3227 and thread149-1374954 and am using a "REPEATER" table to get the desired quantity of labels on my sheet.
The problem that I've run into is that some of the items I am working with are purchased in bulk and sold individually
Purchase_Measure = 25pack
Sales_Measure = EACH
On my label it is of course only giving me the 'ordered_quantity'.
What i have been trying to do is work with a formula to get the report to show quantity as "Sales_Measure x Purchase Measure x Quantity Ordered". I can get the number, but it only shows up as the total number (25) instead of repeating the label 25 times (or 50 times if it is ordered twice etc...).
Anyone worked with something like this?
As I said, I have the label repeating properly for the quantity ordered, but need it to reflect if there are bulk packs ordered and make the appropriate # of labels.
Thanks,
Robert M. A.
What field/formula are you using for order quantity? Are purchase measure and sales measure separate fields? How do these two fields work with the order quantity field? It would help if you showed how a detail report would look with these fields for a couple of items.
Did you create a repeater table? How did you link?
-LB
Did you create a repeater table? How did you link?
-LB
the report consists 6 tables
Inventory_History (stores the purchase order item info)
Item_Measure (sell price / cost price etc...)
Items (generic item info)
Measure_Factor (defines measures and values ex. 25pack = 25, EACH = 1)
Purchase_Orders (order info)
Repeater
The 'order quantity' is obtained by using the "Inventory_History.Quantity" linked to "Repeater.number". That worked to get the actual quantity for the report.
- Yes, purchase measure and sales measure are different fields. They are both found on the "Items" table.
- The quantity ordered is found on the "Inventory History" table.
- The purchase measure and sales measure fiels are txt fields that state "25P, EA, 6P" etc... and it uses the "Measure_Factor" table to define the values.
- The Item_Measure table has 2 lines of data for each item, the purchase and sale information for each item.
I don't have SQL knowledge so I use Crystal for piecing the report together... Sorry, that makes my ability to explain the report a little 'sketchy'...
Right now the report is great if the entire purchase order is items with order quantity "EA".
Inventory_History (stores the purchase order item info)
Item_Measure (sell price / cost price etc...)
Items (generic item info)
Measure_Factor (defines measures and values ex. 25pack = 25, EACH = 1)
Purchase_Orders (order info)
Repeater
The 'order quantity' is obtained by using the "Inventory_History.Quantity" linked to "Repeater.number". That worked to get the actual quantity for the report.
- Yes, purchase measure and sales measure are different fields. They are both found on the "Items" table.
- The quantity ordered is found on the "Inventory History" table.
- The purchase measure and sales measure fiels are txt fields that state "25P, EA, 6P" etc... and it uses the "Measure_Factor" table to define the values.
- The Item_Measure table has 2 lines of data for each item, the purchase and sale information for each item.
I don't have SQL knowledge so I use Crystal for piecing the report together... Sorry, that makes my ability to explain the report a little 'sketchy'...
Right now the report is great if the entire purchase order is items with order quantity "EA".
Sorry for the confusion.
I said I was trying to create a formula that would work to give me the output I wanted, but was up to this point unable to do so.
The quantity is working simply from the field on the repeater table being linked to the quantity field on the Inventory History table.
From reading other posts though, when people aren't able to create a repeater table, the option of using an existing table a second time has worked. I'm wondering if I can somehow add the repeater table I have a second time and link it to the table defining the Measure total (ie. 25pack = 25 etc...)
Like i said, there is no formula for the quantity, and anything I have tried to use as a formula, has simply given me a number, but is not duplicating the section because it is a field that is not linked to the repeater table (and can't be because it's a formula field).
R A
I said I was trying to create a formula that would work to give me the output I wanted, but was up to this point unable to do so.
The quantity is working simply from the field on the repeater table being linked to the quantity field on the Inventory History table.
From reading other posts though, when people aren't able to create a repeater table, the option of using an existing table a second time has worked. I'm wondering if I can somehow add the repeater table I have a second time and link it to the table defining the Measure total (ie. 25pack = 25 etc...)
Like i said, there is no formula for the quantity, and anything I have tried to use as a formula, has simply given me a number, but is not duplicating the section because it is a field that is not linked to the repeater table (and can't be because it's a formula field).
R A
I was able to figure this out.
I added the repeater table a second time under an alias.
Linking the Purchase_Measure field on the "Items" table to the Measure_Code field on the "Measure Factor", then linking the "Conversion_Factor" field on the "Measure_Factor" table to the repeater table and using 'inner join' & >=, gave me the results I was looking for.
Sorry for the messy descriptions of how I was working with this. After realizing the formula wasn't working I erased it and so didn't know what I had done, in trying to replicate it to share with you for a different solution I was able to get this one working.
Thanks for your help lbass...
Robert A.
I added the repeater table a second time under an alias.
Linking the Purchase_Measure field on the "Items" table to the Measure_Code field on the "Measure Factor", then linking the "Conversion_Factor" field on the "Measure_Factor" table to the repeater table and using 'inner join' & >=, gave me the results I was looking for.
Sorry for the messy descriptions of how I was working with this. After realizing the formula wasn't working I erased it and so didn't know what I had done, in trying to replicate it to share with you for a different solution I was able to get this one working.
Thanks for your help lbass...
Robert A.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question