Date Parameter in SSRS 1

[charbrad]

I have set up date parameters in SSRS 2005 that are not working. Under reports I click report parameters and enter the following criteria:

Properties:
Name BeginDate
Data Type:  DateTime
Prompt:  BeginDate

Allow blank value is checked.

Available Values = Non-queried
Default values = Null

I have done the same for EndDate.

When the user enters the date criteria it bring ups the entire report instead of the specific date range. Is there somewhere else I need to enter this parameter info?

 

[RiverGuy]

Yes. You can either create a generic query for your dataset to return all rows, and then put a filter on your Table or whatever display object you are using. Or, you can create a parameter in your source query for your dataset.

 

[charbrad]

I am fairly new to SSRS could you explain how I would create a parameter in my source query for my dataset?

 

[RiverGuy]

What type of source database are you pulling from? SQL Server? Access? Oracle? DB2? etc

 

[charbrad]

SQL

 

[RiverGuy]

The source query would look something like the following:

select * from SomeTable where SomeDateColumn = @SomeParameterName

Then if you click the "Parameters" tab in your DataSet editor, you can map the @SomeParameterName parameter to your report's parameter.

 

[charbrad]

worked perfectly....Thanks.

 

[RiverGuy]

No problem.