Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

  • Newbies
Posted

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

Posted

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.

 

This topic is 2474 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.