Dispalying calender in Crystal reporst footer

[Former Member]

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

[JWiseman · Accepted solution]

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

[Former Member · Accepted solution]

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

[JWiseman · Accepted solution]

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

[Former Member · Accepted solution]

Thanks Jamie. It worked.

[Former Member · Accepted solution]

Hi Jamie,

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

Thanks,

Suma

[JWiseman · Accepted solution]

hi Suma,

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

thanks,

jamie

[Former Member · Accepted solution]

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

[JWiseman · Accepted solution]

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.

[Former Member · Accepted solution]

Thanks Jamie.