Parameters not active in query

%3CLINGO-SUB%20id%3D%22lingo-sub-1339966%22%20slang%3D%22en-US%22%3EParameters%20not%20active%20in%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1339966%22%20slang%3D%22en-US%22%3E%3CP%3EHallo.%3C%2FP%3E%3CP%3EI%20am%20extracting%20data%20from%20an%20SQL%20Server%20table%20into%20a%20pivot%20table.%3C%2FP%3E%3CP%3EI%20need%20to%20drive%20it%20with%20an%20SQL%20statement%20in%20the%20property%20definition%20mask.%3C%2FP%3E%3CP%3EIt%20works%20perfectly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20problem%20is%20that%20I'm%20trying%20to%20use%20a%20parameter%20picked%20from%20a%20cell%20of%20my%20excel%20sheet%2C%20but%20the%20parameters%20button%20is%20not%20active.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20to%20insert%20a%20%22%3F%22%20as%20suggested%20in%20some%20blogs%20to%20activate%20the%20button%2C%20but%20nothing%20happens.%3C%2FP%3E%3CP%3EIn%20the%20file%20attached%20you%20can%20find%20the%20mask%2C%20the%20line%20I%20would%20like%20to%20modify%20in%20order%20to%20pick%20the%20%22where%22%20value%20from%20a%20cell%2C%20and%20the%20not-active%20parameter%20button%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%3F%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBruno%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1339966%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

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