Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
StartDate and EndDate not filter

Answered StartDate and EndDate not filter

  • Friday, January 04, 2013 2:46 AM
     
     
    Sign In to Vote
    0

    Hi..

    I try to create parameter Start Date & End Date in my report. My problem is, where i put or enter any date, the data will show all record available in my database. Parameter is not filter my data. Need help.

    Field name for date in my database is = IDS_REPAYSTARTDATE


    • Edited by M. LUQMAN Friday, January 04, 2013 2:49 AM
    •  
     

All Replies

  • Friday, January 04, 2013 2:54 AM
     
     
    Sign In to Vote
    0

    Hello,

    Check it in your SQL the parameter you are passing trough report is working fine in sql ?  or you are passing the parameter in same format as it is in SQL ?  or post your SQL


    blog:My Blog/

    Hope this will help you !!!
    Sanjeewan


     
  • Friday, January 04, 2013 2:58 AM
     
     
    Sign In to Vote
    0

    Hello Sanjeewan Kumar

    SELECT IDS_REPAYSTARTDATE FROM IDS_STDISBURSETABLE

     
  • Friday, January 04, 2013 3:13 AM
     
     
    Sign In to Vote
    0

    Hello,

    SELECT IDS_REPAYSTARTDATE FROM IDS_STDISBURSETABLE where IDS_REPAYSTARTDATE between @startDate and @EndDate and map these parameter with report parameter

    for more detail see this link adding parameter to Report

    http://msdn.microsoft.com/en-us/library/aa337432(v=sql.105).aspx


    blog:My Blog/

    Hope this will help you !!!
    Sanjeewan

     
  • Friday, January 04, 2013 3:28 AM
     
     
    Sign In to Vote
    0

    I already try types this code

    =SELECT IDS_REPAYSTARTDATE FROM IDS_STDisburseHistory where IDS_REPAYSTARTDATE between @startDate and @endDate

    but cannot run. contains error

     
  • Friday, January 04, 2013 3:32 AM
     
     
    Sign In to Vote
    0

    Hello

    Check your IDS_REPAYSTARTDATE date format  or try to convert the date format to parameter dateformat

    or try this on

    SELECT IDS_REPAYSTARTDATE FROM IDS_STDisburseHistory where convert(varchar(10), IDS_REPAYSTARTDATE,101) between convert(varchar(10), @startDate,101) and convert(varchar(10),@endDate,101)

    or post some sample data


    blog:My Blog/

    Hope this will help you !!!
    Sanjeewan



     
  • Friday, January 04, 2013 3:39 AM
     
     
    Sign In to Vote
    0

    Hi luqman,

    your report data must be comming form your data source. This may be using a procedure or query.

    Create two parameters and map these to your report source.

    thanks

    kumar

     
  • Friday, January 04, 2013 3:41 AM
     
     
    Sign In to Vote
    0

    This is field for IDS_REPAYSTARTDATE

     
  • Friday, January 04, 2013 3:55 AM
     
     
    Sign In to Vote
    0

    Here my full step. Hope you understand.

    Full screen => http://social.msdn.microsoft.com/Forums/getfile/215444


    • Edited by M. LUQMAN Friday, January 04, 2013 6:44 AM
    •  
     
  • Friday, January 04, 2013 6:14 AM
     
     
    Sign In to Vote
    0

    Hello,

    don't put any query in default value just put any Date like 01/01/2012 in start date or end date or if you want a qury then check get value from query and write your query there and map query value there with report parameter


    blog:My Blog/

    Hope this will help you !!!
    Sanjeewan

     
  • Friday, January 04, 2013 6:38 AM
     
     
    Sign In to Vote
    0

    Error?


     
  • Friday, January 04, 2013 7:00 AM
     
     Proposed Answer
    Sign In to Vote
    0

    Hello,

    I have uploaded a .rdl file in this link reproducing your problem using Adventure work Database just change your datasource and execute

    datasource =DataSource1

    Initial Catalog=AdventureWorks

    dataset=dataset1

    Query is

    Select * from Production.Product where convert(varchar(10),ModifiedDate,101) between Convert(varchar(10),@startDate,101) and convert(varchar(10),@enddate,101)

    In this .rdl check, Parameter datatype as well

    https://docs.google.com/file/d/0BwGjfQMwP9R0UnVVU3BjbFRwTVk/edit


    blog:My Blog/

    Hope this will help you !!!
    Sanjeewan



     
  • Monday, January 07, 2013 10:46 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hello,

    Just as Sanjeewan post above, you can specify the dataset query to filter the data before them retrieved form database. Or you can specify the filter condition to filter the report data, please refer to the following screen shot:

    (Note: specify the dataset query as follows:
    SELECT IDS_REPAYSTARTDATE FROM IDS_STDisburseHistory)

    Regards,
    Fanny Liu

    Fanny Liu
    TechNet Community Support

    • Marked As Answer by M. LUQMAN Tuesday, January 08, 2013 8:18 AM
    •  
     
  • Friday, January 18, 2013 2:11 AM
     
     
    Sign In to Vote
    0

    Hi..

    Currently I using Expression. For Start Date and End Date what is the expression need to use?


    • Edited by M. LUQMAN Friday, January 18, 2013 2:59 AM
    •  
     
  • Monday, January 21, 2013 2:06 AM
     
     
    Sign In to Vote
    0

    Fanny Liu.

    Can u give the expression code for StartDate and EndDate?

    What error in my expression?

    =iif((Fields!IDS_DisburseDate>=Parameters!StartDate and Fields!IDS_DisburseDate<=Parameters!StartDate)

    • Edited by M. LUQMAN Monday, January 21, 2013 2:32 AM
    •