Search results for query: *

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...

Hi, I am trying to find a way to customize the blog text entry box(body of message). I need for my officers to enter specific data and in order for them not to skip entering this data, it would be nice if I can create a custom form that will collect the data and then import it into the blog...

Thanks for the response cajuntank. Our Servers that will host VM has 4 logical Quad core Xeon's and each of the logical Xeon's are assigned to single VM (total of 4 VM is running on a single physical server). Also the regular VM set-up was for 4 to 8Gb of memory for each VM but I was able to...

Hi, First posting on this thread, sorry if I am going to sound like a noob (I am a noob when it comes to servers). Our agency is looking to give us a MS Virtual Server 2008 for our new project, a data mining application (ISYS). I would like to have it run on the fastest environment as...

You are correct, I have made the join from the Incident table to the helper table. I will change it the other way around and see how that goes, Thanks

I have attached the helper file to the main table where the addresses are stored bu using a left join. I then created the grouping using the helper files apartment names but still it skips over the apartment complex name where there is no Call this month.http://www.mediafire.com/i/?fc3qwaa88gglhvc