Visual Studio - Report Builder - Parameters - Data Source View RRS feed

  • Question

  •  Hi,

    I was wondering if anyone could help.

    I am using Visual Studio Reporting Services 2005.

    I have created a Data Source View in a report model as the data source is large I want to be able to allow the user to select a 'From' and 'To' date to run the reports that they build?

    I typed in a Named Query with the where clause

        where date between @From and @To

    this seemed fine at first but when I clicked ok I recieved an error message saying 

        'Must Declare the Variable @From' 

    But as far as I am aware there is no way to declare the variable.

    Is there anyway of using parameters like this with Data Source Views.

    Many Thanks
    • Edited by afinecity Wednesday, July 16, 2008 12:01 PM To make clear that I was using Visual Studio 2005
    Tuesday, July 15, 2008 4:06 PM

All replies

  • Hi afinecity,

    You can’t use parameter in Named Query.

    To achieve your requirement, first deploy your report mode without using parameter after that use Filter option while using Report Builder.

    Aftab Ansari
    Wednesday, July 16, 2008 12:05 PM