AnsweredAssumed Answered

Type of report, advice please...

Question asked by brian.curran on Dec 23, 2012
Latest reply on Dec 26, 2012 by taylorsharpe

Hi,
I'm looking at creating two reports, the first one is to send to customers and the second one is to help our accounts department prepare invoices. Any advice on the best type of report for each would be great...

 

1st) A report by Customer, which shows a list of incidents that we have responded to in a calendar month.

Report Title

Customer name, address etc.

Date, Time, Incident number, Hours, Rate, Sub-Total

Totals of Hours and Sub-Totals

 

2nd) A report of all Customer incidents that we have responded to in a calendar month.

Report Title

Grouped by Customer name

Date, Time, Incident number, Hours, Rate, Sub-Total
Totals of Hours and Sub-Totals for this customer only

Grant totals of hours and sub-totals for all customers listed.

 

A basic list report for the 1st and a sub-summary report for the 2nd?

How would I set the date ranges, in MS Access I used parameters but I'm not sure how to do the equivalent in FM...

 

Thanks

Brian.

Outcomes