Question Re: Dispalying calender in Crystal reporst footer in Technology Q&A

Dispalying calender in Crystal reporst footer

Former Member — Fri, 24 Dec 2010 10:49:45 GMT

Hi,

I have a requirement to display calenders of 6 months in report footer in a crystal report 2008. If i refresh a report on 12/01/2010, then current month and next six months calenders (jan -2011, feb-2011,mar-2011, apr-2011,may-2011,june-2011)should be displayed.

Please let me know how this can be implemented.

Thanks,

Suma

Re: Dispalying calender in Crystal reporst footer

JWiseman — Fri, 24 Dec 2010 17:56:28 GMT

hi Suma,

please go to my blog [here|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/u/251949134] [original link is broken] [original link is broken];.

scroll to the bottom and there is a blog for calendar style sample reports. download the CalendarYearlyView report.

on this report there is a Calendar formula. copy this formula to your report. change the DateField formula that is in this formula to whatever your datefield is.

jamie

Re: Dispalying calender in Crystal reporst footer

Former Member — Wed, 29 Dec 2010 13:57:45 GMT

Thanks Jamie. Your inputs were very useful.

We took the calender and datetime formula from the report u gave and placed them in our report. for datetime formula , we have given currentdatetime value. It is not getting value from any field in the database table

But it is dispalying calenders of only month three times in a row but it is not displaying calenders of all the months.

we also placed counter in report footer and counter reset in report header formulas in our report. But it didn't work.

Also i want them to be displayed horizontally in report footer.

Please let us know if we are missing anything.

Thanks,

Suma

Edited by: Satya Suma on Dec 29, 2010 3:08 PM

Edited by: Satya Suma on Dec 29, 2010 3:11 PM

Re: Dispalying calender in Crystal reporst footer

JWiseman — Tue, 04 Jan 2011 16:24:49 GMT

hi Suma,

here are some notes below to get this to work. you don't need to have any kind of suppression formula on your report as it was designed to be switched easily.

1) the report already is grouped on Year and then Month. each Year starts on a new page.

2) for the DateTimeField that you use in your calendar formula, ensure that it is a datetime field from your database and not CurrentDateTime.

3) ensure that you change the Record Selection formula in the report to what you want.

4) in order for the report to populate each month, you will have to base the calendar on a datetime field where each there is a value in your database for each month. Group 2 on the report is based on the month of that datetime field...if there is missing data in your database, your report will be missing months.

jamie

Re: Dispalying calender in Crystal reporst footer

Former Member — Wed, 05 Jan 2011 07:21:55 GMT

Thanks Jamie. It worked.

Re: Dispalying calender in Crystal reporst footer

Former Member — Wed, 19 Jan 2011 11:54:05 GMT

Hi Jamie,

Is there any way to display this calender in tabular format?

Thanks,

Suma

Re: Dispalying calender in Crystal reporst footer

JWiseman — Thu, 20 Jan 2011 15:56:06 GMT

hi Suma,

can you describe in detail what you mean by displaying the calendars in tabular format?

thanks,

jamie

Re: Dispalying calender in Crystal reporst footer

Former Member — Fri, 21 Jan 2011 03:57:21 GMT

Hi Jamie,

The calender should be displayed in a table with each date in on cell and 5 dates in a row.

I am unable paste the image over here. I hope you could understand now.

Thanks,

Suma

Re: Dispalying calender in Crystal reporst footer

JWiseman — Fri, 21 Jan 2011 08:19:17 GMT

if you are trying to put each calendar month into a cross-tab / table then that will not work. the cross-tab does not support rtf encoding.

you can make the sample report into a column report by makeing the height of the Details C section greater. also change the width of the page in the printer settings.

Re: Dispalying calender in Crystal reporst footer

Former Member — Fri, 21 Jan 2011 11:35:26 GMT

Thanks Jamie.