Bad Parameter in refreshable Excel report query

Over 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:

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

Bad Parameter in refreshable Excel report query

Over 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 ‎…

Blog Syndicated with Ian Grieve’s Permission