Search results for query: *

I'm referring to the same report I am working from thread767-1439697. Is there no other way to get this same result without using the command?

I'm trying to do the same thing that is described in this thread. I've added what you suggested and it's not working. Are you using this command as the only datasource? When I tried this I had already written my report by adding all the tables required, and am now trying to add a command...

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...

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...

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...

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...

dgillz... thank you so much, that worked perfectly. It's always something nice and simple huh?..haha... thanks again, perfect solution for what i needed.

I was thinking of going this route. Or wondering if there was a way to create a SQL view that would be like having the information in a new table. We can create new tables on the database, the only problem is that I will be using this report through crystal enterprise to allow people to run...

I'm an entry level report writer, I pull the table / field information through Crystal, not SQL. I'm writing a report of labels, each detail section contains information found on various tables (not one single table). One of the fields is 'quantity' and I need the detail section repeated the...