• Using SET FMTONLY OFF does not work.

    Some suggest using Exec under text in the dataset properties.

    But doing this way won't allow me to pass parameters.

    So if anyone has a solution for either of this, I would be really appreciated:

    1) Have the stored procedure return the fields

    2) Using the workaround of Exec, how do I pass parameter?

    I have google everywhere.

    This suggestion below does not work:

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d8c68166-fca2-4da4-8af9-107363d96c57/ssrs-not-passing-fieldsparameters-to-report-when-stored-procedure-keeps-parameters-inside-if?forum=sqlreportingservices

    samuel.bayeta (4/25/2016)


    Hi Every one, Though this sounds a late response to a 6 years old question, I happen to feel it is beneficial to respond a best answer as others might have referred this website for their day to day need. in short the answer to this is fake SSRS by creating your stored procedure with a hint SET FMTONLY OFF. This is a dramatic trick.