|
|
You're in the
sql server reporting services
group:Ignores date parameters
sql server reporting services:
I have a report with a beginning date and ending date. I want all the data
between those dates. It is set to datetime in the parameters and runs just fine except it totally ignores my dates. It gives me just about everything.
oh sorry.
SELECT MSP_PROJECTS.PROJ_ID, MSP_PROJECTS.PROJ_NAME, MSP_TASKS.TASK_ID, MSP_TASKS.TASK_IS_SUMMARY, MSP_TASKS.TASK_START_DATE, MSP_TASKS.TASK_FINISH_DATE, MSP_TASKS.TASK_NAME, MSP_TASKS.TASK_PCT_COMP FROM MSP_PROJECTS INNER JOIN MSP_TASKS ON MSP_PROJECTS.PROJ_ID = MSP_TASKS.PROJ_ID WHERE (MSP_TASKS.TASK_NAME LIKE ' %' + @cabinets + '%') OR (MSP_TASKS.TASK_NAME LIKE @deliver + '%') OR (MSP_TASKS.TASK_NAME = @shower) OR (MSP_TASKS.TASK_NAME = @hardware) OR (MSP_TASKS.TASK_NAME = @carpet) AND (MSP_TASKS.TASK_START_DATE BETWEEN @startdate AND @endate) [quoted text, click to view] "Bruce L-C [MVP]" wrote:
> Can you post the query? > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Benw" <Benw@discussions.microsoft.com> wrote in message > news:6EF1263D-B3B1-458F-A4D1-F41E5C4D29FB@microsoft.com... > >I have a report with a beginning date and ending date. I want all the data > > between those dates. It is set to datetime in the parameters and runs > > just > > fine except it totally ignores my dates. It gives me just about > > everything. > > Any suggestions? > >
That worked great, thank you very much
[quoted text, click to view] "Bruce L-C [MVP]" wrote:
> Try this. Note I'm bracketing all the ORs together and then doing the AND. > See how this works for you. > > WHERE ( (MSP_TASKS.TASK_NAME LIKE ' %' + @cabinets + '%') OR > (MSP_TASKS.TASK_NAME LIKE @deliver + '%') OR > (MSP_TASKS.TASK_NAME = @shower) OR > (MSP_TASKS.TASK_NAME = @hardware) OR > (MSP_TASKS.TASK_NAME = @carpet)) AND > (MSP_TASKS.TASK_START_DATE BETWEEN @startdate AND @endate) > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Benw" <Benw@discussions.microsoft.com> wrote in message > news:BBB71DBB-6C41-450B-BE90-7251B86D4479@microsoft.com... > > oh sorry. > > SELECT MSP_PROJECTS.PROJ_ID, MSP_PROJECTS.PROJ_NAME, > > MSP_TASKS.TASK_ID, > > MSP_TASKS.TASK_IS_SUMMARY, MSP_TASKS.TASK_START_DATE, > > MSP_TASKS.TASK_FINISH_DATE, MSP_TASKS.TASK_NAME, > > MSP_TASKS.TASK_PCT_COMP > > FROM MSP_PROJECTS INNER JOIN > > MSP_TASKS ON MSP_PROJECTS.PROJ_ID = MSP_TASKS.PROJ_ID > > WHERE (MSP_TASKS.TASK_NAME LIKE ' %' + @cabinets + '%') OR > > (MSP_TASKS.TASK_NAME LIKE @deliver + '%') OR > > (MSP_TASKS.TASK_NAME = @shower) OR > > (MSP_TASKS.TASK_NAME = @hardware) OR > > (MSP_TASKS.TASK_NAME = @carpet) AND > > (MSP_TASKS.TASK_START_DATE BETWEEN @startdate AND @endate) > > "Bruce L-C [MVP]" wrote: > > > >> Can you post the query? > >> > >> -- > >> Bruce Loehle-Conger > >> MVP SQL Server Reporting Services > >> > >> "Benw" <Benw@discussions.microsoft.com> wrote in message > >> news:6EF1263D-B3B1-458F-A4D1-F41E5C4D29FB@microsoft.com... > >> >I have a report with a beginning date and ending date. I want all the > >> >data > >> > between those dates. It is set to datetime in the parameters and runs > >> > just > >> > fine except it totally ignores my dates. It gives me just about > >> > everything. > >> > Any suggestions? > >> > >> > >> > >
Also how do I get information to pull that is equal to the endate. It only
pulls info from the start date to the day before the endate. [quoted text, click to view] "Bruce L-C [MVP]" wrote:
> Try this. Note I'm bracketing all the ORs together and then doing the AND. > See how this works for you. > > WHERE ( (MSP_TASKS.TASK_NAME LIKE ' %' + @cabinets + '%') OR > (MSP_TASKS.TASK_NAME LIKE @deliver + '%') OR > (MSP_TASKS.TASK_NAME = @shower) OR > (MSP_TASKS.TASK_NAME = @hardware) OR > (MSP_TASKS.TASK_NAME = @carpet)) AND > (MSP_TASKS.TASK_START_DATE BETWEEN @startdate AND @endate) > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Benw" <Benw@discussions.microsoft.com> wrote in message > news:BBB71DBB-6C41-450B-BE90-7251B86D4479@microsoft.com... > > oh sorry. > > SELECT MSP_PROJECTS.PROJ_ID, MSP_PROJECTS.PROJ_NAME, > > MSP_TASKS.TASK_ID, > > MSP_TASKS.TASK_IS_SUMMARY, MSP_TASKS.TASK_START_DATE, > > MSP_TASKS.TASK_FINISH_DATE, MSP_TASKS.TASK_NAME, > > MSP_TASKS.TASK_PCT_COMP > > FROM MSP_PROJECTS INNER JOIN > > MSP_TASKS ON MSP_PROJECTS.PROJ_ID = MSP_TASKS.PROJ_ID > > WHERE (MSP_TASKS.TASK_NAME LIKE ' %' + @cabinets + '%') OR > > (MSP_TASKS.TASK_NAME LIKE @deliver + '%') OR > > (MSP_TASKS.TASK_NAME = @shower) OR > > (MSP_TASKS.TASK_NAME = @hardware) OR > > (MSP_TASKS.TASK_NAME = @carpet) AND > > (MSP_TASKS.TASK_START_DATE BETWEEN @startdate AND @endate) > > "Bruce L-C [MVP]" wrote: > > > >> Can you post the query? > >> > >> -- > >> Bruce Loehle-Conger > >> MVP SQL Server Reporting Services > >> > >> "Benw" <Benw@discussions.microsoft.com> wrote in message > >> news:6EF1263D-B3B1-458F-A4D1-F41E5C4D29FB@microsoft.com... > >> >I have a report with a beginning date and ending date. I want all the > >> >data > >> > between those dates. It is set to datetime in the parameters and runs > >> > just > >> > fine except it totally ignores my dates. It gives me just about > >> > everything. > >> > Any suggestions? > >> > >> > >> > >
nevermind, i just added 1 to the enddate parameter with the datedd function
[quoted text, click to view] "Benw" wrote:
> Also how do I get information to pull that is equal to the endate. It only > pulls info from the start date to the day before the endate. > > "Bruce L-C [MVP]" wrote: > > > Try this. Note I'm bracketing all the ORs together and then doing the AND. > > See how this works for you. > > > > WHERE ( (MSP_TASKS.TASK_NAME LIKE ' %' + @cabinets + '%') OR > > (MSP_TASKS.TASK_NAME LIKE @deliver + '%') OR > > (MSP_TASKS.TASK_NAME = @shower) OR > > (MSP_TASKS.TASK_NAME = @hardware) OR > > (MSP_TASKS.TASK_NAME = @carpet)) AND > > (MSP_TASKS.TASK_START_DATE BETWEEN @startdate AND @endate) > > > > > > -- > > Bruce Loehle-Conger > > MVP SQL Server Reporting Services > > > > "Benw" <Benw@discussions.microsoft.com> wrote in message > > news:BBB71DBB-6C41-450B-BE90-7251B86D4479@microsoft.com... > > > oh sorry. > > > SELECT MSP_PROJECTS.PROJ_ID, MSP_PROJECTS.PROJ_NAME, > > > MSP_TASKS.TASK_ID, > > > MSP_TASKS.TASK_IS_SUMMARY, MSP_TASKS.TASK_START_DATE, > > > MSP_TASKS.TASK_FINISH_DATE, MSP_TASKS.TASK_NAME, > > > MSP_TASKS.TASK_PCT_COMP > > > FROM MSP_PROJECTS INNER JOIN > > > MSP_TASKS ON MSP_PROJECTS.PROJ_ID = MSP_TASKS.PROJ_ID > > > WHERE (MSP_TASKS.TASK_NAME LIKE ' %' + @cabinets + '%') OR > > > (MSP_TASKS.TASK_NAME LIKE @deliver + '%') OR > > > (MSP_TASKS.TASK_NAME = @shower) OR > > > (MSP_TASKS.TASK_NAME = @hardware) OR > > > (MSP_TASKS.TASK_NAME = @carpet) AND > > > (MSP_TASKS.TASK_START_DATE BETWEEN @startdate AND @endate) > > > "Bruce L-C [MVP]" wrote: > > > > > >> Can you post the query? > > >> > > >> -- > > >> Bruce Loehle-Conger > > >> MVP SQL Server Reporting Services > > >> > > >> "Benw" <Benw@discussions.microsoft.com> wrote in message > > >> news:6EF1263D-B3B1-458F-A4D1-F41E5C4D29FB@microsoft.com... > > >> >I have a report with a beginning date and ending date. I want all the > > >> >data > > >> > between those dates. It is set to datetime in the parameters and runs > > >> > just > > >> > fine except it totally ignores my dates. It gives me just about > > >> > everything. > > >> > Any suggestions? > > >> > > >> > > >> > > > >
Can you post the query?
-- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Benw" <Benw@discussions.microsoft.com> wrote in message news:6EF1263D-B3B1-458F-A4D1-F41E5C4D29FB@microsoft.com... >I have a report with a beginning date and ending date. I want all the data > between those dates. It is set to datetime in the parameters and runs > just > fine except it totally ignores my dates. It gives me just about > everything. > Any suggestions?
Try this. Note I'm bracketing all the ORs together and then doing the AND.
See how this works for you. WHERE ( (MSP_TASKS.TASK_NAME LIKE ' %' + @cabinets + '%') OR (MSP_TASKS.TASK_NAME LIKE @deliver + '%') OR (MSP_TASKS.TASK_NAME = @shower) OR (MSP_TASKS.TASK_NAME = @hardware) OR (MSP_TASKS.TASK_NAME = @carpet)) AND (MSP_TASKS.TASK_START_DATE BETWEEN @startdate AND @endate) -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Benw" <Benw@discussions.microsoft.com> wrote in message news:BBB71DBB-6C41-450B-BE90-7251B86D4479@microsoft.com... > oh sorry. > SELECT MSP_PROJECTS.PROJ_ID, MSP_PROJECTS.PROJ_NAME, > MSP_TASKS.TASK_ID, > MSP_TASKS.TASK_IS_SUMMARY, MSP_TASKS.TASK_START_DATE, > MSP_TASKS.TASK_FINISH_DATE, MSP_TASKS.TASK_NAME, > MSP_TASKS.TASK_PCT_COMP > FROM MSP_PROJECTS INNER JOIN > MSP_TASKS ON MSP_PROJECTS.PROJ_ID = MSP_TASKS.PROJ_ID > WHERE (MSP_TASKS.TASK_NAME LIKE ' %' + @cabinets + '%') OR > (MSP_TASKS.TASK_NAME LIKE @deliver + '%') OR > (MSP_TASKS.TASK_NAME = @shower) OR > (MSP_TASKS.TASK_NAME = @hardware) OR > (MSP_TASKS.TASK_NAME = @carpet) AND > (MSP_TASKS.TASK_START_DATE BETWEEN @startdate AND @endate) > "Bruce L-C [MVP]" wrote: > >> Can you post the query? >> >> -- >> Bruce Loehle-Conger >> MVP SQL Server Reporting Services >> >> "Benw" <Benw@discussions.microsoft.com> wrote in message >> news:6EF1263D-B3B1-458F-A4D1-F41E5C4D29FB@microsoft.com... >> >I have a report with a beginning date and ending date. I want all the >> >data >> > between those dates. It is set to datetime in the parameters and runs >> > just >> > fine except it totally ignores my dates. It gives me just about >> > everything. >> > Any suggestions? >> >> >>
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |