how to pass id in the query RRS feed

  • Question

  • am new to ssrs

    i created an dataset from that dataset am retrieving unique name and id,

    and am passing name in the parameter but i need to pass id the query(because i need to retrieve the values based on id)  but in front end i have to show the names

    i dnt know how to pass id in the query. if you any idea please help me?

    ms crm

    Thursday, January 17, 2013 11:01 AM


  • Hello,

    You have to add a parameter in your query, e.g.:

    SELECT name, id
    FROM yourTable
    WHERE id = @idParameter

    Then you can map the report parameter to the query parameter in the dataset definition; see also Using Single-Value and Multivalue Parameters

    Olaf Helper

    Blog Xing

    • Proposed as answer by Fanny Liu Friday, January 18, 2013 7:05 AM
    • Marked as answer by Fanny Liu Monday, January 21, 2013 5:57 AM
    Thursday, January 17, 2013 11:11 AM

All replies