Summary Report

Question

Hi Everyone,

I am trying to create a report that will summarize a numeric field per address, but I need to display other fields on the record... Does the platform supports this?

Example of today's report output:

Customer
Cust ID
Terms
Invoice #
Subdivision
Jobsite Address
Material
Customer PO#
Date
Ticket
Qty
Unit Price

Pulsar Homes
13249
15
101
Allen
9999 Test Dr
Millines
12345
11-28-2023
78932-92740
2
$120

Pulsar Homes
13249
15
101
Allen
9999 Test Dr
Millines
12345
12-05-2023
78932-92740
2
$120

Pulsar Homes
13249
15
101
Allen
9999 Test Dr
Millines
12345
12-08-2023
78932-92740
2
$120

I would like to display these 3 rows grouping them by address and adding the Qty as well as Unit Price...

I am able to do it but I can not include the other fields.... only Address, Qty and Unit Price...

Any help will be greatly appreciate it!

Regards...
------------------------------Miguel Francis------------------------------

MarkShnierYou · Answer

have you considered using a simple table rdport and sing yhe Group by sort option to sort and group by address?

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

Customer	Cust ID	Terms	Invoice #	Subdivision	Jobsite Address	Material	Customer PO#	Date	Ticket	Qty	Unit Price
Pulsar Homes	13249	15	101	Allen	9999 Test Dr	Millines	12345	11-28-2023	78932-92740	2	$120
Pulsar Homes	13249	15	101	Allen	9999 Test Dr	Millines	12345	12-05-2023	78932-92740	2	$120
Pulsar Homes	13249	15	101	Allen	9999 Test Dr	Millines	12345	12-08-2023	78932-92740	2	$120

Sign up

Login to the community