how to pur prompts for a dataset in SSRS for DB2 database RRS feed

  • Question

  • Hi,

    I am using OLEDB connection and using DB2 as my source to build SSRS reports. I want to put a prompt for the dataset and i tried with : or @ to put the prompts in my query. But both these options giving me different errors. Can any one let me know how to implement prompts in SSRS for DB2 database.

    Sunday, November 1, 2015 11:52 PM


  • Hi Ravindrajal,

    According to your description, you want to add parameters to the dataset when you use DB2 database as an data source, right?

    Based on my research, to call DB2 using parameterized query on Reporting Services side, we can build the query string in an expression with parameters defined in the report like below:

    ="SELECT * FROM SomeTable WHERE Category = " & Parameters!Category.Value & " AND TheDate = '" & Parameters!TheDate.Value "'"

    For more information, please refer to this similar thread:
    cannot call db2 from ssrs using parameterized query

    If you have any question, please feel free to ask.

    Best regards,
    Qiuyun Yu

    Qiuyun Yu
    TechNet Community Support

    Monday, November 2, 2015 2:35 AM