Search:
Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in SQL Server Reporting Services (SSRS)

Interview Question :: MS SQL Server 2005 Reporting Services Report Parameter

I have a report parameter for the end-dates of time periods from a time keeping system that I am using the query to obtain the available values. The issue lies in the fact that there are multiple entries for the same date in the database (for example, there might be 30 entries for 8/6/2006), as there is a date entry for each time period end-date for each employee who entered their hours into the system then. Is there any way to limit the list to only one entry per date (only see 8/6/2006 ONCE, not 30 times), with having only one parameter and not two for a range of dates?

Answers to "MS SQL Server 2005 Reporting Services Report Parameter"

RE: MS SQL Server 2005 Reporting Services Report Parameter?
The best way would be to format the date and use a distinct: Select Distinct convert(varchar(10), EndDateField, 101) as EndDate from TableName order by cast(EndDate as datetime) Then, in your report query, do the same conversion: Where convert(varchar(10), EndDateField, 101) = @EndDate Alternately, you could use a between: Where EndDateField between @EndDate and @EndDate + 1 The first version is safer; the second one may be slightly speedier.
Vote for this answer ::

Notify me whenever an answer is posted for this question Update Alert Setting

Top Tags

- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers

Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in SQL Server Reporting Services (SSRS)

Interview Question :: MS SQL Server 2005 Reporting Services Report Parameter

Top Tags