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 containing valid data:

Excel report

Looking at the query in Connection Properties had the question marks denoting the parameters in the correct place in the queries:

Connection Properties

It took me a while before I twigged that the problem was the order of the parameters. From the Connection Properties window, click the Parameters… button to view the parameter configuration. The parameters were set to read from specific cells and I had, without thinking it through, create the date parameters, tested the report and then added the Vendor ID to the third row and then moved it to the first row.

The order in which I’d taken these actions, left Excel set with the Vendor ID in cell B£ when it was now in cell B1:

Parameter setup

Once I corrected the parameters, the error was resolved and the report successfully ran.

Can ISC Software Solutions help?

ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP. If you’d like to speak to someone about consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else Dynamics GP related, you can use the form below.
Your Name (required):
Your Email (required):
Subject:
Enquiry message:

What should we write about next?

Your Name (required) –
Your Email (required) –

Leave a Reply

Your email address will not be published. Required fields are marked *