Asked by:
SSRS date parameter filter not working

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