G
Guest
Hello
I have an HTTPHandler which retrieves a dataset from SQL Server and converts
it to XML. This is then used as the commandtext for an OWC 11 pivot table
like this.
document.frmSpendPivot.PivotControl1.ConnectionString = "provider=mspersist"
document.frmSpendPivot.PivotControl1.CommandText = "GetPivotData.aspx"
The strange thing is the ProcessRequest of the GetPivotData page fires twice
meaning the database is queried twice for the same dataset before being
passed to the Pivot Table.
I would like to obviously avoid the second trip so would like to know if
anyone has had a similar problem and how they got round it.
Many thanks in anticipation!
R
I have an HTTPHandler which retrieves a dataset from SQL Server and converts
it to XML. This is then used as the commandtext for an OWC 11 pivot table
like this.
document.frmSpendPivot.PivotControl1.ConnectionString = "provider=mspersist"
document.frmSpendPivot.PivotControl1.CommandText = "GetPivotData.aspx"
The strange thing is the ProcessRequest of the GetPivotData page fires twice
meaning the database is queried twice for the same dataset before being
passed to the Pivot Table.
I would like to obviously avoid the second trip so would like to know if
anyone has had a similar problem and how they got round it.
Many thanks in anticipation!
R