Solved

Crystal Reports - Date

Posted on 2013-05-23
9
452 Views
Last Modified: 2013-09-02
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?
0
Comment
Question by:cozmo_troll
  • 3
  • 2
  • 2
9 Comments
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
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
 

Author Comment

by:cozmo_troll
Comment Utility
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
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 250 total points
Comment Utility
Look at this report.  I believe it does what you want.

mlmcc
IncludeMissingDayGroup.rpt
Missingdays.xls
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 14

Accepted Solution

by:
LinInDenver earned 250 total points
Comment Utility
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
 

Author Comment

by:cozmo_troll
Comment Utility
I need to have it in Excel or Crystal
0
 
LVL 14

Expert Comment

by:LinInDenver
Comment Utility
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
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Did you look at the report I provided?

I believe it does what you want entirely in Crystal.

mlmcc
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now