Bad Parameter in refreshable Excel report query

Microsoft Dynamics GPOver the last few months, I’ve been doing work with clients on creating some refreshable Excel reports. Working on one of them, we had parameters for dates and added one for Vendor ID, which is when I encountered an error:

Excel error message

Microsoft Excel

Bad parameter type. Microsoft Excel is expecting a different ind of value than what was provided.

The Excel sheet looked fine with the three parameters all…

Continue Reading Ian Grieve’s Article on their blog

https://www.azurecurve.co.uk/2020/06/bad-parameter-in-refreshable-excel-report-query/

Blog Syndicated with Ian Grieve’s Permission

Author: Ian Grieve

Share This Post On