Parameters not active in query

Copper Contributor

Hallo.

I am extracting data from an SQL Server table into a pivot table.

I need to drive it with an SQL statement in the property definition mask.

It works perfectly.

 

My problem is that I'm trying to use a parameter picked from a cell of my excel sheet, but the parameters button is not active.

 

I tried to insert a "?" as suggested in some blogs to activate the button, but nothing happens.

In the file attached you can find the mask, the line I would like to modify in order to pick the "where" value from a cell, and the not-active parameter button

 

Can anyone help?

Thank you in advance

 

Bruno

0 Replies