Good morning.
If you do a BAQReport, it might be easier to handle these calculations and format in Crystal, with the same BAQ you created.
One thing you could do at the BAQ level -if you decide not to go to BAQReport-, is to get your comparison between Std and Invoiced at the Release level; I would base my query on OrderRel table, linked to InvcDtl and OrderHed independently (InvcDtl table "naturally" links to OrderRel) and this way you wouldn't get duplicates, unless you Invoice single Order Releases more than once that is........ Just an idea....
Regards.
Roel Martinez
ERP Analyst
SABRE TUBULAR STRUCTURES (tm)
www.sabretubularstructures.com<http://www.sabretubularstructures.com/>
8653 E. Hwy 67 | Alvarado, TX 76009
Phone: 817-852-1700 ext. 11858 | Direct Line: 817-852-1858 |Fax: 817-852-1705
[Non-text portions of this message have been removed]
If you do a BAQReport, it might be easier to handle these calculations and format in Crystal, with the same BAQ you created.
One thing you could do at the BAQ level -if you decide not to go to BAQReport-, is to get your comparison between Std and Invoiced at the Release level; I would base my query on OrderRel table, linked to InvcDtl and OrderHed independently (InvcDtl table "naturally" links to OrderRel) and this way you wouldn't get duplicates, unless you Invoice single Order Releases more than once that is........ Just an idea....
Regards.
Roel Martinez
ERP Analyst
SABRE TUBULAR STRUCTURES (tm)
www.sabretubularstructures.com<http://www.sabretubularstructures.com/>
8653 E. Hwy 67 | Alvarado, TX 76009
Phone: 817-852-1700 ext. 11858 | Direct Line: 817-852-1858 |Fax: 817-852-1705
[Non-text portions of this message have been removed]