List horizontally months

[Pedro Henrique]

Hello

This is my first question in the community .

See if you can help me.

I have a DataSet with this extrutura :
DsReportModel
-> Noconta
- > Descr
- > Month
- > Value
-> Variation


By creating a simple report to display the data, it looks like this:

noconta----descr --- month ------value --- variation
1.1-----------Account1-----1-----------10.00-------0
1.2-----------Account2-----1-----------12.00-------2
1.3-----------Account3-----1-----------11.00-------1
1.4-----------Account4-----1-----------16.00-------4
2.1-----------Account5-----1-----------12.00-------2
2.2-----------Account7-----1-----------12.00-------6
2.3-----------Account8-----1-----------11.00-------7

1.1-----------Account1-----2------------11.00------3
1.2-----------Account2-----2------------16.00------2
1.3-----------Account3-----2------------17.00------1
1.4-----------Account4-----2------------18.00------7
2.1-----------Account5-----2------------10.00------8
2.2-----------Account7-----2------------11.00------2
2.3-----------Account8-----2------------12.00------1


I would like to create a report to display the information as follows:
noconta----descr --- | $ month1 | variation month1 | - | $ month2 | variation month2 |
1.1-----------Account1-----10.00-------------------0-----------------11.00-------------------3
1.2-----------Account2-----12.00-------------------2-----------------16.00-------------------2
1.3-----------Account3-----11.00-------------------1-----------------17.00-------------------1
1.4-----------Account4-----16.00-------------------4-----------------18.00-------------------7
2.1-----------Account5-----12.00-------------------2-----------------10.00-------------------8
2.2-----------Account7-----12.00-------------------6-----------------11.00-------------------2
2.3-----------Account8-----11.00-------------------7-----------------12.00-------------------1

In the DataSet , it is possible that the information for the month does not always start in one month because the data comes from a selection of the user can choose the report from the month 7 - and month 12 , in which case the DataSet would only information of 7 months until month 12.

I appreciate any help or suggestion .


Note :
I'm using C # .

Thank´s

[Nasko]

Hi Pedro,

In order to achieve the desired scenario you should use the Crosstab item. Connect its data source to your DataSet and then drag and drop the fields from the data source to your Crosstab item to arrange the layout you need.

If you experience any difficulties, you can refer to the following demo project and video tutorials the use the Crosstab in a similar scenario:

• Product Sales per Period Demo
• Working with Tables Lists and Cross Tabs Video Tutorial

You can find the report definition of the above demo projects in your Telerik Reporting installation folder (usually C:\Program Files (x86)\Telerik\Reporting <your version>\Examples).

Regards,
Nasko
Telerik