Print Page | Close Window

Date Range

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=15350
Printed Date: 07 May 2024 at 4:36pm


Topic: Date Range
Posted By: Alexander
Subject: Date Range
Date 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


Replies:
Posted By: rkrowland
Date 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. 

Posted By: DBlank
Date 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.

Posted By: Alexander
Date 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

Posted By: Alexander
Date Posted: 13 Jan 2012 at 6:29pm
Dear Sir,
Please reply!
 
Regards
Alex


Print Page | Close Window