Solved

Group by Number of Days

Posted on 2014-01-07
2
330 Views
Last Modified: 2014-01-07
Hi Experts!

I have a very simple crosstab report that requires grouping by days.  The days are in the row field.  They go from 1-500 usually...can vary.  I want to group them every 15 records.  Days 1-15 would be in a group.  16-30 would be in a group etc.  Seems like it should be easy but I am banging my head against the wall.  

Any help would be greatly appreciated as always!

spudmcc
0
Comment
Question by:spudmcc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 500 total points
ID: 39762106
Try this

Create a formula
 
    ({YourField} - 1) \ 15

Create a group on the formula

mlmcc
0
 

Author Closing Comment

by:spudmcc
ID: 39762138
Fantastic!  Thank you so much for the quick turnaround!  Appreciate it as always.  

Spudmcc (Andy)
0

Featured Post

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question