Jump to content

Basic Report Question - Newbie


John Kostenbader

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

Recommended Posts

I find that reports are one of the  most challanging things in Filemaker to understand (at least for me). I have basic projects table and all I want to do is print out the list of projects but grouped by the account they are associated with. I.E.

ABC Company
      Project 1
      Project 2
     Project 3

Ideally, I'd like a sum of the project value field. I'm confused about the report "parts". I've gone through the wizard like creation process and cannot get them "grouped" by Account name. Now Project Name is in a related table. The only thing in the projects table is the ID_Account. Can someone guide me what fields are supposed to be in what "parts" of the report. I would presume that "project value" should be in the subsummary part. Fields for the project details like status and category would be in the "body" part and the Account Name would be in the header but its not working for me. All I get is a list of projects (not grouped properly). 

Any insight or direction would be appreciated

John

Link to comment
Share on other sites

Ok, then this should be quite simple. Your layout (based on the Projects table) needs to have these parts:

parts.png.a97e4106b4abe6425b2a40a8400358

 

  • The Header and Footer parts are optional and need not contain any fields;
  • Place the Project Name and Project Value fields in the Body part;
  • Place the Account Name field (and any other fields from the Accounts table you want), along with a summary field (defined in the Projects table) that totals the project value field in the Sub-summary part.

Now you just need to go to this layout, find the projects you want to include in your report and sort them by Accounts::Account Name and (optionally) by Projects::Project Name (all this can and should be scripted).

 

 

Link to comment
Share on other sites

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