Hi Expert,
I have created a SSRS report fetching cases in a date range which has 4 parameters (Start Date, End Date, Status, Priority). Now below is the detail of my report. The issue is with Date. The report is not retrieving all the record in date range. The query is giving correct result in Query designer but while doing preview all the records are not coming. In advanced find the record are coming but not in report. Please suggest where am I missing.
=cdate(Format(DateAdd("M", -1, Today),"yyyy-MM-dd")) --> default value for @startdate
=cdate(Format(Today,"yyyy-MM-dd")) --> default value for @enddate
=Format(Parameters!startdate.Value, "yyyy-MM-dd") --> default value for @startdatevalue =Format(Today,"yyyy-MM-dd")) --> default value for @enddatevalue
Parameters:
@startdate= DateTime
@enddate=DateTime
@startdatevalue= Text (hidden)
@enddatevalue=Text (hidden)
FetchXml:
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false"> <entity name="incident" > <attribute name="createdon" /> <attribute name="createdby" /> <attribute name="modifiedon" /> <attribute name="modifiedby" /> <attribute name="ticketnumber" /> <attribute name="title" /> <attribute name="statecode" /> <attribute name="prioritycode" /> <attribute name="customerid" /> <attribute name="firstresponsesent" /> <attribute name="lastonholdtime" /> <attribute name="kbarticleid" /> <attribute name="ownerid" /> <order attribute="createdon" descending="true" /> <filter type="and"> <condition attribute="createdon" operator="on-or-after" value="@startdatevalue" /> <condition attribute="createdon" operator="on-or-before" value="@enddatevalue" /> <condition attribute="prioritycode" operator="in" value="@priority" /> <condition attribute="statecode" operator="in" value="@status" /> </filter> </entity> </fetch>
Regards,
Saroj
