Crystal Reports - Date

I am working with a report in Crystal Reports and I need to add a "Date" Field. What I basically need is a field/group for every day of the year so that I can group and sort data based on that. Ideas?
cozmo_trollAsked:
Who is Participating?
 
LinInDenverConnect With a Mentor Commented:
I have accomplished this in the past by using a table/view in the database that contains all possible dates already, and then using it as the left most outer table, joining on date to your transaction table.
0
 
mlmccCommented:
I believe what you are asking is how to show dates that are not in the database.

For instance if you have a sales database like

DateSold       Product
1-Jan-2013     P1
5 -Jan-2013    P2

You want to see groups for 2, 3, and 4 Jan 2013

Two basic ways.  See this question for the basic idea.  This one uses hours but days is similar
http://www.experts-exchange.com/Database/Reporting_/Crystal_Reports/Q_28129183.html

I seem to be restricted form uploading files from this computer.  If you need help modifying the report file, I will make the mods tonight and upload it.

mlmcc
0
 
cozmo_trollAuthor Commented:
Yes, I would want the days of January 2, 3, 4 to pull on the report even though there are not any sales those days.

I looked at the other string but do not understand. I'm dealing with 365 days so adding 365 files doesn't seem like a good option.
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
mlmccConnect With a Mentor Commented:
Look at this report.  I believe it does what you want.

mlmcc
IncludeMissingDayGroup.rpt
Missingdays.xls
0
 
cozmo_trollAuthor Commented:
I need to have it in Excel or Crystal
0
 
LinInDenverCommented:
That's fine, it doesn't have to be in a database, you can still apply the same logic, and just connect to an Excel file. Just make sure the RPT file can always find your .XLS file.
0
 
mlmccCommented:
Did you look at the report I provided?

I believe it does what you want entirely in Crystal.

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.