Report: investigations by complainant over date range

[rssidlowski]

Create a report of investigations over a date range by a specific complainant or set of complainants and group results by complainant and then sort by date for each complainant.

Sample report would be as follows:

Investigations by Complainant for Date Range: 10/1/2014 - 11/12/2014

Complainant: WQMS Name: 4616 Newgate [inv_name] Location: Southwest corner of 4616 Newgate Ave. next to hydrant [loc_desc] Complaint Date: 11/10/2014 [inv_compldate] Problem Type: Sewage [problem_desc from PST_ProblemCodes]

[kanglu666]

done: http://dpwdev.baltimorecity.gov/PSTReport/rptComplaint.aspx?Status=3,2&reportType=status&date1=11/18/2013&date2=11/18/2014

[gjmkelly]

It looks like this is also calling the report for investigations by status over date range. You want the example URL to be like:

http://dpwdev.baltimorecity.gov/PSTReport/rptComplaint.aspx?Complainant=42, 143&reportType=complainant&date1=1/1/2005&date2=12/31/2013http://dpwdev.baltimorecity.gov/PSTReport/rptComplaint.aspx?Complainant=42,%20143&reportType=complainant&date1=1/1/2005&date2=12/31/2013

… Gerry

From: lu [mailto:notifications@github.com] Sent: Tuesday, November 18, 2014 2:57 PM To: rssidlowski/Pollution_Source_Tracking Cc: Gerry Kelly Subject: Re: [Pollution_Source_Tracking] Report: investigations by complainant over date range (#76)

done: http://dpwdev.baltimorecity.gov/PSTReport/rptComplaint.aspx?Status=3,2&reportType=status&date1=11/18/2013&date2=11/18/2014

— Reply to this email directly or view it on GitHubhttps://github.com/rssidlowski/Pollution_Source_Tracking/issues/76#issuecomment-63534181.

[rssidlowski]

Correct typo: 'compainants' should be 'complainants' in the top line where it has: "includes following complainants" Correct typo in summary: 'investiagations' should be 'investigations'.

[rssidlowski]

In the activity manager, the complainant in the table below is empty and in this case should be populated with 'Blue Water Baltimore'

[kanglu666]

fixed, please test

[gerrykelly]

I corrected the typo. Report file updated in: "\VM-1108S08\AllReports\rptInvComplainantDate.rdlc"

[rssidlowski]

Please correct the misspelling of 'investigations'.

[gjmkelly]

Lu, please replace rdlc file at City with "K:\User_VM\Gerry___temp\rptInvComplainantDate.rdlc"

[kanglu666]

updated

[rssidlowski]

Verified.