Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2016 : Technical Questions  
Message Icon Topic: calendar activity report Post Reply Post New Topic
Author Message
taniarto
Groupie
Groupie
Avatar

Joined: 15 Oct 2010
Online Status: Offline
Posts: 45
Quote taniarto Replybullet Topic: calendar activity report
    Posted: Yesterday at 4:48pm
how does import calendar into a report? does any one know? I need to create report which is contain of date of a month so all the the date of the month should be displayed.

thx
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3527
Quote hilfy Replybullet Posted: Today at 3:48am
There are a couple of ways to do this:

1. Create an Excel spreadsheet that contains all of the dates and use it in the report.

2. Create a calendar table in your database and use that in the report. The structure that I usually use for this table is the following:

Field Name     Data Type
----------     ---------
DATE_VALUE     Date or DateTime
DATE_MONTH     Number
DATE_YEAR      Number
DATE_QUARTER   Number
DATE_WEEKDAY   Number
IS_HOLIDAY     Bit
BUSINESS_DAY_SEQ     Number

The BUSINESS_DAY_SEQ field uses the following logic:
increment by 1 for each business day. Each non-business day has the same value as the most recent business day. An example of this is (using a US calendar...):

DATE_VALUE     BUS_DAY_SEQ
----------     -----------
1/12/2017          100
1/13/2017          101
1/14/2017          101
1/15/2017          101
1/16/2017          101
1/17/2017          102
1/18/2017          102

By including the additional fields, you can do a lot of different types of filters and it makes it very easy to calculate the number of business days between two dates.

-Dell
DecisionFirst Technologies - a Proviti Enterprise
9-Time SAP BusinessObjects Partner of the Year.
www.decisionfirst.com
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.