Print Page | Close Window

Seperating Data points into Daily from Weekly

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20887
Printed Date: 20 May 2024 at 6:44am


Topic: Seperating Data points into Daily from Weekly
Posted By: Zlawless
Subject: Seperating Data points into Daily from Weekly
Date Posted: 15 Jul 2014 at 10:09am
Hi,

So I am working with a fairly large database and I am currently getting my data bundled into weekly data points and I want to be able to look at a graph with 30 data points, one for each day of the month.

I understand that I will have to create a new formula field however I do not know exactly where and how to write the small amount of code needed to make this happen.

So, regardless of my variables, what is the general recipe for going about something like this?

Thanks,


Zach


Replies:
Posted By: DBlank
Date Posted: 15 Jul 2014 at 10:37am
if it is a dateor datetime field you can group on it (also in graphs) by various datetime values.
in the group set up select the 'for each day option'

Posted By: Zlawless
Date Posted: 15 Jul 2014 at 10:55am
I only know how to access group settings via Insert->Group and under report as well. What are you referring to exactly?

Posted By: DBlank
Date Posted: 15 Jul 2014 at 11:32am
open the group expert
select the goup in the list
select options
on the common tab the bottom option is for the increment selection

Posted By: Zlawless
Date Posted: 16 Jul 2014 at 7:13am
Worked like a charm thanks so much!


Print Page | Close Window