Help! Please
I am a newbee to Crystal and I am not sure how to write the report two pull data from three tables. The main part of the report gets data from SalesData, pulling customer name from the address table. I need to pull data from a third table that has costs in it. The Sales and costs tables are linked by the item field. The costs table can have upto 12 different costs(Materials, Scrap, Labor, Etc) for each item, and can also have multiple costs sets. How do I pull these different costs, at times adding some of them for a combined cost set and display them all on a detail line?
Thanks,
BcBrad
I am a newbee to Crystal and I am not sure how to write the report two pull data from three tables. The main part of the report gets data from SalesData, pulling customer name from the address table. I need to pull data from a third table that has costs in it. The Sales and costs tables are linked by the item field. The costs table can have upto 12 different costs(Materials, Scrap, Labor, Etc) for each item, and can also have multiple costs sets. How do I pull these different costs, at times adding some of them for a combined cost set and display them all on a detail line?
Thanks,
BcBrad