I am running VS 2005 Crystal Reports.
I have an Sql Query that selects part number records from inventory. Each part number as 2 distinct inventory categorys, "0" and "9". Therefore I am returning 2 records for every part number
I have created a Crystal Report that displays everything that I want except for the difference between the 2 inventory category values. My report looks like this::
$00.24 <==== This is the field I am trying to calculate
456 next description
The part number is in the "GroupHeaderSection1" area of the report. The inventory category and price are in the details section of the report.
Thanks for any help you can offer. (in case you haven't guessed, this is my first Crystal report)...