Here's my web.config settings:
<configSections>
<section name="Telerik.Reporting" type="Telerik.Reporting.Processing.Config.ReportingConfigurationSection, Telerik.Reporting, Version=7.0.13.426, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" allowLocation="true" allowDefinition="Everywhere"/>
</configSections>
<Telerik.Reporting>
<Extensions>
<Render>
<Extension name="CSV">
<Parameters>
<Parameter name="NoHeader" value="false"/>
<Parameter name="NoStaticText" value="true"/>
</Parameters>
</Extension>
</Render>
</Extensions>
</Telerik.Reporting>
in the ReportTemplate.cs: private void table1_ItemDataBinding(object sender, EventArgs e)
{
... //for loop - iterate all selected fields
var textBox = new Telerik.Reporting.TextBox();
textBox.Name = colHeader;
textBox.Size = new SizeU(Unit.Inch(width), Unit.Inch(0.3));
textBox.CanGrow = true;
textBox.StyleName = "Data";
textBox.Value = "=Fields.[" + strColumn + "]";
...
}
I don't experience this issue in static reports, I have placed this workaround inside the constructor:
public Contracts()
{
InitializeComponent();
this.textBox8.Name = "Contract Number";
this.textBox9.Name = "Date Contract Received";
this.textBox10.Name = "Deadline Date";
this.textBox11.Name = "Date of Original Contract";
this.textBox12.Name = "Contract Execution Date";
this.textBox13.Name = "Contract Effective Date";
this.textBox14.Name = "Contract Expiration Date";
//this.table1.ItemDataBinding += new EventHandler(table1_ItemDataBinding);
}
Here's the output:
Found out that what's causing exported CSV's first column to become row values was the obsolete NavigateToReportAction.Parameters for sorting.
I commented that part and voila, that solved the problem.