opening odc:OfficeDataConnection and opening few columns by default

[nihirshah]

I am generating an excel file using odc:OfficeDataConnection xml method. My command type is cube and commandText is cube name.

Now this works fine and generates an empty excel at runtime. People can choose the fields they want and see the pivotTable.

But my issue is I need to set a few columns as default, so when excel opens it automatically puts 2-3 fields in pivot table, so the user doesn't see an empty screen.

This is kind of my sample code

Please Login or Register  to view this content.

I was wondering if there is a way to add certain column in these settings so it opens those columns at runtime or use macro to run when excel is generating and loading.

Any help will be appreciated