Apr 27 2020 02:43 AM
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