Print Page | Close Window

How to get all days in month(from 1 to 31) default

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15917
Printed Date: 29 Apr 2024 at 11:35am


Topic: How to get all days in month(from 1 to 31) default
Posted By: vgutta
Subject: How to get all days in month(from 1 to 31) default
Date Posted: 19 Mar 2012 at 6:26am
How to get all days in month(from 1 to 31) by default as first column
The output is as follows....Any suggestions

I need to get the days even if there is no data
Days of month     Jan Feb Mar .........................Dec
1
2
3
4
....

31
 
Thanks in advance


Replies:
Posted By: kostya1122
Date Posted: 19 Mar 2012 at 8:18am
i can only think of a manual way which could be a lot of work and not a good solution, but here it is any way
group on month formula
totext(month(table.date),0,"")
expend your group header
create 31 text boxes place them into your group header
then create 31 formulas something like
if table.date in date("01"+","+{@month}+","+"2011") to date("02"+","+{@month}+","+"2011") then table.value
place then place them next to the right text box
then right click on text boxes 29-31 (separately)go
format text > common tab >click x-2 next to suppress and write according to your calendar like
 {@month} = "2"


Print Page | Close Window