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!

  • Congratulations wOOdy-Soft 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: *

  1. Creakinator

    XML Refresh Issue

    I have a Crystal Report based on an XML connection which is produced by another program. I've made the report and saved it with "Save data to report" unchecked. The report works very well with the first report. But when I update the XML file with new data, the report shows the old data. I...
  2. Creakinator

    Get external data Excel 2007

    I have a number of csv files to combine into an excel spreadsheet. I'm doing this by hand as I only have to do this once. I pulled the data into the worksheet by "Get External Data" "From Text". I was able to pull the data from three different csv files, then the button on the ribbon was...
  3. Creakinator

    If/then/else in Formulas

    This is a very basic issue but I can't seem to get it to work. First off - CRXI with SQL server 2005. I have two formulas that I need someone to point out my mistake in: 1. First formula //============== if {CUSTOMER.T_CUSTOMER_TYPE} = 'SO' then {CUSTOMER.ADDRESS1} else...
  4. Creakinator

    HTML text boxes not formatting properly

    Hi Everyone, I have a text field that is set as an HTML format. The query is pulling a field from the database that is HTML formatted and all of the HTML formatting shows correctly but here is my problem. The HTML field doesn't know how to properly deal with periods that have no spaces on...
  5. Creakinator

    Report Question

    Some day I hope to understand how to do things in CR. Right now I am so grateful for the helpful folks in this forum. I have a report that has this data Incident_Type Case# Approval Type Assigned date Esig date Turn around time Burglary 11-1111 analyst 11/11/2011...
  6. Creakinator

    Need to find agency number

    I'm not sure if this is the right forum or not as I'm not sure if a formula or a sql expression will do this for me. SQL databse through an ODBC connection Crystal Reports XI I have a table name 'cases' that has a field 'T_AGENCY_REF'. In this table I have both 'parent' cases and 'sub' cases...
  7. Creakinator

    Date Diff between two records

    I'm brand new to CR and need to do a turn around time report. CR11 with a SQL database. Here's the pertinant data: Table name is x_approval CASE# User_name Approval_Type Assigned_Date Esig_date 11-01855-N-01 GEORGE ANALYST 3/24/2011 7:23:06 AM 4/11/2011 10:03:33 AM...

Part and Inventory Search

Back
Top