I am new to crystal reports and trying to recreate a report this is currently manually produced, within the manual process we extract the info from various tables and merge them within an excel template to create the data group we wish to analysis.
My requirement is to list material info ( multiple fields, code, description, uom etc) next I wish to have a "Key Figures" to display restricted totals for Total on hand and Nettable Qty on hand. Nettabe meaning availalbe to consume.
Example of required layout:
Item Description Foreign Code Standard Cost UOM MainWhs WIP R&D MRB
abc def ghj 100 each 10 0 0 5
Note: This info needs to be an a final format that will export easily to excel
The Total is stored currenty in one key figure named Warehouse, I need to current new key figures for each warehouse.
I think conditional sum should work for my situation, but I can not get it to work.
Example of formula I am trying to use : Sum ({OITW.OnHand},{OITW.WhsCode} , "Main")
How I am getting the following error message when trying to save the formula "A group condition is not Allowed here"
What am I missing?
Or is conditional sum the best solution - all help and advise, very much welcome.
Edited by Logically - 04 Jul 2013 at 10:09pm
IP Logged
