I don't have a solution to your issue, but your topic of discussion may help
me with a problem I am currently having. I am also using a drop down boxes, 3
to be exact, filled by different queries. When I click generate report, I
get an error stating the variables that are supposed to be assigned from
these boxers are not assigned. The error would be something like, " Must
declare the scalar variable "@customer". " where customer would be a
selection made in one of the drop down boxes. Do you have any direction or
solution to this error? Thanks.
[quoted text, click to view] "crmLearner" wrote:
> Hi everyone.
>
> I'm creating a report on Reporting Services 2005. The report has parameters.
> One of the parameters is a Drop Down list box, which is populated by a query.
> Currently, the user cannot enter values into this parameter (obviously, as it
> is a drop down). The user has a new requirement that they want to be able to
> either select a value from the drop down, or enter a value on the same drop
> down (almost like a combo box).
>
> I've tried playing around with the settings ("Allow null", "Allow blank"),
> but nothing seems to work. Please help.
>
> Thank you in advance.
> --
Hi there. @customer must be declared in sql script, i.e. "Declare @customer
varchar (35)". If the problem is not on your script, then click on the data
source eclipse button on the data view tab in reporting services. Then go to
the parameters tab to check whether the parameters are correctly declared.
You could also try clicking on the Report Parameters menu item and see where
you could be going wrong. I'm afraid that's all I can come up with.
--
Regards,
[quoted text, click to view] "daniel" wrote:
> I don't have a solution to your issue, but your topic of discussion may help
> me with a problem I am currently having. I am also using a drop down boxes, 3
> to be exact, filled by different queries. When I click generate report, I
> get an error stating the variables that are supposed to be assigned from
> these boxers are not assigned. The error would be something like, " Must
> declare the scalar variable "@customer". " where customer would be a
> selection made in one of the drop down boxes. Do you have any direction or
> solution to this error? Thanks.
>
> "crmLearner" wrote:
>
> > Hi everyone.
> >
> > I'm creating a report on Reporting Services 2005. The report has parameters.
> > One of the parameters is a Drop Down list box, which is populated by a query.
> > Currently, the user cannot enter values into this parameter (obviously, as it
> > is a drop down). The user has a new requirement that they want to be able to
> > either select a value from the drop down, or enter a value on the same drop
> > down (almost like a combo box).
> >
> > I've tried playing around with the settings ("Allow null", "Allow blank"),
> > but nothing seems to work. Please help.
> >
> > Thank you in advance.
> > --
Don't see what you're looking for? Try a search.
