Greetings everyone, hope this tip is helpful.

I recently created an agent sales report showing sales by day that takes the parameters @sdate and @edate for the date range. When pulling this report from a website It's obvious what dates your looking at since you entered them. However, when subscriptions to this report are setup it would be nice to see the dates it ran for displayed in the report. After trying many combinations of @sdate, =@sdate, =getdate()-1, etc... I found that you must use this (=Parameters!<Parameter Name>.Value). In my case I just dropped a text box on the report and punched in (=Parameters!sdate.Value) and vala... the report now displayed the start date that was used when running the report.

Hope this help!

--
Ben Sullins
Sql Developer - Our Vacation Store

__________________
--
Ben Sullins
Sql Developer - Our Vacation Store