When I delete a parmeter, the report won't run and I get a strange message

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

drolaw - 28 May 2008 18:12 GMT

Hello,
I'm relatively new to SSRS. I'm noticing that when I alter
attributes of a report (i.e. delete a parameter), it doesn't appear to
actually delete it from the report. I've had to go into the rdl and
delete the related components (i.e query values, etc). In the latest
one, I have a very simple parameter with no default values, it doesn't
hit the db in any way. I deleted the parameter as I no longer need it.
Now, when I attempt to run the report I get this error:

The definition of the report /AccountReport.rdl is invalid. The
Value expression for the query parameter @ACCOUNT_NAME refers to a non-
existing report parameter ACCOUNT_NAME.

This is right after I deleted the ACCOUNT_NAME parameter. I have
searched the rdl for ACCOUNT_NAME and @ACCOUNT_NAME and I was not
able to find any reference to them in the rdl. I have refreshed the
data set as well. The report still keeps retuning this message.

Does anybody know why this is happening? Also, how do I completely
delete a parameter. Deleting it through the GUI doesn't seem to work
all the time.

Thanks,
Dave

Reply to this Message

Wayne - 28 May 2008 19:31 GMT

When you add a dataset, or refresh it's fields, any parameters that the
dataset uses (ie. if it's a stored procedure) will be made into report
parameters. This can be seen by editing the dataset, and clicking on the
parameters tab.

Deleting the report parameter does not delete any other references to it.

It looks like you have a query parameter in one of your datasets named
@ACCOUNT_NAME. If this is an optional parameter, I'd suggest setting it's
value to null; otherwise you need to set it to something for that query to
run.

> Hello,
> I'm relatively new to SSRS. I'm noticing that when I alter
[quoted text clipped - 20 lines]
> Thanks,
> Dave

Reply to this Message

drolaw - 29 May 2008 17:51 GMT

> When you add a dataset, or refresh it's fields, any parameters that the
> dataset uses (ie. if it's a stored procedure) will be made into report
[quoted text clipped - 34 lines]
>
> - Show quoted text -

Thanks Wayne,
I actually figure out that I was looking at an older copy of the
rdl and I was able to delte the reference there. All is well now.

Reply to this Message