Urgent Help needed - Pivot table scroll bar

[Ashok]

I use code below in windows application using Pivot table to display cube
data. The problem is if I don't insert any fields then I see scroll bar in
Pivot table but as soon as I put this line
objPTView.RowAxis.InsertFieldSet(objPTView.FieldSets["FieldName"], null,
false);
application opens with one field in Pivot table but scroll bar don't show
up. I don't know how to fix this and it's almost going to kill my project if
I don't.

Thank you - Ashok

public void LoadCustomPivotTableReport()
{
string m_XML;
string strOLAPConn =
ConfigurationSettings.AppSettings["OLAPConnectionString"];
PivotTableClass objPT = new PivotTableClass();
PivotView objPTView;
PivotField fldCity;
PivotField fldName;
PivotField fldProdFamily;
PivotFieldSet fSet;
PivotFieldSet fSetProduct;

try
{
objPT.ConnectionString = strOLAPConn;
objPT.DataMember = "CubeName";
objPT.AllowFiltering = true;

objPTView = objPT.ActiveView;



objPTView.RowAxis.InsertFieldSet(objPTView.FieldSets["FieldName"], null,
false);

axPivotTable1.XMLData = objPT.XMLData;

}
catch (Exception err)
{
m_XML = "<err>" + err.Source + " - " + err.Message + "</err>";
}
finally
{

}

}

 

[Ashok]

As i tested more it's some thing in my Field or Field data because if I
changed to different Field then I have scroll bar.
What can be in data or field name or some thing else which is making scroll
bar not showing up? When I keep this problem field in 2nd location I do see
scroll bar but as soon as move to first location/ column scroll bar doesn't
show up.