Solved

Crystal Reports - display sum of date and year

Posted on 2009-04-09
6
328 Views
Last Modified: 2012-05-06
I have been following the guide at www.ml-consult.co.uk/cryst-06.htm to create a calendar style report.

I would like to tweak it slightly, the date is displayed by summing a formula, the formula is

if DayOfWeek ({xl.date}) = 1 then Day({xl.date})

which has the effect of displaying the correct date.

What I would like it to also display is the year so that instead of just saying 01, it says 01 January.

The date field that it calls from contains the month.

Thanks Ed.
0
Comment
Question by:edmacey
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 10

Expert Comment

by:Spykair
ID: 24106018
Change it to this:
if DayOfWeek ({xl.date}) = 1 then Date({xl.date})

Then format your field to only display it as 1-Month

Spykair
0
 

Author Comment

by:edmacey
ID: 24106166
It doesn't like that, I have changed first dayofweek to be monday. how do i change the sum by adding 1-month in there?
0
 
LVL 10

Accepted Solution

by:
Spykair earned 500 total points
ID: 24106240
Your formula will be:
if DayOfWeek ({xl.date}) = 1 then Date({xl.date})

Then place the formula field in the report.
Right click on the formula field -> format field -> select the date mask that will show "1-Mar' or something like that.

Spykair
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:edmacey
ID: 24106916
Okay thanks, I can get that to work if I were using those fields in the report however I am taking summaries of them which are numbers and can't be represented as dates.
0
 

Author Comment

by:edmacey
ID: 24107044
Actually I  can now get that to work fully, except it doesn't seem to accept my CrMonday criteria to make Monday the first day of the week.

if DayOfWeek({caldates.Date},CrMonday) = 1 then Date({caldates.Date})
0
 

Author Closing Comment

by:edmacey
ID: 31568439
User error with the previous ones, it was my own fault it wasn't working, got it working now. thanks ed.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
In this post we will learn different types of Android Layout and some basics of an Android App.
Simple Linear Regression
Six Sigma Control Plans

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question