May 1, 200916 yr Hello I am trying to create a table in Filemaker. To wrap my head around the structure, I set it up in Excel. But I'm not experienced enough with Filemaker to understand how to create the layout, or if it's possible. I know it's the Columnar Report Layout, but I'm all tangled with the sub-totals and what not.... I've attached my Excel file, the cvs data as well as the Filemaker table... Can you look at it and sort me out? Please excuse me if this is too much to ask for. I have a feeling though, that it will be ridiculously simple for any of you pros, and, once I see what you've done, it will all make more sense to me. Thank you- Marion Income_and_expenses.zip
May 1, 200916 yr Author That's a good start for me, I think.... the thing is that I need to see [color:red]all the sub-totals that I've indicated on the xls file, via one report Anyone up for that level of sub-totaling? EDIT: ACTUALLY - THANK YOU! IT WAS ENOUGH TO GET ME STARTED, and now I understand how it works! In other words, thanks for teaching me to fish, rather than giving me the fish. Thank you! I'll be back if I have more questions! Edited May 1, 200916 yr by Guest
May 2, 200916 yr Author Ok. So I took what you showed me and have it working to a certain level that's real good (file attached) However, I need to add 2 more pieces of info to this report, and I don't know how or if it's possible. I have a field (not currently shown in the report) which indicates whether the expense is for Producer or Presenter. I need the total for each to show, somewhere at the end. Anyone up to take a stab at it? I basically need, at the bottom, to see: Producer share: $241,451 Presenter share: $193,055 Thanks - Marion EDIT: I decided what I wanted wasn't possible, because I was asking for 2 different sorts, in the same report. But I really appreciate the work you did - because I was struggling to get a handle on Part Layouts etc, and now I feel much more in control of the situation. income_and_expenses_2.zip Edited May 3, 200916 yr by Guest self-education
May 3, 200916 yr Author Now that I have a handle on seeing a report showing the detail and sub-totals, how do I go about creating a report that only shows the sub-totals??? Do I put the sub-total fields into the body section of the report? Or do I make a body section that is super-skinny, with nothing in it? Or is there another setting I need to toggle on? Thank you - Marion
May 3, 200916 yr Leave the body out of the layout, i.e., delete it. Show sub-summaries & summaries plus header & footer.
Create an account or sign in to comment