Simple Reporting

Post Reply
JimM
Posts: 1
Joined: Fri Nov 26, 2010 2:29 pm

Simple Reporting

Post by JimM » Fri Nov 26, 2010 2:40 pm

Hi all

New to Autoline but am trying to write some simple reports. First question is how do I 'subtotal' a number of transactions into 1 row.

eg in a POS report I have a single table, 'parts' and have created a derived field TOTCOST being !1_COSTPRCE* !1_ORDERQTY

Format of the report is very simple, just has WIPNO & TOTCOST

When I run the report it brings up several lines for each WIPNO ie a line for each individual part cost - how can I 'subtotal' the parts costs so that the report just has 1 line for each WIPNO ?

I've tried the subtotal check boxes etc but that puts a total at the end of the list which is not what I want

Thanks

Jim

repgen
Posts: 4
Joined: Thu Apr 29, 2010 9:13 pm

Re: Simple Reporting

Post by repgen » Sat Nov 27, 2010 9:55 pm

A few items to check, 1st on the title tab is the check box set for Totals Only, 2nd on the sequence tab are you running any sort sequence and if so are the subtotals checked to total and 3rd on the format tab are the fields set to total in the definition. Without a bit more detail it would be difficult to tell you exactly what’s needed but these are the three main pointers.

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests