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 found my answer!! I excluded using the Change Group option . Whoohoo!!

Sorry....I should expand.... These records fall under several different groups... Case 990 case_master_caa44340 - include in sum Party 234 party_name_master_caa44240 - include in sum 45 party_address_assoc_caa83040 - include in sum 55 party_address_master_caa49140 - include in sum Motor 101...

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

After I submitted my question, I found the answer..... Instead of using the Open button to find your document, on the ribbon, click the data tab and then click the "From Text", find your document and go thru the Text Import Wizard. After you finished defining all columns, click the Finish...

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 figured out my problem......distinct! DUH!

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

Absolutely, I will try it out. Thanks again!

Awesome! It worked! Thank you Thank you Thank you!

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

No, I must have been typing when you were responding...thank you for you response. I will try your suggestion and post my results. Thanks again for your time.

I put the version of Crystal on the subject line...CR10 and am using a Informix database. Sorry, should have added it to my text. Table 1 - has Victim information Table 2 - has Recievable information (Restitution assessments) I tried reversing the design, but there are about 80 other...

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

That works great.....Thank you!