Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Grouping by the month

Grouping by the month

Grouping by the month

Hi, I use Reportsmith to bring out information about Planning applications.  The date we receive the application is being displayed and I want to group the applications by the month that it was received, therefore knowing the total number per month (and then probably display it in a crosstab)

Can this be done and how?

Thanks for any help,

RE: Grouping by the month

If you use a Crosstab grouping by month is an option.

Take a look at: http://charlescook.com/PPS/ADP/ReportSmith/Enterprise/Everything-You-Wanted-To-Know-About-Crosstabs.pps

Using Report Grouping it is also an option, just harder to find.  If you click on the application received column and then the report grouping button.  ReportSmith will group the data by date.  You would then go to Tools | Report Grouping and select the group in the right hand part of the window.  You can then change the grouping to monthy.

Specializing in ReportSmith Training and Consulting

RE: Grouping by the month

Hi Charles,

Thanks for your reply, after re-reading my post I don't think I explained completely in my original posting.  The date is formatted dd/mm/yyyy, so I found out how to just display it as mm, using field format, but when I then group by that field it still takes it as being the dd/mm/yyyy format.

I was wondering if I can use a derived field to output a new field showing the month only, and group it by that (and display it in the crosstab).

Thanks for your help, its much appreciated.


RE: Grouping by the month

A Date is a Date not mater how you have it formatted.  Converting it is not nessary.  Just tell the crosstab options how you want it grouped.

Specializing in ReportSmith Training and Consulting

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close