Recent content by PDAnalyst

Thank you appreciate the tip

Thank you, will do

Hello to all gurus there, I am using CR 2013 linking to an SQL 2016 database as well as doing OLE DB (ADO) connection to multiple excel workbooks. We have main data coming from the SQL database but we still have to keep some of the specific data in different .xlsx spreadsheets. These are...

Thank you for both, as always this site and users are the greatest. You guys and gals have saved me countless hours spent trying to find a way to overcome this and from pulling the few hairs left on my head out, Safa

This is excellent, Thank you very much. [smile]

Yes, it will be for coloring the details section based on the 4 day increments. Thanks

Hello, I am using CR 2013 on an SQL database. I have a request to color records that are in 4 day bins starting from December 31, 2016 in alternate colors (2 colors) so at the end my report should look like: Dec 31, 2016 to Jan 3, 2017 - Color blue Jan 4, 2017 to Jan 7, 2017 - Color green Jan...

Thanks kray4660. I will look at it which might be a viable option. SkipVought, thanks for the pre tag. we usually do not have problem of different E and W since my dispatchers have a geoverification server when the call comes in, they accurately place the address. It is my Police Officers that...

Hi, I am using CR 2013 and connecting to a MS SQL 2014 with Windows 7 workstation. I am looking to see if there is anyway to compare two separate address fields and determine if there is an exact match , close match (70% and above) and no match. As an example, I would like to see the "flag"...

Ok, Thanks for the advice, will try it that way and see if it works

Yes, I have the dates when the case is assigned to the investigator but the dates when an investigator is moved from one assignment group to another is in an access database since the one on the SQL database is not correct

Yes, I have link between the case info and the assignment group (detail) as wel as the investigators. The problem is that the assignment group (detail) in the database is not reliable due to the fact that the secretaries that are supposed to update each of the investigators assignment changes...

I place each investigator to the assigment groups based on their employee number which is field in the database.

Currently, there are groups for each of the assignment types and under these groups, there is a group for each investigator. The details for each case is listed under this. There is no SQL grouping done at the server. All of the grouping is done at the workstation. There are 10 assignment...

Hi, I am using CR 2013 connecting to MS SQL 2008R2 database. I am running yearly reports for cases assigned to our investigations. I have created groups based on the assignment type and number of different officers are in these assignments. Problem that I am facing is that an officer can be...