Calendar Style Report (Monthly View)

[Former Member]

Hi Gurus,

I have requirement to create a monthly view calendar style report in Crystal XI. The view is below.

Su Mo Tu We Th Fr Sa 
       1  2  3  4  5 
 6  7  8  9 10 11 12 
13 14 15 16 17 18 19 
20 21 22 23 24 25 26 
27 28 29 30 31

The above is the view of my monthly calendar. I wanted to create like that shown above. Is anybody come across such a situation in creating the Monthly view calendar.

I wanted to display activities on particular day where ever applicable. It just like Outlook Calendar Monthly view.

Please give some inputs.

Any input is greatly appreciated.

Ashwan.

[former_member260594 · Accepted solution]

Ashok,

I have a sample that someone else wrote so I can't tell you how it works too well but I will email it to you.

[Former Member · Accepted solution]

Hi Graham,

Is there a way to create a calendar view report with out using the sub report. Since I am already using a sub report under main report.

The report you provided its already using sub report. According to my requirement I have do everything under sub report.

Please provide some inputs.

Greatly apprecited your help.....

Thanks a lot.

Ashok

[amrsalem1983 · Accepted solution]

did you think if you use matrix reports?

i think it may works well with your case

[Former Member · Accepted solution]

Graham

I am very interested in doing a monthly calendar format report - Would appreciate your sample report and any help you can offer Randy Royer randy at pay-waredotcom

[Former Member · Accepted solution]

I just sent you an example. Mine asks you for a start date.

I have formatted as multiple running totals. Some of the formulas are

Start of month

date(year({Orders.Start Time}),month({Orders.Start Time}),1);

-

---

End of Month

local numbervar m:=month({Orders.Start Time}) + 1;

local numbervar y:=year({Orders.Start Time});

if m> 12 then (m:=m-12; y:= y + 1);

Date(y,m,1) - 1

-

---

Sunday

{@Start of Month} - DayofWeek({@Start of Month}) + 1

-

---

Monday

{@Sunday} + 1

-

---

Tuesday

{@Monday} + 1 (etc...)

My first running total (Sunday)

calculates on

{Orders.Start Time}={@Sunday}

Second Sunday is

{Orders.Start Time}={@Sunday} + 7

Third Sunday

{Orders.Start Time}={@Sunday}+ 14

Display String for first Sunday

totext({@Sunday},"dd-MMM-yyyy")

Tool tip text for first Sunday

totext(CurrentFieldValue,0)

FontColor for First Sunday

if {@Sunday} < {@Start of Month} then silver else black

Display String for First Thursday

ToText({@Thursday},"dd-MMM-yyyy")

Tool tip text for First Thursday

ToText({#Thu 1},0)

Running total field names are

Mon 1

Tue 1

Wed 1 (ETC)

Mon 2

Tue 2

Wed 2 (ETC)

Any way, this works just fine, I am sure there are smarter ways to do this, but this works.....

FontColor for First Sunday

if {@Thursday}< {@Start of Month} then silver else black

[Former Member · Accepted solution]

Randy, I got a rejection on your email address.

randy at pay-waredot.com

[Former Member · Accepted solution]

Also, look at the current newsletter out on

http://www.chelseatech.co.nz/pubs.htm

Crystal Clear 68 Apr-Jun 2009

a couple of calendar examples in this newsletter.

[Former Member]

Hi Ashok ,

I haven't explored this, but in Crystal we can insert an Ole object. Is it possible that

you could insert, say, an excel sheet, and display the monthly info on that ?

The Panda