Search results for query: *

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?

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

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

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

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

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

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

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

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

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

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

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

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

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

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?

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

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

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?

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