Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Seperating Data points into Daily from Weekly Post Reply Post New Topic
Author Message
Zlawless
Newbie
Newbie


Joined: 15 Jul 2014
Online Status: Offline
Posts: 3
Quote Zlawless Replybullet Topic: Seperating Data points into Daily from Weekly
    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
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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'
IP IP Logged
Zlawless
Newbie
Newbie


Joined: 15 Jul 2014
Online Status: Offline
Posts: 3
Quote Zlawless Replybullet 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?

Edited by Zlawless - 15 Jul 2014 at 10:58am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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


Edited by DBlank - 15 Jul 2014 at 11:33am
IP IP Logged
Zlawless
Newbie
Newbie


Joined: 15 Jul 2014
Online Status: Offline
Posts: 3
Quote Zlawless Replybullet Posted: 16 Jul 2014 at 7:13am
Worked like a charm thanks so much!
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.