SQL Reporting 2008 and Excel as Data Source -

i working on project need develop sql reports based on excel files.

i able create odbc excel file , able connect using report services.

my question is:

how can used paramaters in query ? when try use @cif or @startdate kinds of errors , don't know how use parameters sql query excel.

sample:

select * [loans$] [cif] = @cif

can tell me how?

if extracting information without trying filter @ query level, workaround can add filtering @ dataset level, like:

enter image description here

this extract data dataset then apply filter, not try @ same time.

it's might not addressing root cause, , running in meantime.

since don't list errors you're getting, it's hard offer more specific advice.

KHS