>>>I'm in SSRS Report Designer. I see the icon for adding a table. I click it and there are tabs for Tables, View, Function, and Synonyms. How do I use a stored procedure?
>>
>>Stored procedure would be under function.
>
>I figured it out.
>
>In the report's Data tab is a Generic Query Designer button. To the right of that is a Command Type drop down with 'Text' and 'Stored Procedure' in it.
>
>Selecting 'Stored Procedure' has no visual effect. I then clicked the Generic Query Designer button again and the toolbar changed. Opening the Stored Procedure dropdown shows a list of my procedures.
>
>I just want to say - This design is completely counter-intuitive. Whoever designed that is a moron.
I agree. It works though, and the output is nice.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________