This is a migrated thread and some comments may be shown as answers.

Calendar Month Report

13 Answers 612 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

13 Answers, 1 is accepted

answered on 07 Dec 2012, 06:27 AM

2012-12-06-1321.png

Thanks for your reply.

I just want to do something like the attached image, I need a Row with all days in every month and a column with the months in each year...

I am using the crosstab component

Thank you,
Manar

answered on 11 Dec 2012, 09:48 AM

Hi Manar,

Have you tried the crosstab item?

You can add a row group with month grouping and column group day with grouping by day.

Another option is to add a report group with month grouping and add the table to the group header/footer section then you can bind the Table.DataSource property with binding as shown in the following example:

Property	Expression
DataSource	=ReportItem.DataObject

You may find useful the Understanding table cells, rows and columns help article.

Greetings,
Peter
the Telerik team

HAPPY WITH TELERIK REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!

answered on 11 Dec 2012, 07:22 PM

Hi,

Thanks for your reply.

I'm using the "Crosstab" and I have parent row group by Year, then child row group by Month, and column group by day...
this is fine, but I still have 2 requirements:

1-if the data itself doesn't have all the days in month or all the months in year, it will not show up...
if there is no data with day 3 and 4, or there is no data with month Feb or May. so I just get

1| 2| 5|

Jan
March
April
June

so there is missing days or months if the data doesn't contain it, I need to show all the days and all the months regardless of my data

2- I also need the days row to be repeated in each month, how could I do that?

I need your help ASAP please.

Thanks for your effort
Manar

answered on 14 Dec 2012, 03:06 PM

Hello Manar,

Generally the crosstab is data driven report item. Thus in order to have all of the month dates our suggestion is to set up a data layer that will prepare your data accordingly. Check out the Creating a Calendar Report with Telerik Reporting blog and especially how we have prepared the calendar data.

About repeating the dates for each month our suggestion is to follow the second option from my previous reply:

Another option is to add a report group with month grouping and add the table/crosstab to the group header/footer section then you can bind the Table.DataSource property with binding as shown in the following example:

Property	Expression
DataSource	=ReportItem.DataObject

Check out the Product Catalog demo that uses the same data binding approach.

All the best,
Peter
the Telerik team

HAPPY WITH REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!