Hello,
I'm caught in a weird issue were in the changes are not saving and getting "Index out of bound exception" while saving. It was working properly with 4.9. and it breaks with the latest version downloaded today.
Code below:
for (int pivotFieldIndex = 0; pivotFieldIndex < pivotFields.Count; pivotFieldIndex++)
{
if (pivotFields[pivotFieldIndex].Name.Equals("Desk") ||
pivotFields[pivotFieldIndex].Name.Equals("Trader") ||
pivotFields[pivotFieldIndex].Name.Equals("Report Date"))
{
pivotTable1.PageFields.Add(pivotFields[pivotFieldIndex]);
continue;
}
if (pivotFields[pivotFieldIndex].Name.Equals("Issuer(P)"))
{
pivotTable1.RowFields.Add(pivotFields[pivotFieldIndex]);
continue;
}
if (pivotFields[pivotFieldIndex].Name.Equals("Period"))
{
pivotTable1.ColumnFields.Add(pivotFields[pivotFieldIndex]);
continue;
}
if (pivotFields[pivotFieldIndex].Name.Equals("Total PnL") ||
pivotFields[pivotFieldIndex].Name.Equals("New/Cancel'd") ||
pivotFields[pivotFieldIndex].Name.Equals("Credit") ||
pivotFields[pivotFieldIndex].Name.Equals("Rates") ||
pivotFields[pivotFieldIndex].Name.Equals("Total Less Rates") ||
pivotFields[pivotFieldIndex].Name.Equals("Credit Notional") ||
pivotFields[pivotFieldIndex].Name.Equals("CS01") ||
pivotFields[pivotFieldIndex].Name.Equals("IR01") ||
pivotFields[pivotFieldIndex].Name.Equals("Trading less FX"))
{
pivotFields[pivotFieldIndex].DisplayName = pivotFields[pivotFieldIndex].Name;
pivotTable1.DataFields.Add
(pivotFields[pivotFieldIndex]);
pivotFields[pivotFieldIndex].NumberFormat = "#,##0;[Red](#,##0)";
pivotFields[pivotFieldIndex].Number = 4;
continue;
}
if (pivotFields[pivotFieldIndex].Name.Equals("Total Less Rates Less FX"))
{
if (reportType.Equals("1"))
{
pivotTable1.DataFields.Add
(pivotFields[pivotFieldIndex]);
pivotFields[pivotFieldIndex].NumberFormat = "#,##0;[Red](#,##0)";
continue;
}
}
if (pivotFields[pivotFieldIndex].Name.Equals("Trading"))
{
if (reportType.Equals("2"))
{
pivotTable1.DataFields.Add
(pivotFields[pivotFieldIndex]);
pivotFields[pivotFieldIndex].NumberFormat = "#,##0;[Red](#,##0)";
pivotFields[pivotFieldIndex].Number = 5;
continue;
}
}
if (pivotFields[pivotFieldIndex].Name.Equals("Trading Less FX"))
{
if (!reportType.Equals("2") || !reportType.Equals("1"))
{
pivotTable1.DataFields.Add
(pivotFields[pivotFieldIndex]);
pivotFields[pivotFieldIndex].NumberFormat = "#,##0;[Red](#,##0)";
continue;
}
}
}
If you comment the bold line, it saves properly. Please help!
Thanks,
Pradeep