Items to be displayed uniqiely in report!!

dynuser

Hi all,
I need to create a report for the Indent(Material Requisition).Here,on a given day, the production Orders will be released and the production order Numbers will be given to stores by the Production Department. Same item will be required in different production orders.I will have to write a report for the given range of Production Order Numbers.I have to print the Materials list without repeating the item codes from the PRODUCTION ORDER COMPONENT Table and their total quantity(of course sum of Remaining Quantity).
Can anyone tell me how to get the list of item codes WITHOUT GETTING IT REPEATED?Also how to take the total quantity?

Thank in Advance.

DaveT

Hi,

Two method come to mind:

1. sort the production order component table by Item and use group footers

2. Use a temporary table

The best will depend on the report structure.

dynuser

DaveT wrote:

Hi,

Two method come to mind:

1. sort the production order component table by Item and use group footers

2. Use a temporary table

The best will depend on the report structure.

Dear Mr. Dave,
Should i use the table view properties of Production Order Component Table for sorting purpose.Or should i write the code in the Report?Please tell me about Group footers.

Thanks

DaveT

Hi,

You can use the TotalFields / GroupTotalFields -this is the same as using the CREATETOTALS command. Have a look at the help on these.
Then create a section type GroupFooter and add in the field - the report will automatically total this for you.

dynuser

Dear Dave,
Thanks.I got the report and it is absolutely working correctly

Regards

DaveT

Glad to Help