Jump to content

Summary Report


Scott Rusoff
 Share

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

Recommended Posts

Hello,

I am trying to produce a time sheet report, and I want it to look like this.

Client Name Sunday Monday Tuesday Wednesday Thursday

4/11 4/12 4/13 4/14 4/15

ABC Company 0 2 6 8 8

XYZ 0 6 2 0 0

Totals 0 8 8 8 8

It seems I can not get the report to sort correctly.

The name of the layout is timesheet.

Any help would be appreciated.

Thanks,

Scott

FileMaker Version: 6

Platform: Mac OS 9

Link to comment
Share on other sites

There was only one file in your attachment, so I couldn't test it with your cClientNameLookup field. I just converted it to a text field to test with.

Two things: you don't need to use getSummary() if you are sub-summarizing the layout parts. Just use the Total summary fields instead. Second, there is a sliver of a body part on the layout that doesn't need to be there.

Didn't see any other problems.

Link to comment
Share on other sites

The file that is missing is the Client Profile, but I'll send you what I have (all I did is change the cClientNameLookup to a text field so I could sort by it.)

FileMaker Version: Dev 6

Platform: Mac OS X Panther

Link to comment
Share on other sites

This topic is 6492 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
 Share

×
×
  • Create New...

Important Information

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