Jump to content

Can't get reports to group


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

Recommended Posts

  • Newbies

I have a report that I inherited to group employee birthdays by month. The subsummary section of the report uses the birth month (calculated from the date of birth) as the "sort by" criterion. The name of the month is supposed to be displayed, followed by the list of people with birthdays in that month and the actual date to be celebrated.

Problem is that the subsummary never shows up. Nor does the report make any attempt to order by birthday. I have to sort the list by birth month in order to get it to sort, but the headings never show.

I don't know what I'm missing.

Link to comment
Share on other sites

A couple of things come to mind:

Make sure the subsummary and sort are based upon the same field. If one is by month name and the other by month (number) it won't work. You must sort the records, the report format doesn't automatically do this for you. Also, the report will only display correctly in Preview mode, not in Browse. -bd

Link to comment
Share on other sites

  • Newbies

Your comment about the sort checks out with what I thought needed to be done. I also checked out the report in preview mode, and the headings were there as you said they would.

Is it possible to group by more than one subsummary? What folks really want is sorting by office, then by department, then by month. So far, I haven't seen a way to do this.

Link to comment
Share on other sites

quote:

Originally posted by kwstx:

Is it possible to group by more than one subsummary? What folks really want is sorting by office, then by department, then by month. So far, I haven't seen a way to do this.

Of course you can do this! You simply setup sub-summary parts by Office, then Dept, then Month, etc. Then make sure to sort by that same pattern and all of your totals will group correctly.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

Link to comment
Share on other sites

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