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.
| Author |
Topic |
|
Neal44
Starting Member
17 Posts |
 Posted - 2010-11-24 : 12:19:57
|
| Hi,**SSRS 2005**My report has a field (DateOfNextOrder) passed to it from a stored proc. This field is in DATETIME format (yyyy-mm-dd hh:ss:mmm).I have 2 parameters that are also DATETIME format (StartDate & EndDate).The report currently displays all of the records BY DEFAULT where: DateOfNextOrder >= @StartDateAND DateOfNextOrder <= @EndDate(I currently filter this in the stored proc).However, there are new requirements. In future I would like to set the filter within the report thereby passing all records without this filter. The default should remain the same but using the report parameters instead, AND when required, I also wish to display any orders that are outside of these parameters (I imagine this could either by using the InitialToggleState property of a field or by selecting an additional parameter (i.e. a Yes/No).The report struture has 3 Groups. The 3rd group contains a InitialToggleState funtion on one of the display fields to display/hide the details row. Any ideas how I do this please? Sorry, I'm not too skilled in this environment.Thanks in advance,Neal |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-11-27 : 02:18:28
|
| removing the filter from proc and putting it in report make sure that all records are retrieved to report always. are you sure you want to do that? if number of records is large report performance would be bad.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Toggle additional output records