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

List horizontally months

1 Answer 71 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Pedro Henrique
Top achievements
Rank 1
Pedro Henrique asked on 24 Oct 2013, 04:13 PM
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

1 Answer, 1 is accepted

Sort by
0
Nasko
Telerik team
answered on 29 Oct 2013, 02:54 PM
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:

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

Have you tried the new visualization options in Telerik Reporting Q2 2013? You can get them from your account.

Tags
General Discussions
Asked by
Pedro Henrique
Top achievements
Rank 1
Answers by
Nasko
Telerik team
Share this question
or