Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Weekly Values Post Reply Post New Topic
Author Message
Kitty1
Senior Member
Senior Member
Avatar

Joined: 14 Apr 2010
Online Status: Offline
Posts: 159
Quote Kitty1 Replybullet Topic: Weekly Values
    Posted: 08 Dec 2015 at 5:01am
Hi,

I am looking to write a report to give weekly totals of number of quotes and dollar amounts.

I want to pull in data between 2 parameter dates. or at least between one parameter date and today's date.

So, if someone entered beginning date of 11/1/2015 it would return values of
11/1/2015 - 11/7/2015 totals
11/8/2015 - 11/14/2015 totals
etc.

so that if they ran it to date, using the same starting date, the report would keep getting larger as each week went by.

Is this something that is even possible? I am pretty much a novice with Crystal so any help i could get would be greatly appreciated! Thanks!
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 08 Dec 2015 at 9:48am
As long as you sent your date filters correctly, yes the report would continue to grow as more data is available.  So I would assume in the select expert formula.  It would look something like this.

{Date field} >= {?Date Parameter}
and {Date field} <= currentdate()
IP IP Logged
Kitty1
Senior Member
Senior Member
Avatar

Joined: 14 Apr 2010
Online Status: Offline
Posts: 159
Quote Kitty1 Replybullet Posted: 11 Dec 2015 at 4:36am
Hi,

thank you for the response. I've been tied up with other things so just getting back to this. Is there a way to show week totals for each 7 day time period without using parameter data for each week?     by just using a beginning date? say if someone used a beginning date of 7/5/2015

i would want to show on separate lines, activity between 7/5 and 7/11,
then activity between 7/12 and 7/18, etc. right up until either today's date (or another parameter set as an ending date)

Is there a way to add to the starting date+6 days, and then that date+6 days etc...if that makes any sense ?

thanks!
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 14 Dec 2015 at 5:03am
I think (if I understand correctly) the answer should be yes.  One trick you can use is group by the date (you have options on how long the time period is for the the group). 

You can do a lot of math on date fields (as simple as just adding or subtracting a number).  There is the dateadd function.  There are a number of options you can do with the dateadd function. 
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.014 seconds.