none
SSRS - How to call a SPROC with multiple parameters from a report in BIDS?

    Question

  • Hi

    I have this SPROC in my database:

    [sprocGetClosedOrdersOverview]
    (
    @fromDate DATETIME,
    @toDate DATETIME           
    )

    In my report have two parameters which I want to call my SPROC with.
    I can see my SPROC when I make the dataset in the report.
    But I don't know how to call it with the report parameters in the BIDS query designer or somewhere else.

    I am using SQL Server 2012 Standard Edition SSRS.

    Can anybody provide me with a tutorial on how to do this (preferably visual with screen shots)?


    • Edited by rune0071 Thursday, June 20, 2013 6:17 PM
    Thursday, June 20, 2013 2:50 PM

Answers

  • Hi Rune,

    In Reporting Services, when you create a dataset using a store procedure, we can select "Store Procedure" query type and then we can select the store procedure in the drop-down list directly. In this case, Reporting Services will create parameter automatically if you have parameter in the store procedure.

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

    Regards,


    Charlie Liao
    TechNet Community Support

    • Marked as answer by rune0071 Friday, June 21, 2013 9:14 AM
    Friday, June 21, 2013 6:32 AM

All replies