Post reply

Dataset does not fire stored proc in report preview

  • June 28, 2016 at 2:07 pm

    #327489

    I have a report in SSRS on SQL Server 2008 R2. There are several datasets that populate parameters in the report. While watching the stored procedure calls in SQL Profiler I observed the stored procedures being called when the report is put into preview mode. All of the datasets are called but the one in question.

    The stored procedure in question is designed to return "-- ALL -- " when the optional procedure parameters are null or empty strings.

    If one parameter on the report is changed the stored procedure gets called and the functionality is as expected.

    I can see no differences in the structure of the Xml in the .rdl for any of the parameters or the stored procedures.

    Has anyone else run in to this problem?

  • June 28, 2016 at 2:09 pm

    #1887431

    preview mode creates a cache file, and does not always call the server to get the data; if you look, you should see a rdl.data file, i believe.

    delete that file, and a new cache will be rebuilt for the preview mode, so if you run it with your "all" parameter, you should see what you are expecting.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • June 28, 2016 at 2:17 pm

    #1887432

    Lowell,

    I tried you suggestion and had no better results. Thank you for responding.

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

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