Solved

Group by Number of Days

Posted on 2014-01-07
2
316 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
2 Comments
 
LVL 100

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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 …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…

919 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now