Post reply

I deleted parameters and now get an error

  • March 23, 2016 at 6:11 am

    #312252

    I had a report with start date and end date parameters but, I changed the sp so, no longer need the parameters. I deleted them from the report and now get an error, "The Value expression for the query parameter '@StartDate' refers to a non-existing report parameter 'StartDate'. Any thoughts?

  • March 23, 2016 at 6:15 am

    #1867048

    you have to edit the report, and remove the parameter in the report as well. the report is still happily sending the parameters as it last knew them, it doesn't know you changed the underlying procedure, so you have to re-edit the report and republish.

    alternatively, you can put the parameters back in the procedure and ignore them when it is called.

    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!

  • March 23, 2016 at 6:40 am

    #1867058

    Got it. Thanx.

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

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