locked
SSRS date parameter filter not working RRS feed

  • Question

  • Hi All;

    I have the date parameter 

    As per this date parameter i need to select the event name 

    but it displays blank 

    below is my query for Event name 

    <fetch mapping="logical">

     <entity name="crmi_ebevent">
        <attribute name="crmi_name" />
        <attribute name="crmi_ebstartdate"/>
        <attribute name="crmi_ebeventid"/>

    <filter type ="and">
            <condition attribute="crmi_ebebstatus" operator="in" value="@Status"  />
    <condition attribute="crmi_ebstartdate" operator="ge"  value="@Search"  />
    <condition attribute="crmi_ebenddate" operator="lt"  value="@Search1"  />

    </filter>
      </entity>
    </fetch>

    Any help much appreciated

    Thanks


    Pradnya07

    Tuesday, October 28, 2014 1:13 PM

All replies

  • Use your filter as

    <condition attribute="crmi_ebstartdate" value="@Search" operator="on-or-after"/>
    
    <condition attribute="crmi_ebenddate" value="@Search1" operator="on-or-before"/>
    


    Regards, Saad

    Tuesday, October 28, 2014 1:31 PM
  • Hi Its still the same 

    My date parameter query is as below 

    <fetch distinct="true" mapping="logical">
     <entity name="crmi_ebevent">



    SET @Search = COALESCE(@Search ,'1900-01-01')
    SET @Search1 = COALESCE(@Search1,'1900-01-01')
        <attribute name="crmi_ebstartdate" />
        <attribute name="crmi_ebenddate" />
    <filter type ="and">
           

    <condition attribute="crmi_ebebstatus" operator="in" value="@Status"  />

    </filter>

    <order attribute="crmi_ebstartdate" />

      </entity>
    </fetch>


    Pradnya07

    Tuesday, October 28, 2014 1:57 PM
  • May be this can help 


    Pradnya07

    Tuesday, October 28, 2014 2:07 PM
  • Hi Simran,

    Use your start date parameter in place of @Search and End Date Parameter in place of @Search1.

    Also please check whether date formats in CRM and in parameters are same. If not try to convert both in same formats.

    In your example:

    SET @Search = COALESCE(@Search ,'1900-01-01')
    SET @Search1 = COALESCE(@Search ,'2014-10-28') 

    Also try adding time at the end. Try this


    Regards, Saad


    • Edited by Mohd Saad Tuesday, October 28, 2014 3:11 PM
    Tuesday, October 28, 2014 2:50 PM