SteveB2175
asked on
How to create a formula in VS2005 Crystal Reports
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::
123 widget
0 $15.24
9 $15.00
$00.24 <==== This is the field I am trying to calculate
456 next description
0 $20.00
9 $21.00
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)...
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::
123 widget
0 $15.24
9 $15.00
$00.24 <==== This is the field I am trying to calculate
456 next description
0 $20.00
9 $21.00
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)...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you so very much, this would have taken me forever to figure out.
The only thing I changed was the last name in the group footer, I don't know if you intended for it to be the same name as the header formula or not.
Thanks again