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

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.

IP IP Logged
Admin Group
Admin Group

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

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...):

----------     -----------
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.

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