If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

what i mean is about this "PARAMETERS [Beginning Date] DateTime, [Ending Date] DateTime;" the MS SQL do not support this method they only use "DECLARE [Beginning date].... i know how to create filter in stored procedure what i want to know is when you filter it in dotNET when you create MS SQL Reporting Services and filter the data which is user defined... i also know that dotNET can filter in the data section but it is not user defined i just wanted to prompt the user what will be displayed... in Visual Basic the code would look like this...

Parameters in MSSQL

Hi there,

I don't really know about Reporting Services, except that the parameters for a report are built into the report, which are filled or selected from while a report is executing, from wizards and menu options while you are building a report. Also, whether sql batch or stored procedure, you are likely to use @ variables as parameters inside sql statements. In MSSQL, for example, parameters look like this: