Hello All,
am new to crystal report and i got this problem, can anybody help me with this?..
am going to make a report in crystal with these predefined conditions:
The report can be sorted by Vendor #, Purchase Order # or Item #1. If sorted by Vendor #
a. Group Header: Vendor # (Company Name)
b. Details (in this order): PO #, Request Date, Warehouse, Item #, Unit of Measurement, Order Qty, Unit Cost, Discount Rate, Ext. Net Cost
2. If sorted by Purchase Order #
a. Details (in this order): PO #, Vendor #, Request Date, Warehouse, Item #, Unit of Measurement, Order Qty, Unit Cost, Discount Rate, Ext. Net Cost
3. If sorted by Item #
a. Group Header: Item # (Description)
b. Details (in this order): Warehouse, PO #, Vendor #, Request Date, Order Qty, Unit Cost, Discount Rate, Ext. Net Cost
What I have done, was to make a stored procedure that has a parameter for the sorting field and on the crystal report I have 3 Group headers (GH1 for Vendor# GH2 for PO# and G3 for Item#) , however when providing a parameter that will satisfy the sorting for Item#, the Item # won't be able to group by itself.
That's my problem, I want to group the GH2 and GH3...
help is highly appreciated. Thank you.
IP Logged
