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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Creakinator

  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

    Thanks for all of your suggestions.
  3. Creakinator

    Get external data Excel 2007

    Not sure what you mean by 'side by side'. I imported them into the same worksheet, placing each one after each other so that the one worksheet contained all of the files, one after each other.
  4. Creakinator

    Get external data Excel 2007

    Hi Skip, Thanks for you suggestion. I think I described what I did by stating in my post -- 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 grayed out.-- But to be more...
  5. 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...
  6. Creakinator

    If/then/else in Formulas

    Checking for the NULL in the bottom section worked. First Formula is: if {CUSTOMER.T_CUSTOMER_TYPE} = 'SO' then {CUSTOMER.ADDRESS1} else if isnull({CUSTOMER.ADDRESS1}) then {CUSTOMER.COMPANY_NAME} else {CUSTOMER.ADDRESS1} & ' - ' & {CUSTOMER.COMPANY_NAME} Formula...
  7. 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...
  8. 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...
  9. Creakinator

    Report Question

    Thank you for the help. But I am having some issues with this. Do I put all of the following in one formula and ditto with the verifier example also? -------------- @Analyst whileprintingrecords; global datevar assigned; //* The analyst Assigned date I tried using a formula " if...
  10. 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...
  11. Creakinator

    Need to find agency number

    I tried Ian's approach and the report shows no records. Not sure why. The other issue with this approach I have to call these reports from another program that overwrites any select expert settings I've set in the Crystal Report and I'm not sure if I can put that formula in my other program...
  12. Creakinator

    Need to find agency number

    Thanks. I had to make one change in the formula you gave me above. I put a not in front of the isnull and it is working for most of the records. There are a few that are not showing the agency case number at all and I can't figure out why. I put the not in the formula as the subcase records...
  13. Creakinator

    Need to find agency number

    I am grouping by user_name which is from another table x_aproval, but when I removed that grouping and did what you indicated, the formula field (fmAgencyNumPC) I put on the report is coming out empty. Here are the formulas I used (they are named differently): //fmParentcase (I grouped by...
  14. Creakinator

    Need to find agency number

    Here's some data from cases table name T_agency_ref Parent_case stat1 stat2 stat3 11-12345 2345RT null null null null 11-12345-L-01 Null 11-12345 1 3 4 I want to display the t_agency_ref for the parent case but...
  15. 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...

Part and Inventory Search

Back
Top