Jump to content

Search the Community

Showing results for tags 'reporting'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro Advanced 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • FileMaker Friday Night Chat's Topics


There are no results to display.

There are no results to display.


  • White Papers
  • Infographics
  • Samples
  • Solutions
  • FMGo
  • Plug-Ins
  • Tutorials

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 8 results

  1. 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!
  2. L.S., Has anyone tried to use iReport of Jaspersoft Studio to build reports ( or even invoices ) from FileMaker data ?
  3. Summer is over and our weekly FileMaker webinars are back! Our first one is this Thursday at 11am PDT, on “Relationships for Beginners”. Register Here: https://attendee.gotowebinar.com/register/6892433068111504642 We will spend 30 minutes covering a specific topic. Then the last 30 minutes will be an open Q&A on any topic. Topic List: Sept 13th: Relationships for Beginners Sept 20th: Find Records, Date Ranges, and Special Operators Sept 27th: Conditional Formatting (Can I making something Red?) Oct 4th: Automation (Repetitive Tasks can become Scripts) Oct 11th: Reporting & SubSummaries Oct 18th: Merge Fields and Hiding Objects (Harry Potter Invisibility Cloak) Oct 25th: Sharing your FileMaker App with Co-Workers Nov 1st: Basic Concepts for Building Mobile Apps All the best, Richard Carlton CEO & Video Trainer
  4. Hi, I'm trying to achieve something I expected to be straightforward, but after banging my head on a brick wall for 24 hours it's time to aask for help. I have a fairly straightforward company table and a contact table. Related one to many as you'd expect. When browsing a layout based on the companies table, I can see all the related contacts via a portal. I've never really done any reporting, but I wanted to create a report layout that gives me the company details at the top, and lists the contacts underneath. I expected this to be relatively simple, but I can't get it to work. I have the folowing report layout based on the companies table. Parts: Header - cust has freetext field as a title and the date Sub-summary by txt_Surname (Leading) - This contains all the company address details as merge fields Body - contains the contact details as merge fields (name, job title, email, telephone and so on) Footer - page number Now I have tried all manner of different combinations to try and get what I want. Basing it on the contacts table, different sorting and so on. When doing test prints it often shows just one contact under a company when I know there are more, and it some cases it shows too many. This is the first time I've tried reporting of any sort in FileMaker, so I'm really stumped by this so any help you can give me would be appreciated...I do keep thinking about a portal for the contacts, but I can see how this would work if the portal isn't big enough to accomodate a company with a hundred contacts in it, where other companies may only have one contact. Any help you can give me will be greatly appreciated.
  5. Announcement: Cleveland Consulting announces CCPivot2 - Create cross-tab a pivot tables easier than ever! Cross tab and pivot table reports have never been easier or more powerful. We at Cleveland Consulting have worked hard and rebuilt the very successful CCPivot product from the ground up to completely take advantage of everything that FileMaker 12 has to offer. New features include: Clickable data links - See the data behind the report! Dynamic date management - no more need to create fields to order and group date data by month or day. It's all done automatically. Required data sets - sometimes reporting on the data that is missing is more useful than what is there. There is a lot more to see, check out the overview video here: http://vimeo.com/59415236 or head over to the product page here: http://www.clevelandconsulting.com/cc_pivot/ Court Court Bowman, CEO Cleveland Consulting, Inc. Visit us on the web at http://www.clevelandconsulting.com
  6. Hi all! I'm stuck. Really stuck. I can't wrap my head around this problem. So here's the issue: I have 4 tables: Users Projects Earnings Hours A member logs hours worked into a project as line items. Earnings are also logged per project as line items with date and amount. Now I need a report that would show total earnings per user per month. I know I'm missing something but I don't know what. Please help! Thank you! Jure projects-earnings.fmp12
  7. Hello all, thanks for reading. I am using FileMaker 11.0.3, with the Business Productivity Solutions v7 (bps_Sales_Orders.fp7, bps_Inventory.fp7, bps_Contacts.fp7). There is included a report generating "Sales Numbers" which gives the sales value totals in £ per week, month, quarter, or year. However, I want to generate a report showing total inventory items sold. I have an inventory of 170 items and need to generate a report that shows, for example: October 2013: Part Number Item Quantity Sold 1172-2 Rock Teeth 1422 1172 Wood Teeth 342 1101 Tooth Bolts 205 12m Chip Guard 17 44005 Drive Belts 38 etc etc etc.... While the "Sales Numbers" report just takes a single figure from each Sales Order, this "Line Items Totals" report needs to take one or many Line Items from the inventory portal in each Sales Order. My skill with FileMaker is such that I have adapted the bps to more or less suit my needs but not much more than that. By searching for a solution it seems that maybe there is a report wizard to ease the process. It would also be helpful if the same could be done by customer, ie a report showing: Customer X, in Year Y, bought 17 Widgets, 130 Thingummies, 2 Whatsits etc etc. I'm frustrated that this must be a fairly common need yet neither my own efforts nor searching has born fruit. Please help! Many many thanks, and if this would be better in a different topic please advise thank you.
  8. Hi all Users are more frequently than ever requesting that custom reports be made. Up till now this has involved me creating layouts and scripts that can produce the data/reports in the form they want. I'm wondering if now it might be possible to let them take control of reporting in a way that is separate from the current database (which is heavy on GUI and disabling of features for ordinary users). I'm thinking of creating a totally new database which users would be able to completely edit from a design perspective, which would point to the main database as an external data source. However I would like it so that they would NOT be able to edit/create/delete those external records. I've had a play with it and can't seem to get it to work (we're using external authentication via windows server active directory). Is such a thing possible? Many thanks
  • Create New...

Important Information

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