Jump to content

Monthly, Quarterly Reports


JustJoker
 Share

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

Recommended Posts

Hello!

I'm trying to figure out how to make a report with option to group data and totals by months and quarters of a year. Knowing how to find a range of dates with globals, I just don't understand how to find several ranges and group data in a readable report.

Does somebody have any clues?

Sorry for this may be silly question. :unsure:

Thank you in advance,

Serge

Link to comment
Share on other sites

Records are grouped by a common value in the breakfield. To group by month, you need a calculation field that will return the same value for all records in the same month, e.g. =

TransactionDate - Day ( TransactionDate ) + 1

Use this field for sorting and for the sub-summary part.

Not sure what you mean by "find several ranges".

Link to comment
Share on other sites

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