Jump to content

Sub-summary totals need to breakout items


NetCov

This topic is 2234 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Good Morning,

I need help trying to create this report as I can not figure out the best method of doing this. Here is what I need the report to do. My report is a sorted list of technology assets by location name. In each sub summary I need to list the count of all different types of devices. The device types are a value list which has all the items such as “Desktop, Laptop, Firewall, Cellphone” in the list. How can I get the totals for each location of each of these devices to appear? 

Please see the image below for an idea of what I am talking about.

Thank you in advance for your help!

help_image.jpg

Link to comment
Share on other sites

There are various ways to accomplish this but the one I use is something like this:   countTypes.fmp12.zip

Screen Shot 2018-02-14 at 9.08.17 AM.png

Essentially a related table based on your location then looping thru the record found set and counting up each known type - you will have to add columns for each type of count your need.

 

Link to comment
Share on other sites

This topic is 2234 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.