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
<code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit;">****** name=Catalog content="Adventure Works DW"> ****** name=Table content="Adventure Works"> <title>Adventure Works</title> <xml id=docprops><o:DocumentProperties xmlns
="urn:schemas-microsoft-comfficeffice" xmlns="http://www.w3.org/TR/REC-html40"> <o:Name>Adventure Works</o:Name> </o:DocumentProperties> </xml><xml id=msodc><odc:OfficeDataConnection xmlnsdc="urn:schemas-microsoft-comfficedc" xmlns="http://www.w3.org/TR/REC-html40"> <odc:Connection odc:Type="OLEDB"> <odc:ConnectionString>Provider=MSOLAP.3;Integrated Security=SSPI;Persist Security Info=True;Data Source=myolapserver;Initial Catalog=Adventure Works DW</odc:ConnectionString> <odc:CommandType>Cube</odc:CommandType> <odc:CommandText>Adventure Works</odc:CommandText> <odc:SSOApplicationID>Application1</odc:SSOApplicationID> <odc:CredentialsMethod>Stored</odc:CredentialsMethod> <odc:AlwaysUseConnectionFile/> </odc:Connection> </odc:OfficeDataConnection> </xml>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</code></pre>
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
<code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit;">****** name=Catalog content="Adventure Works DW"> ****** name=Table content="Adventure Works"> <title>Adventure Works</title> <xml id=docprops><o:DocumentProperties xmlns
="urn:schemas-microsoft-comfficeffice" xmlns="http://www.w3.org/TR/REC-html40"> <o:Name>Adventure Works</o:Name> </o:DocumentProperties> </xml><xml id=msodc><odc:OfficeDataConnection xmlnsdc="urn:schemas-microsoft-comfficedc" xmlns="http://www.w3.org/TR/REC-html40"> <odc:Connection odc:Type="OLEDB"> <odc:ConnectionString>Provider=MSOLAP.3;Integrated Security=SSPI;Persist Security Info=True;Data Source=myolapserver;Initial Catalog=Adventure Works DW</odc:ConnectionString> <odc:CommandType>Cube</odc:CommandType> <odc:CommandText>Adventure Works</odc:CommandText> <odc:SSOApplicationID>Application1</odc:SSOApplicationID> <odc:CredentialsMethod>Stored</odc:CredentialsMethod> <odc:AlwaysUseConnectionFile/> </odc:Connection> </odc:OfficeDataConnection> </xml>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</code></pre>
