Being VERY new to RS 2000 (started looking at it a week ago), I need some advice. I have a table that contains a datetime field and I have a report that is prompting for a start date and start time, along with an end date and end time (4 prompts in total). How do I combine the dates and times together to pull into the query filter? Am I even going about this the right way?
Thanks much!
If I am understanding correctly you could do something like in your filters set the
TimeValue(Fields!Example.value) = TimeValue(Parameters!Time.Value)
and you could do that for time and date if you are trying to break apart a datetime field.
Josh
|||u can add the parameters into the SQL code such as :
SELECT * FROM tbl_Name WHEREId=@.Id
The RS refer the @.Id as Parameter.
没有评论:
发表评论