Dynamics Community Forum Thread Details

ExcelReports Data Source

We've created a custom ExcelReport based on a SQL Stored Procedure. Report works as expected on the server -- where the ODBC Data Source exists. However, we have deployed GP using a RemoteApp, so no local code (including ODBC Data Source) exists.

When users attempt to run the ExcelReport they receive error messages regarding missing Data Source. We created a new 64-bit Data Source to allow access to the custom ExcelReport because we have 64-bit Office installed locally. The ExcelReport runs without issue when running Remote Desktop because the Data Source is local.

It seems the ExcelReports work with the ODC connections deployed through GP.

Is it possible to create an ODC connection for the custom ExcelReport and not rely on the ODBC Data Source?

Categories:

Microsoft Dynamics GP

I haven't actually tested what you're stating, so I'll refer to the Community to see if any of them have.

I'm wondering, since you can't add the data source to where your custom Excel Report is located, can you setup some type of data connection on the report itself?

For example, using the 'Accounts' Excel Report from Dynamics GP, the connection string is something like this:

Provider=SQLNCLI11.1;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=T185C;Data Source=DESKTOP-03KE9TQ;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=DESKTOP-03KE9TQ;Use Encryption for Data=False;Tag with column collation when possible=False;MARS Connection=False;DataTypeCompatibility=0;Trust Server Certificate=False;Application Intent=READWRITE

Thanks

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL