Reporting Services parameter problem RRS feed

  • Question

  • I have a report built in Reporting Services that references a stored procedure in SQL Server. I have this one parameter that works in SQL Server, works in the Data tab of Reporting Services but will not work on the Preview tab. It sets a sort order and no matter what I select on Preview tab, I get one sort order.

    I have tried it as non-queried list (of two items) and I've tried it as a query parameter from a table that I populated with these two items. Regardless, it works in the first two places but not the Preview tab. Has anyone got any ideas on this? Thanks. 
    Friday, August 15, 2008 8:29 PM