Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Add Parameter to top of report

Author  Topic 

cwildeman
Starting Member

40 Posts

Posted - 2011-06-29 : 15:15:21
Hi,
I have some parameters in my stored procedure that I have passed to my SSRS report. When the user runs the report, they plug in the parameter values which are @startdate and @enddate. I want for these to appear at the top of my report once it runs and say @startdate To @endDate and have the user selected date values appear. I tried a couple of things but can't seem to figure it out.
Thanks,

Chuck W

cwildeman
Starting Member

40 Posts

Posted - 2011-06-29 : 15:40:18
I figured it out. You drag the paramter onto the form. I then formatted as =format(Parameters!startdate.Value, "MM-dd-yy") so that only the date shows and not the time. Chuck

Chuck W
Go to Top of Page
   

- Advertisement -