Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Date Range Post Reply Post New Topic
Author Message
Alexander
Newbie
Newbie


Joined: 10 Jan 2012
Online Status: Offline
Posts: 12
Quote Alexander Replybullet Topic: Date Range
    Posted: 11 Jan 2012 at 6:15pm

Hello Everyone,

I have monthwise report when m giving date Range from Oct-2011 to current date so it is taking full month for oct, nov, dec & 10 days for jan as today is 10th of jan. So what i want is it should come 1 to 10th of each month not the full month. Means if Current date is 12th so the figure should come for only 12 days for every month.
 
Can anyone please help on this!
 
Regards
Alex
IP IP Logged
rkrowland
Senior Member
Senior Member
Avatar

Joined: 20 Dec 2011
Location: England
Online Status: Offline
Posts: 259
Quote rkrowland Replybullet Posted: 12 Jan 2012 at 3:59am

Does the date field within the data have daily dates? Or does it just include the month? If it only includes the month the formula will have to calculate the percentage into the current month we are and then apply that percentage to the other months. If it contains daily information we can create a more precise formula that will work on day of previous months.

 
Regards,
Ryan. 


Edited by rkrowland - 12 Jan 2012 at 4:00am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 12 Jan 2012 at 4:02am
table.date in date(2011,10,1) to currentdate
and
day(table.date)<=day(currentdate)
 
 
oops, sorry for the overlap repsonse Ryan. I was typing before I saw your reply.


Edited by DBlank - 12 Jan 2012 at 4:06am
IP IP Logged
Alexander
Newbie
Newbie


Joined: 10 Jan 2012
Online Status: Offline
Posts: 12
Quote Alexander Replybullet Posted: 13 Jan 2012 at 6:28pm

Dar Mr. Ryan,

The data is datewise but i ve createds a crosstab where it is showing monthwise like Jan-11, Feb-11 & Mar-11. Now for eg if todays date is 12 Mar-2011 & i am giving a range from Jan-2011 to till date so the figures are appearing for full month of Jan & Feb & 12 days for the month of mar as the curent date is 12th mar. so for compariosin purpose i want it show figures for 1-12th of every month.
 
Regards
Alex
IP IP Logged
Alexander
Newbie
Newbie


Joined: 10 Jan 2012
Online Status: Offline
Posts: 12
Quote Alexander Replybullet Posted: 13 Jan 2012 at 6:29pm
Dear Sir,
Please reply!
 
Regards
Alex
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.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.