Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: PDAnalyst
  • Content: Threads
  • Order by date
  1. PDAnalyst

    Placing different data fields into the same location at the Details section

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

    Alternate coloring of records based on 4 day intervals

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

    Compare two fields for full or partial match

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

    Custom group based on an employees assignment dates

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

    customize blog text box (body)

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

    How to improve Virtual machine performance on server 2008

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

    Display Groups with no values in the report along with goups w/ value

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

    MS SQL Server 2008 connection problem

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

    Insert javascript to Crystal Reports

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

    Limitation of mailto hyperlink

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

    insert picture to blog comments section

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

    Programatically call copy text tool

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

    CR Query continuously hits SQL database

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

    Comparing Data in specific time frames from two sources

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

    extract text from pdf and paste it into an email body

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

    Change Background and Font Color on demand

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

    Creating query by reading records from an excel sheet

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

    Select records based on pattern

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

    Grouping based on highest priority statute class

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

    Hyperlinking subreport to show in a web-page

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

Part and Inventory Search

Back
Top