Post reply

using store procedure to populate SSRS Parameters

  • October 20, 2009 at 1:23 pm

    #205805

    I have a store procedure that work fine for entire results, but I am interest it in populating my parameters with result of my store procedure, do I need more than one SP, or can I use my existing SP to also bring the distinct values I need to populate my dropdownlist.

    Thanks in advance

  • October 20, 2009 at 1:49 pm

    #1068492

    adonismartinez (10/20/2009)

    I have a store procedure that work fine for entire results, but I am interest it in populating my parameters with result of my store procedure, do I need more than one SP, or can I use my existing SP to also bring the distinct values I need to populate my dropdownlist.

    Thanks in advance

    If the procedure you have is already returning distinct values, then you can just use it.

    If it's not returning distinct values, then you need either a procedure with a modified query that will, or one that takes the result of the existing one and returns the distinct values.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • October 20, 2009 at 2:29 pm

    #1068515

    Yeah, sounds like I need moe SP's to create the desire list needed to polulate my parameters dropdowns.

    Thanks,

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply