Jump to content

Search the Community

Showing results for tags 'subsummary'.



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

Blogs

There are no results to display.

There are no results to display.

Categories

  • 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

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Title


Industry


Location


Interests


Website URL


Skype


MSN


Yahoo


OS Version

Found 13 results

  1. I'm not well versed in summary layout parts and reports, but am trying to learn. I have a (personal) database to track investments (stocks, mutual funds, bonds, etc.). I have fields such as: number of shares, price, and value (technically: shares * price). Each record has three checkboxes: buy, sell, and current holding (previous (historical) records do not have 'current' checked). After establishing a found set (of a particular investment), I have a script that constrains the found set to buys, sells, and current record(s) (plural, because the same investment could be held in multiple accounts). (All historical records (except buys and sells) are thus not in the found set.) I have a script, triggered on layout enter, that sorts by buy, sell, and current. (Buys and sells are executed trades.) I have a sub summary part, and in it, a summary field based on value. The layout displays the records sorted as I want, and the summary field displays the correct total for each of the three groupings of records. What I want is to get the value of each of those summary fields, so that I can do a calculation: (Sells + current holding) - buys = profit / loss. Of course using the single summary field doesn't work. I could run a script to find the buy records, set a variable based on the summary field value, find the sell records, set a variable on the summary field, and so on. Then have fields with those variables (plus a calculation field) in the trailing grand summary. I could also create separate fields for buy (shares, price, and value), sell, and current, but I'd prefer not to. I thought I'd ask, because I might be missing a simpler method. thanks
  2. This is my first time posting, and I apologize if this is the wrong place. I've only been filemakering for a few months, so again, apologies if this is a stupid problem. I could use some advice. I'm working on a solution that must create monthly reports in the following form: http://i.imgur.com/Cf4Fjic.png I've given up trying to bend the summary fields to my will, and began using the following approach: Make two new tables - Queries and Reports. In queries table, I have fields for M1, M2, M3, Region, Category, Subcategory and four result fields (M1, M2, M3 and YTD.) I also have foreign key into the reports table. Then in reports table, I portal into the Queries table. When report is run, a bunch of queries in queries table are created. The Results are populated via ExecuteSQL expressions. My question is mainly this: Is this too backwards? I feel like maybe this is too weird of an approach and I"m just missing something simple about reporting and creating summaries? Thanks!
  3. Hello All! I am having trouble building a complex subsummary report efficiently for a real estate database. The report layout is simple: I basically have a layout with 18 columns, all years, 2000-2017. The layout only has subsummary parts, no body parts. The subsummary part I am using to display data is sorted by a field called Micromarket (basically a geographical area). I want to display the number of units built in each year for each Micromarket. I have the report working perfectly, but I had to add many fields to my property table to accomplish this. The fields are as follows: Field Name: Number_of_Units_2000: Calculation: If ( (Year_Built)=2000;Number_of_Units ) and a corresponding Summary field that is the "Total Of" Number_of_Units_2000. I have done this for each year on the report, so I have made 18 Calculation fields, and 18 corresponding Summary fields. I then put each Summary field in its corresponding column on the layout, and for each Micromarket, I am able to display the number of units added in a given year. Is there a more efficient way to do this? I have tried performing a different find for each year within a script, then populating a Merge Variable with the result, but the Merge Variable doesn't behave the same way on the layout as a Summary field does. Any help would be appreciated!
  4. How can I extract content from sub summary layout objects using? https://fmhelp.filemaker.com/help/16/fmp/en/index.html#page/FMP_Help/getlayoutobjectattribute.html I'm able to grab the content from the first subsummary, not the remaining however. The following: set field( output; GetLayoutObjectAttribute( 'header', 'content' ) & GetLayoutObjectAttribute( 'row', 'content' ) & GetLayoutObjectAttribute( 'footer', 'content' ) ) works fine, the bad thing is that only row 1 finds its way to the output-field.
  5. I have a sub-summary part that provides summary data about my database according to record type. On the main database overview page, I created a portal with a self-join relationship (displays records from the same table as the layout it appears on) with relevant fields inside. Everything looks great, but the portal records are not also segregated by record type between the sub-summary reports. I have the records sorted by record type within the portal, but that just groups them. Right now, the portal looks identical in each sub-summary report. Is it possible to filter records so they only appear in the sub-summary part designated for their case type?
  6. 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
  7. I've got a Subsummary layout. The layout is based upon the table, lets call it "Materials". The subsummary part is sorted-by the field "Type". Type can have say, one of three possible values in it: Glass, Paper, Plastic. When we sort this layout, we get subsummaries by the types, Glass, Paper, and Plastic, as expected. There's a script that performs some Finds, based on user-entered criteria, to narrow down that list. What I need to do now is have a script gather the IDs of only the records under, say, Paper. And only Paper. Suppose three records are showing under Paper, I want those three records' IDs in some form or another. So far I've only been able to have it gather ALL of the IDs in the whole table (wrong), or, only gather the first ID under the subsummary part (also wrong). My third method works and returns the desired results, but feels "dirty", so i hope to hear about a better way. That is, I perform a Find based on the last known Find criteria, adding in to that mix, the ID of the subsummary part they chose (=Paper), to actually go find and truly isolate those three records in question, then I can gather their IDs. But that throws off my Found Set, is slow, and requires more work afterwards to restore the layout to how it was before. Not a great solution either. Any input would be appreciated. Thanks!
  8. I am using FM 11 Adv with OSX Lion It's been a few months since I sat down to tweak my solution and I think I have forgotten something pretty basic... (Yes, I have consulted this forum and several books; to no avail) I have a membership application. There are 2 tables: Members & Dues Members: PK_MemberID MemberLastName Dues Status (Late or Current) Dues: FK_MemberID DonationAmt SummaryDonationAmt (Summary of DonationAmt) I have created a report with a subsummary which 'breaks' on STATUS. I have sorted on STATUS. It works. But, if I bring the SummaryDonationAmt field into the Summary 'band' it seems to just include the record immediately below the 'band' .... and sometimes *not*. What am I missing? Thanks
  9. Hey Guys, Just a quick one, I have a large report that groups products together via Style, and has totals at the bottom in the green section (I realise they arent totalling but thats not my issue) My issue is, that when I export as a spreadsheet, my products stay grouped by Style, but I cannot for the life of me get the totals to stay underneath the columns of each group! Any help or advice would be appreciated, I just want it so that its in the format below with the group of products, then the totals beneath.
  10. I have a customer database and with a customer table and a service call table. I am looking to create a report that would summarize total payment received in each month and a total for any given year with a grand total of every year. Not sure how to set up the layout part for the Year and Month so that they will produce the desired result. Thank you for any assistance. Greg
  11. Hi I am having trouble making a report for my file. In a nutshell I have These Tables "Written Sales", "Sales People" , "Salesperson hours", and "Sales Person Goals". I am pretty happy with my yearly report / comparison, but now I want to show the same data by salesperson then by month. I tried using sub summaries but have not been able to get all the data needed for the report this way, namley my hourly productivity and goals. I have attached a copy of the file I am working on for your viewing pleasure.  The file is pretty basic, and I am a novice so please be easy on the crtiticisim, but any and all comments are appreciated!!! I am sure I am just not seeing the easy answer here.   Here is what I want to accomplish with the current file.   Writtensales copy.fmp12.zip
  12. Hello! I have a report setup with a sub summary sort, and it works great. When I go to print the report, I would like the sub summary row to print at the top of each page - is this doable? I already have it set to do a page break after each section, but if the pages get mixed up, there would be no way to tell what sub section they belong to. Any and all help is appreciated. Thanks! Using Filemaker Pro 15 Advanced on a Mac
  13. Sorting by a subsummary I'd like to add some info from various records but only works for the info from the first record. I've tried many different ways but none works. I attach a sample file and a picture (fake of course ) of what I'm trying to accomplish. Advices are wellcome . Thank you. Sample.zip
×
×
  • Create New...

Important Information

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