Search results for query: *

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

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

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

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

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

Hi, I am using CR 11.5, windows XP SP3 connecting to a MS SQL2008 Database through ODBC. I have a report that shows all Calls that came from different apartment complexes. I have created a group that seperates these Calls into different apartment conmplex names. In certain months, some of the...

Hi, I am having a very unique problem that our dba's can't figure out. I am using CR XI R2 SP6 to connect to a new SQL Server 2008 R2 database that had been upgraded from SQL Server 2000. I have been using ODBC Native SQL connection ver2005 until now with no problems on the old database. Ever...

Hi, I am trying to find any experts out there to guide me on how to insert javascript to Crystal Reports Ver 11 R2. This is to circumvent the mailto syntax limitation when the body of the email exceeds ~940 characters (mailto syntax coupled with MS outlook will not send any longer body...

Hi, I am using CR 11R2 on a windows XP machine, data stored on an Oracle 9i database. I have a report that lists all of the comments made during a call. My officers would like to be able to send these comments by using a simple button push to selected apartment managers. I have manage to write...

Hi, we are testing Sharepoint 2007 for our department. We have created a blog using it and now are wondering if there is any way to insert an image to the comments when a person makes a comment to the original posting. Thanks S. Egilmez

Hi, I am using Crystal Reports 11 to create a daily report then export it with Acrobat 9 Pro and e-mail it to specific users. The users open it in Adobe Reader 9. What they would like to do is to be able to copy a section of the pdf document and drop it into an e-mail. I know that it can be...

Hi, I am using CR 11R2 on a Windows 2003 server that hits a MS SQL 2007 database running on a Windows 2003 server. I have created a scheduled task to run the CR at 4am in the morning. The report succesfully runs and creates an output. But even after the output is created, the CR still tries to...

Hi, I am running CR 11 R2 on a windows XP Pro machine. I have two seperate excel worksheets (one in excel 2003 and other in 2007 format) that has the data for stolen vehicles for Year 2009 (full year and this is in excel 2003 format) and YTD 2010 (YTD values in excel 2007 format, being updated...

Hi, I have been instructed to see if there is a way to extract specific portion of a text from a pdf document and automatically insertt into the body of an e-mail? This pdf document is created automatically by Crystal Reports and now the users want to email specific sections to different...

Hi, We are designing a Sharepoint 2007 site to be used in a 24 hour operation. The users will be doing blog updates and other messaging from their vehicles. At night time, they want to have the background color of the pages to be dark and fonts white or yellow (to preserve night vision) and at...

Hi, I am using CR 11R2 on a Windows XP SP3 machine, querying against a MS SQL Database. What I am trying to achieve is if there is a way for the query to be formed by reading an external excel spreadsheet. I have other users that are adding names to an excel spreadsheet for their future use...

Hello, I am trying to write a python code which will be used in GIS environment to select certain records based on the values of a field. I am using Win XP SP3 with Python 2.5.1 Before switching to Python 2.5.1, this VB code section was working in Python 2.4 Ever since the upgrade, VB code...

Hi, I am using CR11 that hits an Oracle database to pull daily arrestee records. I have created a main report and two sub-reports. The main report has the information regarding their unique ID as well as the location of arrest, one subreport has their information (name, height, weight, previous...

Hi, I am using CR XI on a SQL server with an OS XP. I have created a main report that selects certain types of Calls (Priority 1 and 2)and only interested in showing the priority 1 calls detail comments when a user wants to see it. I created an on-demand subreport but the problem is that...