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 Chriss Miller 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: Almie
  • Content: Threads
  • Order by date
  1. Almie

    Formula to pull only records that are less than a year

    I am using CR12 I am drawing a blank! I am trying to write a formula where it will display records that are less than a year old for today's date. The field that I am using is a filing date. Anyone?
  2. Almie

    Display records with identical field data

    Using Crystal Enterprise 10. I am trying to write a report which will only display cases that have the identical statute_code. For example: Case1 Statute_code1 - 28-701A Statute_code2 - 28-7111 Statute_code3 - 28-701A Case2 Statute_code1 - 28-745 Case3 Statute_code1 - 28-732...
  3. Almie

    Display record with identical field data

    Using Crystal 10. I am trying to write a report which will only display cases that have the identical statute_cd. For example: Case1 Statute_code1 - 28-701A Statute_code2 - 28-7111 Statute_code3 - 28-701A Case2 Statute_code1 - 28-745 Case3...
  4. Almie

    Need help with concatenation - Concatenate the data from two columns to the data in main column

    I am using SQL2012, Using SSMS, I am trying to concatenate data from two columns into a columns that already has data. The Class_id and Qual_id are in the Statute table, BUT, I need to write a select statement to pull the Class _Code referencing the Class_id from the Class table and the same...
  5. Almie

    SQLServer - Receiving error number -1071607685

    Using SQL Server 2012, I am moving from an Informix database to a SQL database. During the move, there are hidden characters in the Informix database that SQL Server does not like so the records are falling out. When I look at the Violation tables with the invalid records, I see the error...
  6. Almie

    Trouble with conditional sum

    I am using Crystal 10. I am trying to get a sum amount of only specific detail items. Here is an example 990 case_master_caa44340 - include in sum 234 party_name_master_caa44240 - include in sum 45 party_address_assoc_caa83040 - include in sum 55 party_address_master_caa49140 - include...
  7. Almie

    Can't find custom cell style when using the Text Import Wizard feature

    I am using Excel 2007. I have a custom cell style saved in both my default Sheet template also my default Book template. When I open a Tab delimited file in Excel, after I have selected all options using the Text Import Wizard and I can see my data in a worksheet. I click on Cell Style, and...
  8. Almie

    Help with Update query

    I am trying to update Table1 AVTGUID column with the AVTGUID data from Table2. When I run my update query, both avtguid columns in Table 1 are updated with the avtguid from the first record in Table 2. Table 1 - getting avtguid updated avtguid offense_id offense_typ_id effective_date...
  9. Almie

    Find overlapping dates for specific code

    I trying to write a query that will tell me for a specific code, if the effective date and end dates overlap. Here is an example of a record with 3 codes with effective and end dates. Code Effect_date End_date AHS 1/1/1900 7/6/2007 AHS 7/7/2007 12/31/2099 AHS 1/1/2009...
  10. Almie

    Find overlaping dates for one specific Code

    Using SQLServer2008, I trying to write a query that will tell me for a specific code, if the effective date and end dates overlap. Here is an example of a record with 3 codes with effective and end dates. Code Effect_date End_date AHS 1/1/1900 7/6/2007 AHS 7/7/2007...
  11. Almie

    CR10 - Subreport variable and group select issues

    My report consist of a Main report and a subreport. I am trying to get a list of cases where their is a victim on the case, but no Restitution assessment exists for the Defendant. Subreport - I have pulled a Case list where Defendant has been assessed Restitution ( Recievable type: "R"). 6 Group...
  12. Almie

    How to sort records depending on group results

    I am using Crystal 10 pulling from a Informix database. My objective is to sort records depending on the group results. Table: Party Aging rejects Group by Object rejects results1: Object rejects: Rejects from Party aging to Party Name Master table: need to sort by Party Name results2...
  13. Almie

    date falls between a a minimum and maximum date range.

    I am using Crystal 10 and need a formula that validates whether a violation date falls between a minimum and maximum date range. Here are my variables: variable_1: v_voil_date:= violation_date variable_2: v_from_date:= minimum (effective from_date) variable_3: v_to_date:=...
  14. Almie

    Separate sorting for each change of group

    I am using Crystal 10, and was wondering if anyone knew how to perform separate sorting for each change of group. Let me explain. group1: foreignkey_violation_records cog1 - eventledger_bond_type - records with invalid bond types, need it to sort/group bond type alphabetically cog2 -...
  15. Almie

    Why does Crystal change my string data to a date

    I am using Crystal 10, pulling from a Informix database. The field type is a string, the data in the record is "3-2007". When the records display in Crystal, it is displaying "Mar-13". HOw can I make the data display "3-2007" which is what is stored in the table record?
  16. Almie

    Minimum date between two date fields

    Running CR10 against a Informix database. In my main report, I have a sentence date, where date can be null. In my subreport, I have a receipt date, with receipts date can be null. I've created a shared variable to pull the receipt date and placed the formula in the group footer. I need to...
  17. Almie

    Convert a string to a integer

    I am using a Informix database. I have a concatenated case number,data type of a string (S-0100-CR-20010101) that I am trying to parse into four different fields that will link to another table where the case number already separated into four fields (S string(4),0100 integer, CR...
  18. Almie

    Change window view layout in Business View Manager

    Does anyone know how to change/refresh the view layout in Business View Manager. When I select View from the menu bar, it tells me that the repository Explorer is selected but I can't see it on my screen. Can anyone help?
  19. Almie

    Exclude records from report

    I am using Crystal Report 10 I would like to know how to exclude party that have a code "9750" posted to their docket. Sample data: cs_typ cs_num p_typ p_num evnt_cd CR 2003101 D 1 206 CR 2003101 D 1 9750 CR 2004122 D 1 206 CR...

Part and Inventory Search

Back
Top